macro to check percentage of missing values in a dataset

[chennupriya]

Thank you for all help

[chennupriya]

Also , i have both character and numeric variables in the Dataset

[PaigeMiller]

---

@chennupriya wrote:

I wanted to check how do i apply the code to check percentage missing of all variables by Category A Category B and Category C

---

The first step in any macro writing ought to be to create working SAS code without macros and without macro variables, for a single data set. Once you have done that, turning the results into a macro will be relatively simple. But it doesn't appear you have done that yet.

[Ksharp]

It is easy for PROC SQL.

Make a macro to make the following code streamline .

data have;
set sashelp.heart;
if ranuni(1) < 0.2 then call missing(AgeAtStart,status);
run;

proc sql;
create table want as
select sex,
 nmiss(AgeAtStart)/count(*) as nmiss_per_AgeAtStart,
 nmiss(status)/count(*) as nmiss_per_status,
 nmiss(height)/count(*) as nmiss_per_height
from have
 group by sex;
quit;

[Tom]

It seems silly to use NMISS() with only one variable.  That is what MISSING() is for.  But it won't actually do what you want since either is just going to operate on each observation and not aggregrate.

Instead just use the COUNT() function of SQL.  It will not count the missing values of the variable given.

,count(AgeAtStart)/count(*) as AgeAtStart
,count(status)/count(*) as status
,count(height)/count(*) as height

Plus that way the code should easier for SAS to push into a remote database.

[chennupriya]

Sure . Thank you I can try that code and see if it works

[Ksharp]

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

[chennupriya]

Thank you for all your help

[chennupriya]

Thank you everyone so much for all your help .