topic proc sql and date format in SAS Procedures

proc sql and date format

Tal — Tue, 13 Jan 2015 23:08:49 GMT

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

Re: proc sql and date format

statistician13 — Tue, 13 Jan 2015 23:48:46 GMT

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;

Re: proc sql and date format

Tal — Wed, 14 Jan 2015 00:42:50 GMT

right!

forgot i could use format in proc sql :smileysilly:

Thank you!