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 |
Are you familiar with special input delimiters How are they used?
Describe the function and untility of the most difficult SAS macro that you have written.
explain the concepts and capabilities of business object? : Sas-bi
State the difference between INFORMAT and FORMAT ?
where are dashboard components are created and maintained? : Sas-bi
how do you test for missing values? : Sas programming
What are pdv and it functions?
How do you add a number to a macro variable?
how can u extract,transform and loading?
How to get the repeated values by using sql in sas ?
What r all the reporting procedures...?
I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?