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
- 5645 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 |
Tell me more about the parameters in macro? : sas-macro
how can get the first and last observations in a dataset using Proc SQl?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What do you code to create a macro? : sas-macro
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
which domain is better in sas? clinical trails or banking
Mention how to limit decimal places for the variable using proc means?
Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
Explain how you can debug and test your SAS program?
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
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?
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
Teradata 
