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

What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

2 Answers   ABC, CitiGroup, ASD Lab,


What is the difference between verification and validation?

9 Answers   Oracle,


What does error:1 mean?

8 Answers   Accenture,


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

0 Answers  


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?

2 Answers  






how to remove the duplicates by proc sql?

2 Answers   Genpact,


how to import HTML files into SAS datasets?

3 Answers   HP,


Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   DELL,


What do the SAS log messages "numeric values have been converted to character" mean?

0 Answers   Quintiles,


Can we replace a dataset into view?

6 Answers   CliniRx,


For what purpose(s) would use the RETURN statement?

1 Answers  


The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?

6 Answers   Oracle,






Categories