how can you sort the dataset having millions of OBS(instead of sort procedure?

how can you sort the dataset having millions of OBS(instead
of sort procedure?

Question Posted / ram

4 Answers
10466 Views
EXL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can you sort the dataset having millions of OBS(instead of sort procedure?..

Answer / ram

using there TAG SORT. it is more efficient than Sort procedure.

Is This Answer Correct ?

4 Yes

4 No

how can you sort the dataset having millions of OBS(instead of sort procedure?..

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

how can you sort the dataset having millions of OBS(instead of sort procedure?..

Answer / solasa

Using INDEX option save the cpu time and helps in fast
processing

Is This Answer Correct ?

1 Yes

2 No

how can you sort the dataset having millions of OBS(instead of sort procedure?..

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

Post New Answer

More SAS Interview Questions

what is the difference between proc report and proc format?

7 Answers CTS,

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

0 Answers

data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?

3 Answers

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers WNS,

Name statements that function at both compile and execution time.

3 Answers L&T,

what are validation tools that are used in sas? : Sas-administrator

0 Answers

what is study design in while working with SAS? what are screening variables in SAS?

0 Answers MSCR,

Describe 5 ways to do a “table lookup” in SAS?

0 Answers

What are the uses of sas?

0 Answers

What are the implications?