Date:         Wed, 16 Jul 2008 16:15:40 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: how to control decimals in proc surveyfreq output?
Comments: To: Chang Chung <chang_y_chung@hotmail.com>
In-Reply-To:  <200807162055.m6GHCKfg013416@malibu.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Yes thank you.  I thought that there was a way to do that but I didn't
do the research I needed.  Thanks for setting me on the right path.

On 7/16/08, Chang Chung <chang_y_chung@hotmail.com> wrote:
> On Wed, 16 Jul 2008 14:54:02 -0500, data _null_, <datanull@GMAIL.COM> wrote:
>
> >As I understand it you need to modify the template.  See comment below
> >/* changed here*/ .  I don't know how to just modify and copy so I
> >redefine the entire template.  Template expert help need.
> >
> >1) determine the name of the template the need to be modified(ods trace)
> >2) get source using proc template source statement. copy code to program.
> >3) modify and submit....
> >
> >ods path work.temp(update) sashelp.tmplmst(read);
> >proc template;
> >   source Stat.SurveyFreq.OneWayFreqs;
> >   define table Stat.SurveyFreq.OneWayFreqs;
> ... (way too many lines) ...
> >   end;
> >
> >   run;
>
> hi,
> or you can just edit the parts you need to modify. Below works fine on 9.1.3
> sp4 on windows. inside the table template, both define and edit seem to be
> working equally well. i think it is a good habit to reset the ods path when
> done. hth.
> cheers,
> chang
>
> ods path (prepend) work.mytmp(update);
> proc template;
>   edit Stat.SurveyFreq.OneWayFreqs;
>      define LowerCL;
>         glue = 100;
>         format = 9.2; /*changed here*/
>         print_headers = OFF;
>      end;
>      define UpperCL;
>         glue = 10;
>         format = 9.2; /* and here */
>         print_headers = OFF;
>      end;
>   end;
> run;
> proc surveyfreq data=sashelp.class;
>   tables sex / cl nowt;
> run;
> ods path reset;
>