topic Re: Count Frequency by Column in SAS Programming

Count Frequency by Column

kc1895 — Tue, 06 Oct 2020 21:14:28 GMT

New to SAS here, I appreciate any help!

I have a spreadsheet that looks this:

Name	Question 1	Question 2	Question 3
John Doe	Yes	Yes	No
Jane Smith	No	Yes	Yes

How do I count the frequency for each column so the output looks like this:

	Question 1	Question 2	Question 3
Yes	1	2	1
No	1	0	1

Re: Count Frequency by Column

Reeza — Tue, 06 Oct 2020 21:30:10 GMT

1. Transpose main data set to a long format

2. Run a PROC FREQ

proc transpose data=have out=long;
by name;
var question1-question3;
run;

proc freq data=long;
table col1*_name_; *you may need to confirm name of col1 in wide data set;
run;

This should work regardless of the number of questions or responses.

@kc1895 wrote:

New to SAS here, I appreciate any help!

I have a spreadsheet that looks this:

Name Question 1 Question 2 Question 3

John Doe Yes Yes No

Jane Smith No Yes Yes

How do I count the frequency for each column so the output looks like this:

Question 1 Question 2 Question 3

Yes 1 2 1

No 1 0 1

Re: Count Frequency by Column

kc1895 — Tue, 06 Oct 2020 21:45:09 GMT

What if I have col2, col3, etc. How do I combine it in the same table?

Re: Count Frequency by Column

novinosrin — Tue, 06 Oct 2020 21:47:44 GMT


data have;
input Name & $10.	(Question1-Question3) ($);
cards;
John Doe	Yes	Yes	No
Jane Smith	No	Yes	Yes
;

proc transpose data=have out=temp(drop=name) ;
by name notsorted;
var Question1-Question3;
run;


proc report data=temp completerows;
 column col1 _name_;
 define _name_/across;
 define col1/group;
run;

	NAME OF FORMER VARIABLE
COL1	Question1	Question2	Question3
No	1	0	1
Yes	1	2	1

Re: Count Frequency by Column

Reeza — Tue, 06 Oct 2020 21:51:54 GMT

Depends on how you want to combine them.