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 is the difference between class statement and by statement in proc means?
Mention what are the data types does SAS contain?
How would you code the criteria to restrict the output to be produced?
You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..
SAS using companies in chennai
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
how to import HTML files into SAS datasets?
What is the use of PROC gplot?
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?
What do you feel about hardcoding?
what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?
what is validvarname and varnum? why we are using this options; explain with a syntax for this options?