how to rearrange the data as our wish by using dataset block?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / nani
by using id statement
proc print data=dsn;
id var3 var5 var1;
run;
| Is This Answer Correct ? | 0 Yes | 1 No |
How to select the observations randomly from a SAS dataset
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.
what is SAS/Access and SAS/Connect?what are the uses?
Mention sas system options to debug sas macros.
What are the different servers in sas? : sas-grid-administration
Difference between sum function and using “+” operator?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
How can you put a "trace" in your program?
what is the use of sas management console? : Sas-di
What is a pdv and what are its functions?
Of all your work, where have you been the most successful?