how can you sort the dataset having millions of OBS(instead
of sort procedure?
Answers were Sorted based on User's Feedback
Answer / venkatesh
by using proc format u can do sort in eficient wway
but u need to use cntlin for dataset
|Is This Answer Correct ?||2 Yes||1 No|
Answer / chandrakanth
create table dataset-name as select * from source-dataset-name group by sorting-variable-name;
GROUP BY option is for sorting the data.
Please let me know if you have more questions
|Is This Answer Correct ?||4 Yes||3 No|
Answer / ram
using there TAG SORT. it is more efficient than Sort procedure.
|Is This Answer Correct ?||4 Yes||4 No|
how can you code the confidence intervals?
How would you create multiple observations from a single observation?
what is syntax of proc merge ?
which domain is better in sas? clinical trails or banking
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
What is the pound sign used for the DATA _NULL_?
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
For what purpose would you use the RETAIN statement?
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
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.
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
How do you debug macros?