What are the best sas programming practices for handling very large datasets? : sas-grid-administration
- 0 Answers
- 562 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20
how do you test for missing values? : Sas programming
what are the considerations when picking a SAS/STAT procedure?
0 Answers Accenture, Quintiles,
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
how do u identify a macro variable
What is the difference between INPUT and INFILE ?
Explain what is data step?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
Name statements that function at both compile and execution time?
Teradata 
