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 find out no. of business days in a month using macros.???(excluding weekends and holidays).
What does the RUN statement do?
Explain the difference between using drop = data set option in set and data statement?
what are the validation tools in sas?
Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
What are the uses of sas?
what is the difference between DUPKEY and NODUPKEY???
For what purpose(s) would use the RETURN statement?
how can you import .csv file in to sas? : Sas programming
code the tables statement for a single level frequency?
is data integration and etl programming is same? : Sas-di