Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5537 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rock
Before grouping the dataset first compress the dataset
using compress=yes option whicle creation of dataset like
data x(compress=yes reuse=yes);
set y;
run;
proc sql;
select --- do the grouping now
Sure that sorting will take less time. Try this once
Main trick here is we are compressing the unused space in
dataset so the size of the dataset will get reduce.
| Is This Answer Correct ? | 2 Yes | 0 No |
why is the use of Retrive statement and give me with example?
i want to upload titles and footnotes to excel file?how it is possible?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
what is option year cuttoff in sas
what is in stream data in SAS?
what is lifetest
Under what circumstances would you code a SELECT construct instead of IF statements?
How do you download a flat file from Mainframe to your local PC using SAS?
how can get the first and last observations in a dataset using Proc SQl?
it will become easy if uuu provide website linkssss and list of consultanciessssss
What is highest missing value for numeric?
Teradata 
