LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (October 2007, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 22 Oct 2007 12:54:22 -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: Proc TABULATE, mixed up on missing
Comments: To: "Richard A. DeVenezia" <rdevenezia@wildblue.net>
In-Reply-To:  <XA4Ti.19$6k.101476@news.sisna.com>
Content-Type: text/plain; charset=ISO-8859-1

This gets one part (X*1*N X*2*N Z*1*N) but I can't get big N.

proc transpose out=foo2; by topic id; var x y z; run; proc tabulate data=foo2 format=12.; class topic _name_ col1; table topic, _name_=' '*col1=' '*n / rts=10; run;

On 10/22/07, Richard A. DeVenezia <rdevenezia@wildblue.net> wrote: > I am using the MISSING option so that a TABULATE will occur without getting > a > WARNING: A class, frequency, or weight variable is missing on every > observation. > and no output at all. > > Is there a way to use the MISSING option and then tell tabulate to not show > the missings (class level values)? > > In this sample, I would want to see just columns N X*1*N X*2*N Z*1*N > > data foo; > do topic = 1 to 2; > do id = 1 to 100; > r = ranuni(1234); > select ; > when (r < 0.33) x = .; > when (r < 0.66) x = 1; > otherwise x=2; > end; > y = .; > z = ifn (ranuni(1234)<0.2,.,1); > output; > end; > end; > run; > > ods listing; > options linesize=200 nocenter; > dm 'output' output; > > proc tabulate MISSING data=foo format=12.; > class topic x y z; > table topic, n x*n y*n z*n / rts=10; > run; > > -- > Richard A. DeVenezia > http://www.devenezia.com/ >


Back to: Top of message | Previous page | Main SAS-L page