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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.