Prev: Tabulate 2
Next: how to combine date and time to make it datetime
From: Patrick on 18 Dec 2009 02:01
What about giving it a try by yourself and then ask concrete questions
when you get stuck?

What about providing example data in the form of a fully working data
step?
From: Jonas Bilenas on 18 Dec 2009 08:31
You just need to change a few things in the tabulate code I provided in
response to TABULATE 1:


proc tabulate data=stuff noseps formchar=' ' missing;
class dt id v;
format v cat.;
table dt*id
,
v=' '
*(n*f=nz.
pctn<v>='%'*f=pct.
)
/rts=20 row=float misstext=' ';
run;



On Thu, 17 Dec 2009 17:13:34 -0500, Randy <randistan69(a)HOTMAIL.COM> wrote:

>Dear All
>
>This follows up on Tabulate and Tabulate 1
>
>Date ID Var
>Mar1 A 1
>Mar1 A 3
>Mar1 A 10
>Mar1 A 4
>Mar1 A 5
>Mar1 B 4
>Mar1 B 5
>Mar1 B 7
>Mar2 A 2
>Mar2 A 0
>Mar2 A 3
>Mar2 A 4
>Mar2 A 1
>Mar2 A 1
>Mar2 B 9
>Mar2 B 7
>Mar2 B 6
>Mar2 B 8
>
>I want three categories
>0-1 Category 1
>2-5 Category 2
>6-10 Category 3
>
>My final Data set should look like
>
> Category1 %Cat 1 Category2 %Cat2 Category3 %Cat4
>Mar1
>A 1 20% 3 60% 1 20%
>B 0 0% 2 67% 1 33%
>Mar 2
>A 3 60% 2 40% 0 0%
>B 0 0% 4 100% 0 0%
>
>Please Help
 | 
Pages: 1
Prev: Tabulate 2
Next: how to combine date and time to make it datetime