Creating a "Shift" Table
in [SAS]
|
From: Ted Ames on 1 Dec 2009 21:04 Hi Dan, Thanks. This is pretty good. I also tried PROC FREQ before you posted without the SPARSE option. Is there way to get each cell as a percentage of the Grand Total, example cell 1 (10.0) where 10 was the Grand Total? Also is there a way to suppress the default (see below) and provide my own titles? The FREQ Procedure SUPPRESS? Table of...... How would I zero fill so I got all possible combinations even if there wasn't any data for a combination?
From: Yu Zhang on 1 Dec 2009 21:20 Ted, I think Proc Tabulate might do what you need. to ensure all combination will be listed in the final table, you need to use options PRELOADFMT or EXCLUSIVE, CLASSDATA or PRINTMISS or any combination of above options. to get you started, please take look at the example below. I am using the sample data from Dan's post. proc tabulate data=have; class baseline final; table baseline all ,final*(N=''*f=8.) All/misstext='0'; run; HTH Yu On Tue, Dec 1, 2009 at 8:04 PM, Ted Ames <forwardwash(a)yahoo.com> wrote: > Hi Dan, > > Thanks. This is pretty good. I also tried PROC FREQ before you posted > without the SPARSE option. Is there way to get each cell as a percentage of > the Grand Total, example cell 1 (10.0) where 10 was the Grand Total? Also > is > there a way to suppress the default (see below) and provide my own titles? > > The FREQ Procedure > SUPPRESS? > Table of...... > > How would I zero fill so I got all possible combinations even if there > wasn't any data for a combination? >
From: xlr82sas on 1 Dec 2009 22:40 On Dec 1, 6:20 pm, zhangy...(a)GMAIL.COM (Yu Zhang) wrote: > Ted, > > I think Proc Tabulate might do what you need. to ensure all combination will > be listed in the final table, you need to use options PRELOADFMT or > EXCLUSIVE, CLASSDATA or PRINTMISS or any combination of above options. > > to get you started, please take look at the example below. I am using the > sample data from Dan's post. > > proc tabulate data=have; > class baseline final; > table baseline all ,final*(N=''*f=8.) All/misstext='0'; > run; > > HTH > > Yu > > > > On Tue, Dec 1, 2009 at 8:04 PM, Ted Ames <forwardw...(a)yahoo.com> wrote: > > Hi Dan, > > > Thanks. This is pretty good. I also tried PROC FREQ before you posted > > without the SPARSE option. Is there way to get each cell as a percentage of > > the Grand Total, example cell 1 (10.0) where 10 was the Grand Total? Also > > is > > there a way to suppress the default (see below) and provide my own titles? > > > The FREQ Procedure > > SUPPRESS? > > Table of...... > > > How would I zero fill so I got all possible combinations even if there > > wasn't any data for a combination?- Hide quoted text - > > - Show quoted text - Perhaps the following program may help. http://homepage.mac.com/magdelina/.Public/utl.html utl_tipweb.txt /* T003820 PROGRAM TEMPLATE FOR CLINICAL SHIFT TABLE OF TOXICITY AT BASELINE VS TOXICITY AT END OF TREATMENT AND FOLLOWUP
From: Monal Kohli on 3 Dec 2009 18:10 Hi, I actually presented a paper in nesug 2007 on how to create a shift table. Take a look and see if it helps. Mona
First
|
Prev
|
Pages: 1 2 Prev: proc gmap, strange rotation at random Next: Error Handling – Data Sets |