```Date: Mon, 3 Oct 2005 16:18:57 -0400 Reply-To: Ya Huang Sender: "SAS(r) Discussion" From: Ya Huang Subject: Re: Outputting Ns of cells into different Vars TAB FREQ MEANS Comments: To: toby989@HOTPOP.COM data xx; input a b; cards; 1 1 1 1 1 2 1 2 1 3 1 3 1 3 2 1 2 2 2 2 2 3 3 1 3 1 ; data yy; set xx; by a; if first.a then do; x1=0; x2=0; x3=0; end; x1+(b=1); x2+(b=2); x3=(b=3); if last.a; run; proc print; run; Obs a b x1 x2 x3 1 1 3 2 2 1 2 2 3 1 2 1 3 3 1 2 0 0 Kind regards, Ya Huang On Mon, 3 Oct 2005 13:06:46 -0700, toby989@HOTPOP.COM wrote: >Hi All > >I want to create a summary of two variables, one with 100 levels, the >other one with 3 levels, into a table that shows the Ns by cell. FREQ, >TABULATE or MEANS procedure create one row for each level combination >(100x3=300rows) and put the numbers into one variable, but for further >processing, i need a dataset with 100 rows and 3 variables. > >I would be so grateful for your help on this. > >Thanks Toby > > >1 1 >1 1 >1 2 >1 2 >1 3 >1 3 >1 3 >2 1 >2 2 >2 2 >2 3 >3 1 >3 1 >. >. >. >99 > >into > >1 2 2 3 >2 1 2 1 >3 2 ... >. >. >99 ```

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