topic Proc Report Date Format in ODS and Base Reporting

Proc Report Date Format

newbi — Fri, 12 Aug 2011 16:27:31 GMT

I have date in proc report as : 20110812 but i would like to format it as 08-12-2011

What format do i need to use ?

Proc Report Date Format

asishgautam — Fri, 12 Aug 2011 16:33:40 GMT

try mmddyy10.

Proc Report Date Format

newbi — Fri, 12 Aug 2011 16:37:48 GMT

mmddyy10. did not work.

Proc Report Date Format

lho — Fri, 12 Aug 2011 16:51:53 GMT

I have the exact same question! Need to change 20110812 to be 08/12/2011. It's quite frustrating. I tried format mmddyy10. and format yymmdd10. Neither worked.

Proc Report Date Format

art297 — Fri, 12 Aug 2011 16:55:29 GMT

If the "date" is actually a character field, then you have to create a numeric field. In a datastep, that could be accomplished with:

data have;

input date $;

format wantdate mmddyyd10.;

wantdate=input(date,yymmdd8.);

cards;

20110812

;

To get a slash, rather than a hyphen, just change the d10 in the format to s10.

Proc Report Date Format

lho — Fri, 12 Aug 2011 16:58:01 GMT

Mine is not character, it is in numeric format.

Re: Proc Report Date Format

newbi — Fri, 12 Aug 2011 17:00:19 GMT

Mine is numeric as well

Re: Proc Report Date Format

art297 — Fri, 12 Aug 2011 17:10:01 GMT

If it is the number 20110812, what happens if you try:

options datestyle=ymd;

data have;

input date;

format date mmddyyd10.;

date=input(put(date,z8.),anydtdte.);

cards;

20110812

;

Proc Report Date Format

asishgautam — Fri, 12 Aug 2011 17:12:20 GMT

i had this wrong:

try the following:

data test ;

informat dval yymmdd8. ;

format dval yymmdd10. ;

input @1 dval ;

datalines ;

20110812

20110813

20110814

20110815

20110816

20110817

;

run ;

Proc Report Date Format

asishgautam — Fri, 12 Aug 2011 17:13:07 GMT

yymmdd10.

Re: Proc Report Date Format

newbi — Fri, 12 Aug 2011 17:18:51 GMT

This gives me sas date - 18850

Re: Proc Report Date Format

art297 — Fri, 12 Aug 2011 17:24:02 GMT

That is one number off but, if you apply the format, you should get what you want. I ran:

options datestyle=ymd;

data have;

input date;

format date mmddyyd10.;

date=input(put(date,z8.),anydtdte.);

cards;

20110812

;

proc print;run;

and got:

Obs date

1 08-12-2011

Re: Proc Report Date Format

SUN59338 — Fri, 12 Aug 2011 17:24:26 GMT

it should be works;

data test;

input d $;

format dt mmddyyd10. st mmddyys10.;

dt=input(d,yymmdd8.);

st=dt;

cards;

20110812

;

run;

proc report nowd;

column d dt st;

define d/display;

define dt/display;

define st/display;

quit;

Re: Proc Report Date Format

newbi — Fri, 12 Aug 2011 17:32:43 GMT

Art,

You code work but for some reason when i apply it to my code it doesn't work. Here is my code. Am i missing anything ?

Options datastyle=ymd;

ods html file = 'path'

Proc Report ......

Column Date / Format=mmddyy10. group 'date' missing noprint;

compute before Date / Style=[just=l];

text1 = 'Date = ' || trim(left(input(put(date,z8.),anydtdte.)));

.....

Re: Proc Report Date Format

art297 — Fri, 12 Aug 2011 18:24:21 GMT

I'm not well versed in proc report but, that said, the following works for me:

data have;

input name $ havedate;

cards;

John 20110811

Mary 20110812

;

options datestyle=ymd;

PROC REPORT NOWD DATA=have HEADLINE HEADSKIP CENTER MISSING;

COLUMNS NAME havedate date;

define havedate/display noprint;

define date/computed format=yymmddd10.;

COMPUTE date;

date=input(put(havedate,z8.),anydtdte.);

ENDCOMP;

RUN;

Re: Proc Report Date Format

newbi — Fri, 12 Aug 2011 22:16:01 GMT

Thanks. It did work fo rme.

Re: Proc Report Date Format

lho — Fri, 19 Aug 2011 20:56:39 GMT

Here is how I solved the problem with some explanations. (Basically the same as it's been answered in all the previous threads).

Problem:

Original var: has data that looks something like... 20070131

I want var to look like this: 01/31/2007

data new;

set old;

new_var = input (put(old_var,8.), yymmdd8.); <-- put(old_var,8.) changes the old_var's data type from numeric to character. Then, the input function changes old_var into a SAS date.

format new_var mmddyy10.; <-- after it has been changed into a SAS date, then you have the option to format it any way you want. The mmddyy10. gives me the appearance I want (01/31/2007). I believe if you would like it to be 01-31-2007, instead of mmddyy10. you can use mmddyyd10.