Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how to rearrange the data as our wish by using dataset block?

Answers were Sorted based on User's Feedback



how to rearrange the data as our wish by using dataset block? ..

Answer / xyz

use retain statement before the set statement

Is This Answer Correct ?    5 Yes 1 No

how to rearrange the data as our wish by using dataset block? ..

Answer / srinivas anumalla

Probably there are many options,like id statement,proc sort.
As Some body said retain is not for that operation.

But i strongly suggest Proc sort.

Is This Answer Correct ?    1 Yes 0 No

how to rearrange the data as our wish by using dataset block? ..

Answer / raaman

data Temp;
input Sno Sname $ Eng Maths Sci Soc;
cards;
1212 Smith 67 78 89 98
2334 Lisa 78 89 99 87
;
run;

data Temp1;
retain Sname Sci Eng Maths Soc Sno;
set Temp;
run;

proc print data = Temp1;
title "1.Use of Retain Statement";
run;

use retain statement before the set statement

Is This Answer Correct ?    1 Yes 0 No

how to rearrange the data as our wish by using dataset block? ..

Answer / nani

by using id statement
proc print data=dsn;
id var3 var5 var1;
run;

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SAS Interview Questions

How to select the observations randomly from a SAS dataset

7 Answers   NTT Data,


data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.

1 Answers  


what is SAS/Access and SAS/Connect?what are the uses?

3 Answers  


Mention sas system options to debug sas macros.

0 Answers  


What are the different servers in sas? : sas-grid-administration

0 Answers  


Difference between sum function and using “+” operator?

0 Answers  


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

0 Answers  


How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 Answers  


How can you put a "trace" in your program?

2 Answers   Quintiles,


what is the use of sas management console? : Sas-di

0 Answers  


What is a pdv and what are its functions?

0 Answers  


Of all your work, where have you been the most successful?

0 Answers   Oracle, Six Sigma,


Categories