hi guys ...i have one query...
data abc;
input s w k g o t a m;
cards;
1 2 3 4 5 6 7 8
2 3 4 5 6 7 8 9
;
run;
i want the output to be the sorted order(only
variables).observations should not be changed..
Answer Posted / ashish
proc contents data=abc out=test;
quit;
proc sort data=test;
by name;
quit;
proc sql;
select name into: v_name separated by " " from test;
%put &v_name;
quit;
data abc2;
retain &v_name;
/*retain a g k m o s t w ;*/
set abc ;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does the trace option do?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Explain the use of proc print and proc contents?
what are informats in sas? : Sas-administrator
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
describe how to adjust the performance of data integrator? : Sas-di
What are the difference between the sas data step and sas procs?
Mention common programming errors committed in sas ?
Describe the ways in which you can create macro variables? : sas-macro
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
explain the proc in sas? : Sas-administrator
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What is the difference between nodupkey and nodup options?
how could you generate test data with no input data? : Sas programming