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 |
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?
Explain translate function?
what is sas data set?
What report output formats can you generate using SAS?
Define run-group processing?
What is a method to debug and test your SAS program?
Describe the function and utility of the most difficult SAS macro that you have written?
what is the difference between proc means and proc summary?
in which companies SAS openings are there? List of companies using SAS technology.
How to create an external dataset with sas code?
What are the 3 components in sas programming?
How do I CREATE an external dataset with sas code? I would like to create within a sascode a non-exsistent textfile on the host. So I am not forced to create the file befor filling it.