topic combining cross tab data in New SAS User

combining cross tab data

lawye010 — Wed, 20 Jan 2021 22:44:06 GMT

Hello,

I have a dataset I am working with where I have calculated completion or a variable (yes/no) by type of visit (remote/in-person). I have multiple variables I am assessing for completion and have used the below code to do this. I now need to sum the completion percent for each of these assessments into an overall completion rate. Can anyone help me figure out how to do this? Thanks.

proc freq data=dataseta;
table visit_typescreen*strokedx visit_typescreen*timenihss visit_typescreen*mostnihss visit_typescreen*marissnihss;
run;

Re: combining cross tab data

ballardw — Wed, 20 Jan 2021 23:28:09 GMT

Example input data and expected output would be helpful.

In case you didn't know Proc Freq supports some short cuts such as

proc freq data=dataseta;
table visit_typescreen*(strokedx timenihss mostnihss marissnihss);
run;

You can use multiple groups of variables withing parentheses to get lots of crosses, everything in group1 with everything in group2 (and more).

Re: combining cross tab data

lawye010 — Wed, 20 Jan 2021 23:49:10 GMT

Thanks for the shortcuts. For example, if my output is:

visit type strokedx

Yes No

In person 5 3 8

Remote 7 2 9

12 5 17

and

visit type NIHSS

Yes No

In person 4 4 8

Remote 8 1 9

12 5 17

I want to establish the % complete for in-person and remote visits totaled:

In person (5+4)/8*100

Remote (7+8)/9*100

This is obviously easy to do by hand or in excel, there will just be a lot more variables I need calculated in this total, so I was wondering if there is a quick way to code this in excel. Thanks.

Re: combining cross tab data

lawye010 — Wed, 20 Jan 2021 23:50:29 GMT

edit:

I want to establish the % complete for in-person and remote visits totaled:

In person (5+4)/16*100

Remote (7+8)/18*100

Re: combining cross tab data

Reeza — Thu, 21 Jan 2021 00:04:36 GMT

And none of the percentages outputted via PROC FREQ meet this requirement?
Can you explain why?

It sounds like you want a different table overall though with different percentages really.

Re: combining cross tab data

lawye010 — Thu, 21 Jan 2021 00:06:27 GMT

I need the percentages from each individual variable cross tab, and the code I wrote achieves this fine. I also need percentages from all of the cross tabs summed up. Wondering how to achieve the summation of each separate analysis.

Re: combining cross tab data

ballardw — Thu, 21 Jan 2021 00:23:35 GMT

By example data I meant the Dataseta, not the summary.

Best would be as a data step. Your summary is not possible to tell which of your variables with NIHSS as part of name are included.

Something like which does not duplicate your numbers, just an example of what the data step should look like.

data example;
   infile datalines dlm=',';
   input visit_typescreen :$10. strokedx $ timenihss $;
datalines;
In person,Yes,Yes
In person,Yes,Yes
Remote,Yes,Yes
Remote,Yes,Yes
Remote,Yes,Yes
Remote,Yes,Yes
In person,Yes,No
Remote,Yes,No
In person,Yes,No
Remote,No,Yes
In person,Yes,No
Remote,Yes,No
In person,No,Yes
Remote,No,Yes
In person,No,No
Remote,No,No
In person,No,No
Remote,Yes,No
;

Re: combining cross tab data

Reeza — Thu, 21 Jan 2021 00:32:21 GMT

Wouldn't that just be this then? The second table should have the stats you seem to want.

proc freq data=dataseta;
table visit_typescreen*(strokedx timenihss mostnihss marissnihss);
table visit_typescreen;
run;