topic Re: Output id's with missing values of a variable at all visits in SAS Data Management

Output id's with missing values of a variable at all visits

Miracle — Fri, 09 Aug 2019 09:05:47 GMT

Dear SAS users,

Can I please ask how to output all the id's with missing values for a variable at all visits if my data is a long data with visit-specific rows by id?

Thank you in advance.

Re: Output id's with missing values of a variable at all visits

Jagadishkatam — Fri, 09 Aug 2019 09:33:35 GMT

Could you please provide sample data and expected output so as to get better responses.

As per your question, you can try to use the below code if it helps.

data want;
set have;
if missing(variable) then output;
run;

Re: Output id's with missing values of a variable at all visits

novinosrin — Fri, 09 Aug 2019 11:57:04 GMT

Hello @Miracle I believe this is likely what you are after

/*Creating your sample data*/
data have;
do id=1 to 5;
 do visit=1 to int(ranuni(0)*10);
  var=ifn(mod(id,2)=0,.,ranuni(5));
  output;
 end;
end;
run;
/*Solution*/
proc sql;
create table want as
select *
from have
group by id
having n(id)=nmiss(var)
order by id,visit;
quit;