Help using Base SAS procedures

Drop null varaibles

Frequent Contributor
Posts: 147

Drop null varaibles

I have dataset called AA........I would like to know if there is any way for us to drop all the null variables(both character and numeric) with out looking into the data.....

Respected Advisor
Posts: 3,852

Re: Drop null varaibles

Posted in reply to rakeshvvv

Like "Carnac the Magnificent" he will divine the question without knowing the answer.

As far as I know to you will need to "look" a every variable until you determine it is NOT NULL.  For many variables perhaps most you only need to look at one observation, but unfortunately for variables that are completely null, the target of the investigation, every observation will need to be examined.

Carnac the Magnificent - Wikipedia, the free encyclopedia

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation