Character Variable & Blanks

Reply
Frequent Contributor
Posts: 75

Character Variable & Blanks

I have 2 Character Variables & after producing the 2-way Frequency table, the count doesn't match the number of records I can find in the Excel file where I can the data.

Freq Table

AB
0
01944
12000

Frequency Missing= 9

So for A=1 & B=0, there are 2000 records

But when I filter the Excel file I find less than 2000 that meet both criteria.

Is it possible that SAS read some of the blanks A= 1, B=blank as A=1 & B=0, ?

How to solve this problem?

Thanks

Respected Advisor
Posts: 4,930

Re: Character Variable & Blanks

Try

TABLES A B A*B / missing;

in proc freq to get more info on the SAS side.

PG

PG
Ask a Question
Discussion stats
  • 1 reply
  • 129 views
  • 0 likes
  • 2 in conversation