Hi,
I am trying to pass the list of variables to a macro and find if these variables have missing values and create a table to get the count of missing values for each variable into a column in a table . the column types include both character and numeric
With the below code I am only able to get the count for second/last variable.
Can you please help me out with this. It will be great if you can suggest an efficient way.
Appreciate any help.
Thanks in advance,
Regards,
Sheeba
%macro test(dsn,string);
%let word_cnt=%sysfunc(countw(%superq(string)));
%put &word_cnt;
%do i = 1 %to &word_cnt;
%let var&i=%qscan(%superq(string),&i,%str( ));
%put &&var&i;
%end;
proc sql;
create table miss_val as
select
sum(case when &&var&i is null then 1 else 0 end ) as miss_cnt_var_&i,
count(*) as total_rows
from &dsn;
%mend test;
%test(ing_raw_total,sequence_number id)
... View more