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 |
what are several options for creating reports in web report studio? : Sas-bi
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Name statements that are execution only.
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
how many types of MERGE?
In SAS explain which statement does not perform automatic conversions in comparisons?
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
how do you read binary data in sas?
What are the table names in oracle database...?
What is the difference Using & and && in the macro variables
If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
tell me about use of arrays in sas