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 |
Name statements that function at both compile and execution time?
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
Can anyone help me about SAS Realtime scenarios in Clinical field
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
data abc; input x y ; cards; 1 2 5 6 7 8 7 8 1 7 5 7 ; run; Proc Freq data=abc; tables x*y / chisq nopercent nocol norow PLCORR; RUN; If we run the code, we have Polychoric Correlation = 0.9054 in the last table. I want to extract this particular entry with the value. Means I will create one dataset in which this value will be stored/extracted. I need your help in coding this. Please help me out.
what type of graphs we will create(for 2+years candidates)?
what is data governance? : Sas-di
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
What can you learn from the SAS log when debugging?
in ods is there any lib's
Describe what are the different levels of administrative users in sas? : sas-grid-administration
Describe a time when you were really stuck on a problem and how you solved it?