topic Re: Proc tabulate in SAS Procedures

Proc tabulate

Mikeyjh — Thu, 06 Feb 2014 15:22:25 GMT

Hi, Hope someone can help me out of the mess I'm in with Proc tabulate.

I have this statement:

proc tabulate data = dataIn;

var catCount;

class studyID orderBy dttm desc type;

table studyID*type*orderBy*desc*(style=Header),

catCount*dttm*max=' ';

run;

This works ok except I need to order the analysis variable going from left to right across the table by the datetime field dttm. How can I specify dttm to be ordered as either asc or desc?

This is what I need.

studyID	Type	OrderBy	Desc
xyz	Subject	1	Screened
		2	Randomised
	Form	3	SDV
		4	Locked
	Query	5	Genrated
		6	Outstanding

Re: Proc tabulate

data_null__ — Thu, 06 Feb 2014 15:34:42 GMT

you need to look a the documentation for the CLASS statment.

Base SAS(R) 9.3 Procedures Guide, Second Edition

Re: Proc tabulate

ballardw — Thu, 06 Feb 2014 15:46:05 GMT

You can have multiple class statements so you can set class options differently for different variables. So

Class dttm / ascending; or Class dttm / descending;

If I understand your comment about the analysis variable I think you may want dttm=''*catcount=''*max='';

Re: Proc tabulate

sgnolek — Fri, 07 Feb 2014 14:13:27 GMT

There are a couple of ways that you can order data within a table, using options in the PROC TABULATE statement itself, or within a CLASS statement. I think what you will want to do is use the CLASS statement.

Within a CLASS statement you can order the data in the following ways (from the documentation):

ORDER=DATA | FORMATTED | FREQ | UNFORMATTED

DATA: orders values according to their order in the input data set.

FORMATTED: orders values by their ascending formatted values. This order depends on your operating environment.

FREQ: orders values by descending frequency count.

UNFORMATTED: orders values by their unformatted values, which yields the same order as PROC SORT.

So, I bet that if you sort the data in the order you want the dttm variables to appear, and create separate CLASS statement for the dttm variable (like shown), you will get what you need.

Of course, this might mix up the order of other variables, so you might need to have separate CLASS statements for them, even using the PRELOADFMT option (which is a great feature!).

One wonderful, but simple, resource for understanding PROC TABULATE is this paper: http://www2.sas.com/proceedings/sugi30/258-30.pdf. Good luck!

proc sort data = dataln; by dttm; run;

proc tabulate data = dataIn;

var catCount;

class dttm / order = data;

class studyID orderBy desc type;

table studyID*type*orderBy*desc*(style=Header),

catCount*dttm*max=' ';

run;