topic Re: SAS Date MMYYYY in SAS Procedures

SAS Date MMYYYY

KevinC_ — Fri, 12 Oct 2012 00:13:54 GMT

Hello Everyone,

How do I format a numeric field (i.e. 102012) as Oct 2012?

I basically want to show the month (Oct) plus the year (2012). Is this possible?

Thank you so much for any input!

Re: SAS Date MMYYYY

PGStats — Fri, 12 Oct 2012 01:16:27 GMT

Try fornat nldateym8.

Re: SAS Date MMYYYY

Ksharp — Fri, 12 Oct 2012 06:10:32 GMT

You need customize it on your own.

proc  format ;
picture fmt(default=8)
 other='%b%Y'(datatype=date);
run;

data _null_;
a=23234;
format a fmt.;
put a= ;
run;

Ksharp

Re: SAS Date MMYYYY

Jeroen — Fri, 12 Oct 2012 10:30:48 GMT

Hi Kevin, If you have 9.3 you could use a format based on a function. Regards Jeroen. proc fcmp outlib=work.functions.smd; function MonYear(date) $ 8; month = floor(date / 10000); year = date - (month * 10000); if month < 1 or month > 12 then do; month = 1; end; return (catx(' ', put(mdy(month, 1, year), monname3.), put(year, 4.))); endsub; run; /* Make the function available to SAS. */ options cmplib=(work.functions); /* Create a format using the function created by the FCMP procedure. */ proc format; value MonYear other=[MonYear()]; run; /* Use the format in a SAS program. */ data test; input testdate; datalines; 12011 022012 122013 ; run; proc print data=test; format testdate MonYear.; run;

Re: SAS Date MMYYYY

KevinC_ — Fri, 12 Oct 2012 15:24:47 GMT

Thank you, Jeroen. Unfortunately we use 9.1. Thank you for your response

Kevin

Re: SAS Date MMYYYY

KevinC_ — Fri, 12 Oct 2012 15:29:21 GMT

Hi Ksharp,

Thank you so much for your suggestion! It worked. But now I realize I need the result in a different format.

I actually need 02012 as OCT-12.

I modified your code as below and came up withAUG12. Is it possible to add a '-' between AUG and 12?

Thank you again for your help!

proc format ;

picture fmt(default=5)

other='%b%y'(datatype=date);

run;

data _null_;

a=23234;

format a fmt.;

put a= ;

run;

Re: SAS Date MMYYYY

Ksharp — Tue, 16 Oct 2012 02:02:59 GMT

Easy.

proc  format ;
picture fmt(default=8)
 other='%b-%0y'(datatype=date);
run;

data _null_;
a=18234;
format a fmt.;
put a= ;
run;

Ksharp