how to rearrange the data as our wish by using dataset block?
- 4 Answers
- 7786 Views
- Cognizant, I also Faced
- E-Mail Answers
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 is the difference between reading data from an external file and reading data from an existing data set?
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
What is the pound sign used for the DATA _NULL_?
What are the default statistics that proc means produce?
how to rearrange the data as our wish by using dataset block?
How would you delete duplicate observations?
How would you code the criteria to restrict the output to be produced?
Do you know the features of sas?
Which are the statements whose placement in the data step is critical?
What are the advantages of using sas?
Name and describe three SAS functions that you have used, if any?
What are the rows present in protocol Violation table?
2 Answers Accenture, Quintiles,
Teradata 
