how can you sort the dataset having millions of OBS(instead
of sort procedure?
Answers were Sorted based on User's Feedback
Answer / ram
using there TAG SORT. it is more efficient than Sort procedure.
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / venkatesh
by using proc format u can do sort in eficient wway
but u need to use cntlin for dataset
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / chandrakanth
proc sql;
create table dataset-name as select * from source-dataset-name group by sorting-variable-name;
quit;
GROUP BY option is for sorting the data.
Please let me know if you have more questions
Is This Answer Correct ? | 4 Yes | 5 No |
What is maximum storage capability of SAS?
Give e an example of..
explain what is factor analysis? : Sas-administrator
Can you execute macro within another macro? : sas-macro
What do you feel about hardcoding?
Why and when do you use proc sql?
what is the use of proc sql?
WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?
How would you code the criteria to restrict the output to be produced?
Do you think professionally?
what is hash files in sas and why we are using this one in sas?
1.we can execute a macro with in a macro,by using call symput and symget can any one give me one example? 2.We can create the macro variables by using %let,%do,macro parameters,INTO clause in proc sql and call symput, can any one give me example to create macro variable with INTO clause and call symput? 3.