how can you sort the dataset having millions of OBS(instead
of sort procedure?
- 4 Answers
- 9615 Views
- EXL, I also Faced
- E-Mail Answers
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 study design in while working with SAS? what are screening variables in SAS?
which date function advances a date, time or datetime value by a given interval? : Sas programming
Give e an example of..
how can you put a "trace" in your program? : Sas programming
Can you suggest us materials for sdtm mapping?
how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
how to import HTML files into SAS datasets?
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
What are the new features included in the new version of SAS Programming Language?
How would you delete duplicate observations?
Teradata 
