Hi all
If i have a table of gender and date of birth
M 12/12/2008
M 23/10/1998
F 12/09/1798
F 09/07/2001
.,......
......
And want to find the max and min DOB by gender
Proc sql;
Select gender,max(dob),min(dob)
From have
Group by gender; quit;
This gives me the max and min in numeric
Any way proc sql can return these values in a date format?
Thanks
You are almost there.
Try this:
Proc sql;
Select
gender,
max(dob) as MaxDOB format=MMDDYY10. ,
min(dob) as MinDOB format=MMDDYY10.
From
have
Group by
gender;
quit;
You are almost there.
Try this:
Proc sql;
Select
gender,
max(dob) as MaxDOB format=MMDDYY10. ,
min(dob) as MinDOB format=MMDDYY10.
From
have
Group by
gender;
quit;
right!
forgot i could use format in proc sql :smileysilly:
Thank you!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.