[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Creating variables that count the levels of other variables
From:       Ron RJF Fehd <ron.fehd.macro.maven () GMAIL ! COM>
Date:       2017-02-28 15:56:58
Message-ID: CA+9ODgt20su_8SpDVi6i14Z+L1Rm=A7nDWBUnfSh_UNwZChBgg () mail ! gmail ! com
[Download RAW message or body]

check the freq option nlevels in my paper

Calculating Cardinality in Two Steps

http://www.lexjansen.com/mwsug/2016/TT/MWSUG-2016-TT03.pdf

%let data = sashelp.class;
%let data = sashelp.Heart;
%let data = sashelp.Shoes;

ODS  exclude all; * noprint;
PROC freq data    = &data
          nlevels ;
          ods       exclude onewayfreqs;
          ods       output
          nlevels = work.out_freq
         (keep    =  tablevar   nlevels
          rename  = (tablevar = name
                     nlevels  = n_levels));

proc sql; describe table &syslast;
                       quit;

Ron Fehd  list processing maven

[Attachment #3 (text/html)]

<div dir="ltr"><div><span style="font-family:monospace,monospace">check the freq \
option nlevels in my paper<br><br></span></div><div><span \
style="font-family:monospace,monospace">Calculating Cardinality in Two \
Steps<br></span></div><div><span style="font-family:monospace,monospace"><br><a \
href="http://www.lexjansen.com/mwsug/2016/TT/MWSUG-2016-TT03.pdf">http://www.lexjansen.com/mwsug/2016/TT/MWSUG-2016-TT03.pdf</a><br><br>%let \
data = sashelp.class;<br>%let data = sashelp.Heart;<br>%let data = \
sashelp.Shoes;<br><br>ODS  exclude all; * noprint;<br>PROC freq data    = \
&amp;data<br>          nlevels ;<br>          ods       exclude onewayfreqs;<br>      \
ods       output<br>          nlevels = work.out_freq<br>         (keep    =  \
tablevar   nlevels<br>          rename  = (tablevar = name<br>                     \
nlevels  = n_levels));<br><br>proc sql; describe table &amp;syslast;<br>              \
quit;<br><br></span></div><span style="font-family:monospace,monospace">Ron Fehd  \
list processing maven<br></span></div>



[prev in list] [next in list] [prev in thread] [next in thread]