how to rearrange the data as our wish by using dataset block?

Question Posted / ram

4 Answers
6958 Views
Cognizant, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to rearrange the data as our wish by using dataset block? ..

Answer / xyz

use retain statement before the set statement

Is This Answer Correct ?

5 Yes

1 No

how to rearrange the data as our wish by using dataset block? ..

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

how to rearrange the data as our wish by using dataset block? ..

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

how to rearrange the data as our wish by using dataset block? ..

Answer / nani

by using id statement
proc print data=dsn;
id var3 var5 var1;
run;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer