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
what are some differences between proc summary and proc means? : Sas programming
In proc transpose and data step with arrays which one you pick?
What are the features of SAS?
What is the difference between class statement and by statement in proc means?
where are dashboard components are created and maintained? : Sas-bi
what is data access? : Sas-di
name some data transformation used in sas di? : Sas-di
Difference between informat and format?
why is sas considered self-documenting? : Sas programming
Explain why double trailing @@ is used in input statement?
Explain the purpose of retain statement.
How many ways to overcome a missing values???
it will become easy if uuu provide website linkssss and list of consultanciessssss
Do you know the features of sas?
what are sas bi dashboard components? : Sas-bi