topic Proc tabulate multiple variables in SAS Procedures

Proc tabulate multiple variables

menhtp — Thu, 16 Oct 2014 18:27:24 GMT

Got a data like this let us call it ball colour:

key blue red yellow grey

12 x z p y

25 x z p

34 x p y

87 x

I want to tabulate on a single table a count for each colour ( but names in shorthand) i.e B for blue etc

Colour Number

B 4

R 2

Y 3

G 2

thanks.

Re: Proc tabulate multiple variables

stat_sas — Thu, 16 Oct 2014 19:28:58 GMT

proc format;
value $colour
'blue'='B'
'red'='R'
'yellow'='Y'
'grey'='G';
;

proc transpose data=have out=one;
var blue red yellow grey;
by key;
run;

proc tabulate data=one out=want;
class _name_ col1/preloadfmt;;
table _name_='Colour',n='Number';
format _name_ $colour.;
run;

Re: Proc tabulate multiple variables

LTWeiss — Fri, 17 Oct 2014 02:15:56 GMT

The following will work also:

options nocenter;

data test;

infile cards missover;

input key (blue red yellow grey) (+1 $char1.);

cards;

12 x z p y

25 x z p

34 x p y

87 x

;

run;

ods html close;

ods html;

proc sql;

select 'b' as Colour, sum(blue is not null) as Number from _last_

outer union corr

select 'r' as Colour, sum(red is not null) as Number from _last_

outer union corr

select 'y' as Colour, sum(yellow is not null) as Number from _last_

outer union corr

select 'g' as Colour, sum(grey is not null) as Number from _last_

;

quit;

Re: Proc tabulate multiple variables

menhtp — Fri, 17 Oct 2014 10:37:36 GMT

STAT

Your format_name_ STATEMENT show s an error, can you rectify?

Re: Proc tabulate multiple variables

stat_sas — Fri, 17 Oct 2014 12:05:18 GMT

Hi,

What is the error message in log?

Re: Proc tabulate multiple variables

CTorres — Fri, 17 Oct 2014 13:23:16 GMT

Should be format _name_ (two words)

Re: Proc tabulate multiple variables

zetter — Fri, 17 Oct 2014 13:32:34 GMT

This is what I get:

format_name_$variable.;

statement not valid or it is used out of proper order

Re: Proc tabulate multiple variables

stat_sas — Fri, 17 Oct 2014 14:01:37 GMT

There may be space issue when you are putting code into SAS. Instead use the following, just inserted spaces to make it work.

proc tabulate data=one out=want;

class _name_ col1;

table _name_ = 'Colour' , n='Number';

format _name_ $colour.;

run;

Re: Proc tabulate multiple variables

menhtp — Fri, 17 Oct 2014 18:42:48 GMT

Still error being reported

714 Proc tabulate data =allresults2 out= resultta;

715 class _name_col1/preloadfmt;

ERROR: Variable _NAME_COL1 not found.

Re: Proc tabulate multiple variables

ballardw — Fri, 17 Oct 2014 19:31:40 GMT

still not putting spaces between the variable names!.

class _name_ col1; (two variables from the input data set)

is NOT the same as

class _name_col1; (one variable name _name_col1 NOT in the input data set)