DATA Step, Macro, Functions and more

Missing values

Reply
Occasional Contributor
Posts: 19

Missing values

Hi All.

 

I have a data file which has many columns.

A lot of variable have 0 as values.

I need to find which are the top  variables that will be problematic because of the presence of a lot of 0’s?

 

 

Thanks & Regards 

Vishyy

New Contributor kk5
New Contributor
Posts: 2

Re: Missing values

make use of  proc frequency for this. you will hv 2 go thru the syntax ol.  this proc will answer your questn.

Super User
Posts: 5,082

Re: Missing values

It will be easier if you create a format to group other values.  For example:

 

proc format;

value posneg low-<0 = 'Negative' 0='Zero' 0-high='Positive';

run;

 

proc freq data=have;

tables _numeric_ / missing;

format _numeric_ posneg.;

run;

 

That way, you won't have to sort through huge tables with potentially thousands of different values for each variable.

Ask a Question
Discussion stats
  • 2 replies
  • 147 views
  • 0 likes
  • 3 in conversation