topic Re: Demographic table creation in SAS Studio

Demographic table creation

sasban — Mon, 23 Oct 2017 19:22:56 GMT

I need to create a demographic summary table. Since I'm doing this for the first time, I'm looking for the reference that describes creating table with continuous and categorical variables explicitly (possibly with step by step coding). Any suggestions please?

Re: Demographic table creation

Reeza — Mon, 23 Oct 2017 19:26:57 GMT

Search LexJansen.com

And note that everyone defines demographic table differently, so you may need to customize things as needed.

It seems down right now, but should be up soon.

Or search on here, there's a lot of examples. John King has some great papers on this as well.

Re: Demographic table creation

ballardw — Mon, 23 Oct 2017 19:45:37 GMT

My first suggestion is to make sure your data is as clean as possible. Each field involved should have an agreed upon content and be in that form. For instance if Gender or Sex is a field is it allowed to be missing or something like "don't know" or "refused". If the values are supposed to be "Male" or "Female" then beware of case ( "male" "female"), abbreviations ("M" "F" or "m" "f").

Second is if you have continuous values like Age but want to report age groups to investigate custom formats so you can make changes without having to add multiple variables to your data for that purpose.

And if you are reporting percentages make sure everyone involved knows what the denominator(s) involved should be: All records or records with valid values.

Very likely questions will arise if the total counts for all Sexes, for example, don't match total counts for all ages.

Re: Demographic table creation

sasban — Mon, 23 Oct 2017 20:09:49 GMT

@ballardw- My data is clean already. My problem here is the proper use of proc freq, proc transpose... things are required in proper order.

Re: Demographic table creation

mkeintz — Wed, 25 Oct 2017 14:27:16 GMT

Could you provide a template of what your demographic table should look like?

I presume it will be a table of frequencies cross-classified by demographic variables If so, which vars? SEX,RACE,AGE_GROUP..... other vars like IMMIGRANT/NATIVEBORN, Education level?

Re: Demographic table creation

sasban — Wed, 25 Oct 2017 14:37:00 GMT

@mkeintz,

Yes, It is like this:

Treatment A Treatment B Total

Sex

M 50 (10%) 100 (20%) 500 (100%)

Race

White

Asian

Re: Demographic table creation

mkeintz — Wed, 25 Oct 2017 20:54:20 GMT

You can get close to this with a PROC TABULATE.

Assume you have a data set of individuals with variables SEX ("M" or "F"), Race ("White", "Asian").

Then you can

proc tabulate data=have noseps;
  class age sex treatment;
  tables age sex all, (treatment all)*(N pctn) / rts=10;
run;

which gives the layout you want, but is ugly. You can improve the appearance:

proc format ;
  picture mypct  low-high='00.0%';
run;
proc tabulate data=have noseps;
  class age sex treatment;
  tables age sex all, (treatment all)*(N=''*f=comma4.0 pctn=''*f=mypct5.1) / rts=10;
run;

And if you want better than that, I think you need to learn about PROC REPORT.

Re: Demographic table creation

sasban — Wed, 25 Oct 2017 21:31:10 GMT

@mkeintz, I did following and did proc report with other variables. But could not calculate total.

Proc import datafile="/folders/myshortcuts/Myfolders/SAS Exercise/DM_Exercise1.xls"

Out=Q1

Dbms=XLS replace;

run;

proc sort data=Q1 nodupkey;

by usubjid;

run;

data Q1a;

set Q1 (keep=agegr1 sex age race ethnic trt01pn pltcnt);

run;

proc freq data=Q1a noprint;

tables trt01pn*agegr1/missing outpct out=Q1afreq_agegr1;

run;

data Q1afreqper_agegr1;

set Q1afreq_agegr1;

length value $25;

value=put(count, 4.)!!' ('!!put(pct_row,4.1)!!'%)';

run;

proc sort data=Q1afreqper_agegr1;

by agegr1;

run;

proc transpose data=Q1afreqper_agegr1 out=Q1atrans_agegr1;

by agegr1;

var value;

ID trt01pn;

run;

data labelagegr1;

label="Age Categorization (%)";

run;

data agegr1label;

length label $25;

set labelagegr1 Q1atrans_agegr1;

keep label _0 _1 _2;

if _n_>1 then select;

when (agegr1='<65') label="<65";

when (agegr1='>=65') label=">=65";

otherwise;

end;

run;

Re: Demographic table creation

dimrana — Fri, 13 Apr 2018 18:06:00 GMT

Did you find the solution? Can u share the solution on how to create demographic table?

Re: Demographic table creation

Cynthia_sas — Fri, 13 Apr 2018 23:42:07 GMT

Hi:

I show one approach to create several tables/reports (for RTF output) in my paper, Creating Complex Reports http://www2.sas.com/proceedings/forum2008/173-2008.pdf (page 9).

TABULATE is another approach, but TABULATE does not give you as much control over break lines and spacing.

You'll find the programs that accompany the paper here: http://support.sas.com/rnd/papers/#RegUsers_2008 scroll down on the page for 2008 and look for the paper title.

This is just one idea. I second the idea of searching on www.lexjansen.com because the PharmaSUG and PhUSE presenters have talked a lot about producing these types of reports.

Cynthia