You need to perform an analysis on a massive dataset by
groups, but are unable to sort the data due to memory
constraint. How would you accomplish the task?

Answer Posted / satheesh

you can use index statement,

proc sql;
create index indexname on Tablename(Variable or Columnname);
quit;

the above code is equivalent to sort.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are some differences between proc summary and proc means? : Sas programming

760


In proc transpose and data step with arrays which one you pick?

2794


What are the features of SAS?

797


What is the difference between class statement and by statement in proc means?

901


where are dashboard components are created and maintained? : Sas-bi

789


what is data access? : Sas-di

869


name some data transformation used in sas di? : Sas-di

745


Difference between informat and format?

854


why is sas considered self-documenting? : Sas programming

864


Explain why double trailing @@ is used in input statement?

803


Explain the purpose of retain statement.

804


How many ways to overcome a missing values???

2557


it will become easy if uuu provide website linkssss and list of consultanciessssss

1749


Do you know the features of sas?

807


what are sas bi dashboard components? : Sas-bi

871