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
- 5440 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What do you code to create a macro? : sas-macro
How to convert a numeric variable to a character variable?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What are the data types in sas?
which date functions advances a date time or date/time value by a given interval? : Sas programming
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
Which are the statements whose placement in the data step is critical?
What are the scrubbing procedures in sas?
What was the last computer book you purchased? Why?
Can you execute macro within another macro? : sas-macro
How many data types are there in SAS?
What do you know about sas data set?
what is intially documentation in sas?
