topic Re: Forgot how to format a data in SAS Procedures

Forgot how to format a data

tmm — Wed, 01 May 2013 21:31:52 GMT

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;

Re: Forgot how to format a data

Tom — Wed, 01 May 2013 21:55:05 GMT

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.

Re: Forgot how to format a data

ballardw — Wed, 01 May 2013 21:55:42 GMT

I think what you're looking for is;

fst_srvc_dt format=yymmdd8.,

or in a datastep

format fst_srvc_dt yymmdd8.;

Re: Forgot how to format a data

tmm — Wed, 01 May 2013 22:01:08 GMT

Thanks. Brainfart day.