topic Re: Proc Freq - Text Variables in SAS Programming

Proc Freq - Text Variables

dsky227 — Tue, 22 Sep 2020 17:55:38 GMT

I have a data set with two text variables (tvar1 & tvar2) and one numeric variable (nvar)

I want to create these tables

tvar2 is missing tvar2 is not missing

tvar1 is missing xx xx

tvar1 is not missing xx xx

tvar1 is missing tvar2 is not missing

nvar (values)

I can't figure it out.

If I run

proc format;

value missing_ind .='missing' other='not missing';

run;

then what do I do?

Re: Proc Freq - Text Variables

PaigeMiller — Tue, 22 Sep 2020 17:58:53 GMT

The format makes it more readable, but PROC FREQ still ignores missing values, regardless of how it is formatted.

You need to use the MISSING option in the TABLES statement to tell PROC FREQ to count the missing values https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=procstat&docsetTarget=procstat_freq_syntax08.htm&locale=en#procstat.freq.freqmissingopt

Re: Proc Freq - Text Variables

Rick_SAS — Tue, 22 Sep 2020 18:05:41 GMT

You use PROC FREQ, as shown in the examples in this article.

For the first table, you can use

table tvar1*tvar2;

I'm not sure what you intend for the second table. For the columns, is there a typo? Do you mean

tvar1 is missing tvar1 is not missing

Do you want the count for each column for each discrete value of the numeric variable?

As always, sample data will make the questions clearer and the answers easier to describe.

Re: Proc Freq - Text Variables

ballardw — Tue, 22 Sep 2020 18:09:27 GMT

@dsky227 wrote:

I have a data set with two text variables (tvar1 & tvar2) and one numeric variable (nvar)

I want to create these tables

tvar2 is missing tvar2 is not missing

tvar1 is missing xx xx

tvar1 is not missing xx xx

tvar1 is missing tvar2 is not missing

nvar (values)

I can't figure it out.

If I run

proc format;

value missing_ind .='missing' other='not missing';

run;

then what do I do?

Your format is only defined for NUMERIC values. You would need to make a similar format for character variables.

proc format;
value $missing_ind 
' '='missing' 
other='not missing'
;

run;

The format can have the similar name because the $ means it is only for Character variables.