Prev: Web Report Studio Using OLAP Year over Year calculation
Next: An unsuccessful attempt to parse the SAS logfile for a WARNING-message
From: mitenko on 22 Mar 2010 17:29 hi everyone, i'm just wondering if there's a way to turn off the univariate default tables. right now i'm only interested in using the output from the proc. cheers, dave
From: Andrew Karp Sierra Info Services on 22 Mar 2010 20:15 Can you please clarify what you mean by "the univariate default tables"? Thanks, Andrew Karp Sierra Information Services http://www.sierrainformation.com On Mar 22, 2:29�pm, mitenko <mite...(a)gmail.com> wrote: > hi everyone, > > i'm just wondering if there's a way to turn off the univariate default > tables. right now i'm only interested in using the output from the > proc. > > cheers, > dave
From: mitenko on 22 Mar 2010 22:35 On Mar 22, 5:15 pm, Andrew Karp Sierra Info Services <sfbay0...(a)aol.com> wrote: > Can you please clarify what you mean by "the univariate default > tables"? > > Thanks, > > Andrew Karp > Sierra Information Serviceshttp://www.sierrainformation.com > > On Mar 22, 2:29 pm, mitenko <mite...(a)gmail.com> wrote: > > > hi everyone, > > > i'm just wondering if there's a way to turn off the univariate default > > tables. right now i'm only interested in using the output from the > > proc. > > > cheers, > > dave sure. i just want to print a summary table of a categorical variable. all i really care about is the proc print statement at the end. i'm just wondering if there's a way to clean up the output so that the default tables generated by proc univariate (http://support.sas.com/ documentation/cdl/en/procstat/63032/HTML/default/ procstat_univariate_sect050.htm) are suppressed and all that i get at the end is the table. alternatively, is there a way to turn off ods html before proc univariate and then turn it back on? the code looks like this: title 'Descriptive Statistics by Year'; proc sort data=mydata; by ZYEAR; run; proc univariate data=mydata; by ZYEAR; var WOOD_DUST LOG_DUST; output out=desc N=N mean=Mean lnMean std=SD lnSD max=Max min=Min; run; /* modify the data for presentation */ data desc; set desc; Year=ZYEAR+1979; GM=round(exp(lnMean),0.01); GSD=round(exp(lnSD),0.01); Mean=round(Mean,0.01); SD=round(SD,0.01); Max=round(Max,0.01); Min=round(Min, 0.01); proc print noobs data=desc; var Year N Mean GM SD GSD Min Max; run;
From: Andrew Karp Sierra Info Services on 23 Mar 2010 04:38 I am still really confused by what you want. What do you mean by "a summary table of a categorical variable"? It looks like you are requesting descriptive statistics for a numeric, continuous level variable in your PROC UNIVARIATE step. I think you need to learn some ODS basics. Take a look at my ODS papers available for free download at http://www.sierrainformation.com. From the home page click on "Free downloads" and take things from there. My ODS papers discuss how to control how much output generated by a PROC (by default) is generated using an ODS SELECT or EXCLUDE statement . Have fun! Andrew Karp Sierra Information Services http://www.sierrainformation.com On Mar 22, 7:35�pm, mitenko <mite...(a)gmail.com> wrote: > On Mar 22, 5:15�pm, Andrew Karp Sierra Info Services > > > > > > <sfbay0...(a)aol.com> wrote: > > Can you please clarify what you mean by "the univariate default > > tables"? > > > Thanks, > > > Andrew Karp > > Sierra Information Serviceshttp://www.sierrainformation.com > > > On Mar 22, 2:29 pm, mitenko <mite...(a)gmail.com> wrote: > > > > hi everyone, > > > > i'm just wondering if there's a way to turn off the univariate default > > > tables. right now i'm only interested in using the output from the > > > proc. > > > > cheers, > > > dave > > sure. i just want to print a summary table of a categorical variable. > all i really care about is the proc print statement at the end. i'm > just wondering if there's a way to clean up the output so that the > default tables generated by proc univariate (http://support.sas.com/ > documentation/cdl/en/procstat/63032/HTML/default/ > procstat_univariate_sect050.htm) are suppressed and all that i get at > the end is the table. > > alternatively, is there a way to turn off ods html before proc > univariate and then turn it back on? > > the code looks like this: > > title 'Descriptive Statistics by Year'; > proc sort data=mydata; by ZYEAR; run; > proc univariate data=mydata; > � � � � by ZYEAR; > � � � � var WOOD_DUST LOG_DUST; > � � � � output out=desc N=N mean=Mean lnMean std=SD lnSD max=Max min=Min; > run; > > /* modify the data for presentation */ > data desc; set desc; > Year=ZYEAR+1979; > GM=round(exp(lnMean),0.01); > GSD=round(exp(lnSD),0.01); > Mean=round(Mean,0.01); > SD=round(SD,0.01); > Max=round(Max,0.01); > Min=round(Min, 0.01); > > proc print noobs data=desc; > � � � � var Year N Mean GM SD GSD Min Max; > run;- Hide quoted text - > > - Show quoted text -
From: Oleg on 23 Mar 2010 05:16
If you want to turn off ODS html destination use ODS html close; If you want toturn on then ODS html; Regards, Oleg. |