Forgot how to format a data

[tmm]

I have a table where the SAS dates for fst service and birthday are

      8    BIRTHDAY                Num       8    DATE9.    DATE9.      BIRTHDAY

I am trying to reformat in my proc sql as yyyymmdd

Here is my code and I am just drawing a complete blank

proc sql;*select distinct information;

create table sum0513 as

(select distinct

sys_id,

alt_id,

sub_nbr,

acct_nbr,

fst_srvc_dt format date=yymmdd8.,

first_name,

last_name,

bday format date=yymmdd8.,

age,

from tbl2

group by sys_id, fst_srvc_dt, acct_nbr);

run;

[Tom · Accepted solution]

fst_srvc_dt format=yymmddN8.,

The syntax is FORMAT= and then the format. YYMMDD8 will get you two digit years and hyphens.  The N in code above means to not use any separator, so there is room for four digit years.  You could also use YYMMDD10. if you like the separators.

[tmm]

Thanks. Brainfart day.

[ballardw]

I think what you're looking for is;

fst_srvc_dt format=yymmdd8.,

or in a datastep

format fst_srvc_dt yymmdd8.;