topic Re: How to make a table with a discretion picture format in SAS Procedures

How to make a table with a discretion picture format

Dan_yu_W — Sun, 11 Dec 2011 22:56:21 GMT

Hello.

My problem is the following:

Usually in my tables (from either proc freq/tabulate) some cells contain very low observations. I'm not allowed to print these out due to "legal" reasons (since the people in my sample data have to be anonymous, table of workplace adress could in theory find who the person is, if only 1 person work at the workplace).

Using the above example, I usually make a new dataset containing a list of workplaces with more then 5 observations (make a new variable called "maxcount") from the original dataset, and than merge this back and write something like:

data X; set X_original; where maxcount_workplace>5; run;

In order to get a table with workplaces with more than 5 employees.

This is quite time consuming (even with a copy/paste of the syntax approach).

I heard that making a picture format could give me the same result e.g. changing the actual result/cells in a table giving some conditions (something like: if "cell value in a table"<=5 then replace with " -/missing/something else ".)

I hope the above is less confusing than it probably is, but I really would appreciate it if someone can tell me of it is possible with a picture format to do the above.

Regards

Dan

How to make a table with a discretion picture format

art297 — Sun, 11 Dec 2011 23:06:29 GMT

You could accomplish the task in one proc sql step. E.g.:

proc sql;

create table want as

select *

from sashelp.class

group by age

having count(age) gt 4

;

quit;

Re: How to make a table with a discretion picture format

VX_Xc — Mon, 12 Dec 2011 04:15:30 GMT

Proc Format;

Value LFive

0 -< 5 = 'Something Else';

run;

proc tabulate data = sashelp.shoes FORMAT = LFive.;

class region subsidiary;

var stores;

table subsidiary ALL, MEAN*region*stores;

run;

Make the Format such as above first then add it to your proc tabulate statement.

How to make a table with a discretion picture format

FriedEgg — Mon, 12 Dec 2011 15:34:06 GMT

Assume all your workplace datasets are in the same library then use dictionary tables:

libname wp '/my/files';

proc sql;

create table gt5 as

select memname

from sashelp.vtable

where libname='WP' and nobs>4;

quit;

How to make a table with a discretion picture format

Dan_yu_W — Mon, 12 Dec 2011 17:22:44 GMT

Thanks. The format worked great. Saved me (and my co-workers) a lot of time.

Re: How to make a table with a discretion picture format

VX_Xc — Tue, 13 Dec 2011 23:13:38 GMT

No worries