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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.