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




Answers were Sorted based on User's Feedback



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 1 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 3 No

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 / solasa

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

Is This Answer Correct ?    1 Yes 2 No

Post New Answer



More SAS Interview Questions

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  


I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,


If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?

3 Answers   Accenture,


i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,


I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 Answers  






If you could design your ideal job, what would it look like?

0 Answers   Oracle,


What is the difference between nodup and nodupkey options?

20 Answers   iFlex, Makro, Talwar,


Do you prefer Proc Report or Proc Tabulate? Why?

9 Answers   Oracle,


how to do user inputs and command line arguments in sas?

0 Answers   D&B, TCS,


How to get part of string form the source string without using sub string function in SAS?

3 Answers  


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

0 Answers   Blue Star,


CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

4 Answers   CybAge,






Categories