Explain proc sort?
No Answer is Posted For this Question
Be the First to Post Answer
how do you test for missing values? : Sas programming
"What is the difference between proc sort nodup and proc sort nodupkey?"
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?
how does sas handle missing values in procs? : Sas programming
/* 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;
how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?
WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?
What’s the difference between var b1 – b3 and var b1 — b3?
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
If a variable contains letters or special characters, can it be numeric data type?