@JackZ295 wrote:
Hi @ballardw, @PaigeMiller , @Ksharp thank you for your help. Here is some sample data:
data one;
input response_id $ A1Q1 A2Q1 RFQ1 SE1Q1 SE2Q1 SE3Q1 SE4Q1 I1Q1 I2Q1 I3Q1 I4Q1;
datalines;
1 2 4 2 4 2 4 2 4 2 4 2
2 1 3 5 1 3 5 1 3 5 1 3
3 1 2 3 1 2 3 1 2 3 1 2
4 1 2 3 4 5 1 2 3 4 5 1
5 3 5 5 5 5 5 5 5 5 5 4
6 1 1 1 1 1 1 2 2 2 2 2
7 1 1 1 1 1 1 1 1 1 1 3
8 3 1 2 3 1 2 4 1 1 1 4
9 5 5 5 5 4 3 2 3 4 5 5
;
run;
proc print data=one;
run;
I want the frequencies for the Likert scale levels 1 through 5 to be shown, even if the frequency for one or more of these levels is 0. This is a much abbreviated version of my data set, as there are 50 sets of these 11 variables A1Q1-I4Q1. The second set would be A1Q2-I4Q2 etc. Any advice?
So, you have 550 variables in your data set?
Not really interested in even attempting to write code for 550 variables. Variable lists can reduce the amount of code to possibly something manageable but we need information. Such as do you have any variable names that start with A1Q that are not variables that you want to process? Same for A2Q, RFQ SE1Q SE2Q? Do each of your "sets" have the exact same names only varying by the Q1, Q2 , … Q50? Or are all of the numeric variables in your data Likert variables?
Extending @Ksharp's solution
data one;
input response_id $ A1Q1 A2Q1 RFQ1 SE1Q1 SE2Q1 SE3Q1 SE4Q1 I1Q1 I2Q1 I3Q1 I4Q1;
datalines;
1 2 4 2 4 2 4 2 4 2 4 2
2 1 3 5 1 3 5 1 3 5 1 3
3 1 2 3 1 2 3 1 2 3 1 2
4 1 2 3 4 5 1 2 3 4 5 1
5 3 5 5 5 5 5 5 5 5 5 4
6 1 1 1 1 1 1 2 2 2 2 2
7 1 1 1 1 1 1 1 1 1 1 3
8 3 1 2 3 1 2 4 1 1 1 4
9 5 5 5 5 4 3 2 3 4 5 5
;
run;
data level ;
array a{*} A1Q1 A2Q1 RFQ1 SE1Q1 SE2Q1 SE3Q1 SE4Q1 I1Q1 I2Q1 I3Q1 I4Q1;
do lickert=1 to 5;
do i= 1 to dim(a);
a[i]= lickert;
end;
w=0;
output;
end;
drop lickert i;
run;
data forfreq;
set one (in=in1)
level;
if in1 then w=1;
run;
proc freq data=forfreq;
table A1Q1 A2Q1 RFQ1 SE1Q1 SE2Q1 SE3Q1 SE4Q1 I1Q1 I2Q1 I3Q1 I4Q1;
weight w/zeros;
run;
How ever when you said "I need to output these frequencies later" you need to describe HOW you need to use them. If you need a data set for each variable count then you need 550 data sets. Which going to be a tad cumbersome.
Or you can use
proc freq data=forfreq;
table A1Q1 A2Q1 RFQ1 SE1Q1 SE2Q1 SE3Q1 SE4Q1 I1Q1 I2Q1 I3Q1 I4Q1;
weight w/zeros;
ods output onewayfreqs= freqset;
run;
to place all of the output frequencies into a single table but you will really want to look at the structure of that data set carefully for most uses. (Which ends up moderately similar to the Proc Tabulate data set but does have the cumulative counts and percentages)
You can create variable lists such as A1Q: which would reference all names that start with those 3 letters, or A1Q1- A1Q50 to reference all the variables that start with A1Q and iterate a numeric value from 1 to 50 at the end. But we would need to know the names of the variables you need if these patterns aren't acceptable.
Here is an approach that attempts to use variable lists to make a level data set with "50 sets" of the first three variable names you show:
data level ;
array a{*} A1Q1-A1Q50 A2Q1-A2Q50 RFQ1-RFQ50;
do lickert=1 to 5;
do i= 1 to dim(a);
a[i]= lickert;
end;
w=0;
output;
end;
drop lickert i;
run;
If that makes the proper named variables then continue the pattern to generate all of your variables in the levels data set.
