topic Re: Proc Freq Procedure. in SAS Procedures

Proc Freq Procedure.

vishalrajpoot3 — Tue, 23 Nov 2021 15:48:40 GMT

I have below table with variables and their labels and there are multiple observations against each value/labels.

Variable	Value	Label
Pre_1	1	Use every day
Pre_1	2	Use some days
Pre_1	3	Don't use, but have tried in the past
Pre_1	4	Heard a lot & never tried
Pre_1	5	Heard a little & never tried
Pre_1	6	Never heard of it
Pre_2	1	Use every day
Pre_2	2	Use some days
Pre_2	3	Don't use, but have tried in the past
Pre_2	4	Heard a lot & never tried
Pre_2	5	Heard a little & never tried
Pre_2	6	Never heard of it

How can I get below output using proc freq:

Q225
pre_1_2	Frequency	Percent	Cumulative Frequency	Cumulative Percent
Use every day	30	6.32	30	6.32
Use some days	98	20.63	128	26.95
Not at all	347	73.05	475	100.00

Re: Proc Freq Procedure.

PaigeMiller — Tue, 23 Nov 2021 15:54:47 GMT

Please clarify this part:

I have below table with variables and their labels

Is the column named LABEL the name of an actual variable named LABEL, or is it an actual label for a variable?

Re: Proc Freq Procedure.

vishalrajpoot3 — Tue, 23 Nov 2021 16:01:27 GMT

This is label for the variable.

Re: Proc Freq Procedure.

PaigeMiller — Tue, 23 Nov 2021 16:28:49 GMT

Okay, so show us a portion of the actual data.

Re: Proc Freq Procedure.

Reeza — Tue, 23 Nov 2021 16:34:21 GMT

Your problem as I understand it:

2 variables with the same labels/values
Would like a summary of the values across both columns in one summary table
With labels applied, not raw values

If that's correct the solution is to:

Use PROC FORMAT to create a format for the variable, CNTLIN is a good option here
Combine the two variables into one (PROC TRANSPOSE or data step)
Summarize

Or you can do it in in a slightly different order:

Use PROC FORMAT to create a format for the variable, CNTLIN is a good option here
Summarize and save to data set
Combine output data sets via PROC APPEND
Re-summarize

If you need help with code, please provide sample data in the form of a data step.

@vishalrajpoot3 wrote:

I have below table with variables and their labels and there are multiple observations against each value/labels.

Variable Value Label

Pre_1 1 Use every day

Pre_1 2 Use some days

Pre_1 3 Don't use, but have tried in the past

Pre_1 4 Heard a lot & never tried

Pre_1 5 Heard a little & never tried

Pre_1 6 Never heard of it

Pre_2 1 Use every day

Pre_2 2 Use some days

Pre_2 3 Don't use, but have tried in the past

Pre_2 4 Heard a lot & never tried

Pre_2 5 Heard a little & never tried

Pre_2 6 Never heard of it

How can I get below output using proc freq:

Q225

pre_1_2 Frequency Percent Cumulative
Frequency Cumulative
Percent

Use every day 30 6.32 30 6.32

Use some days 98 20.63 128 26.95

Not at all 347 73.05 475 100.00

Re: Proc Freq Procedure.

vishalrajpoot3 — Sun, 28 Nov 2021 16:06:46 GMT

@PaigeMiller The table I have pasted above is actual data and below one is the output of proc freq. In output both the variable (pre_1 and pre_2) grouped as pre_1_2 and last 4 value of both the variables grouped as "Not at all".

Re: Proc Freq Procedure.

PaigeMiller — Sun, 28 Nov 2021 16:10:46 GMT

You can't get the PROC FREQ output from the input data set without re-arranging the data. There is no variable Pre_1_2 in your original data set, but there is in the output data set. And because of this, it isn't even clear to me how you derive the output table if you were to do this by pencil and paper. Please explain the steps between the input data and the output table, step-by-step, so I can see what you are doing.

Re: Proc Freq Procedure.

vishalrajpoot3 — Sun, 28 Nov 2021 16:52:18 GMT

please ignore the previous information provided.

So, I have a data set abc and it has two variable pre_1 and pre_2 with values from 1 to 6. All the 6 values has format as in below output table :

Pre_1	Pre_2
Use some days	Heard a little & never tried
Use every day	Use every day
Never heard of it	Don't use, but have tried in the past
Heard a lot & never tried	Heard a lot & never tried
Heard a little & never tried	Never heard of it
Don't use, but have tried in the past	Use some days

so, using proc freq on above dataset can I get below output:

pre_1_2	Frequency	Percent	Cumulative Frequency	Cumulative Percent
Use every day	30	6.32	30	6.32
Use some days	98	20.63	128	26.95
Not at all	347	73.05	475	100.00

Re: Proc Freq Procedure.

Tom — Sun, 28 Nov 2021 17:00:45 GMT

Put the data into ONE variable. Then run PROC FREQ.

data tall;
  set have;
  pre_1_2 = pre_1;
  output;
  pre_1_2=pre_2;
  output;
run;
proc freq data=tall;
 tables pre_1_2;
run;

Re: Proc Freq Procedure.

vishalrajpoot3 — Sun, 28 Nov 2021 17:14:57 GMT

will it not increase the no of observation?

Re: Proc Freq Procedure.

Tom — Sun, 28 Nov 2021 17:40:33 GMT

Yes. It will double the number of observations. Which is what you need to be able to produce the table you showed.

If you wanted to produce such a table without increasing the total N you would need to classify each individual observation into just one category. I could be done but you would need to decide what the rules are.

Re: Proc Freq Procedure.

vishalrajpoot3 — Mon, 29 Nov 2021 13:09:17 GMT

for both the variables, rules are like: value 1 (use every day) and 2 (use some days) should be displayed as it is and rest all values from 3 to 6 should be clubbed in single category "Not at all".
can you please help me with the code?