Date:         Sun, 14 Aug 2005 16:32:33 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: using format statement in proc summary
Comments: To: Alex Gould <alex.gould@STANFORD.EDU>

Alex,

What message is SAS returning that makes you say it doesn't like the way
you set it up?  Your code seems correct.  If you are running the sections
separately, the proc summary won't run until it encounters a 'run'
statement.

Art
----------
On Sun, 14 Aug 2005 11:27:50 -0400, Alex Gould <alex.gould@STANFORD.EDU>
wrote:

>Hi,
>
>I'm trying to use a format line (in my proc summary statement) that will
>convert my SAS date values to a calendar date.  Although I think I have
the
>informat right, for some reason SAS does not like the way I have set it
up.
> I have reproduced it here if anyone has any thoughts.  Thanks!
>
>Alex
>
>P.S. All values with the word "date" in them (such as date1 date2 etc) are
>in SAS date form prior to this proc summary step and I am trying to change
>only those variables into MMDDYY8. form and also to leave the other
variable
>formats as they are.)
>
>
>proc summary data = lastfrontier missing nway noprint max;
>     CLASS permno comnam ipodate;
>     VAR date1 price1 shrout1 date2 price2 date7 price7 date14 price14
>         date30 price30 date60 price60 date90 price90 date180 price180
>         date365 price365 date730 price730;
>      FORMAT date1 MMDDYY8. date2 MMDDYY8. date7 MMDDYY8. date14 MMDDYY8.
>             date30 MMDDYY8. date60 MMDDYY8. date90 MMDDYY8. date180
>             MMDDYY8. date365 MMDDYY8. date730 MMDDYY8.;
>      output out=summarystats  max = d1 p1 s1 d2 p2 d7 p7 d14 p14 d30 p30
>      d60 p60 d90 p90 d180 p180 d365 p365 d730 p730;
>
>proc export data = summarystats  outfile = 'summarystats.txt';
>      run;