Proc Freq - Text Variables

[dsky227]

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?  

[PaigeMiller]

 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=pro...

[Rick_SAS]

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.

[ballardw]

---

@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.