how can we identify the zero number of observations in the dataset ?

Veera_48 · Posted 10-14-2020 09:34 AM

Hi Team ,

Suppose we have 100 + variables and 10000+ of observation in our source dataset and some these variables having (zero number of observation) or count as zero.

How can we find out the only zero observation variable names ?

Thanks in advance !

Veera.

Kurt_Bremser · Posted 10-14-2020 09:55 AM

See this paper: https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4737-2020.pdf

You may be able to apply one of the methods for zero instead of missing values.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

how can we identify the zero number of observations in the dataset ?

Re: how can we identify the zero number of observations in the dataset ?

Registration is open

how can we identify the zero number of observations in the dataset ?

Re: how can we identify the zero number of observations in the dataset ?

Registration is open

SAS Training: Just a Click Away