proc tabulate-Use Proc format

Ronein — Tue, 03 Sep 2019 03:50:11 GMT

Hello

I want to use user defined format in order to use new groups of variable Z1.

What is the way to modify proc tabulate code in order to use formatted groups of Z1?

proc format ;
value Z1Fmt
2-4='2-4'
5-6='5-6'
;
Run;

data rawdata;
input ID  Z1  Z2 $;
cards;
1 2 xjfjjj
2 3 djdjdj
3 3 xjfjjj
4 4 djdjdj
5 5 xjfjjj
6 5 djdjdj
7 6 djdjdj
8 6 asasas
9 6 asasas
10 6 djdjdj
;
run;

 
PROC tabulate DATA=rawdata  ;
class z2/order=freq;
class z1/order=internal;
TABLE  z2=' ' all,z1*n*f=8.0 all*n*f=8.0/printmiss box='z2' misstext='0';
keylabel n=' ';
RUN;

Re: proc tabulate-Use Proc format

Ronein — Tue, 03 Sep 2019 03:51:35 GMT

I found the solution.

proc format ;
value Z1Fmt
2-4='2-4'
5-6='5-6'
;
Run;

PROC tabulate DATA=rawdata  ;
class z2/order=freq;
class z1/order=internal;
TABLE  z2=' ' all,z1*n*f=8.0 all*n*f=8.0/printmiss box='z2' misstext='0';
keylabel n=' ';
format Z1 Z1Fmt.;
RUN;

topic Re: proc tabulate-Use Proc format in SAS Programming

proc tabulate-Use Proc format

Re: proc tabulate-Use Proc format