topic Re: Making a categorical variable from two date variables, and a summary table in New SAS User

Making a categorical variable from two date variables, and a summary table

araren — Mon, 16 Nov 2020 13:53:28 GMT

Hi!

Its' the been awake for more than 24hours newbie. Back with another question, I would greatly appreciate the help :'(

I need help making a table of summary statistics, and I need to stratify that table with a categorical variable. The categorical variable is hospital stay, and in my dataset I have data for hospital admission date, and hospital discharge date.

I know how to make a means table for all variables and a univariate table, but I don't know how to put them all together, and I don't know how to future stratify it by that categorical variable. Please help 😞

I've attached photos of what my table is supposed to look like, and my data.

Thank you 😞

edit: To add code. the reason I didn't in the first place was because I was entirely unsure of what code to use....

To create a stratified table, this is what I think to use:

proc freq data = dataset;
by stratifying_variable;
table variable2;
run;

However, I don't know how to adjust this so that i get a summary statistics table for all of the variables in my set.

Re: Making a categorical variable from two date variables, and a summary table

PaigeMiller — Mon, 16 Nov 2020 13:44:03 GMT

you will get a faster response if you post your data as provided by these instructions, and not as a screen capture.

Re: Making a categorical variable from two date variables, and a summary table

araren — Mon, 16 Nov 2020 13:54:00 GMT

Have edited with code. Not quite sure of what code to use even, hence the screencaps.

Re: Making a categorical variable from two date variables, and a summary table

Reeza — Mon, 16 Nov 2020 16:43:31 GMT

Run this macro ~~once for each group subset and then merge the results together is your quickest way.~~

https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-TABLEN/ta-p/634030