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
- 5411 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 |
How to read an input file in sas?
What is the difference between reading data from an external file and reading data from an existing data set?
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
How long can a macro variable be? A token? : sas-macro
What’s the difference between var b1 – b3 and var b1 — b3?
WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore
Under what circumstances would you code a SELECT construct instead of IF statements?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What do you know about sas data set?
Teradata 
