topic Re: Simple question on setting up missing values in SAS Programming

Simple question on setting up missing values

Tomcaty — Fri, 23 Feb 2018 18:38:14 GMT

Hello all,

I am struggling on a simple program. I wanted to assign missing values for all the BMI and age that have duplicate records.

data test;
input  sub bmi age med$;
datalines;
1 0.2 12 ibuprofen
1 0.2 12 crocin
1 0.2 12 cetrizine
2 0.3 14 rituxim
2 0.3 14 belimu
;

My output data set should have multiple records for subject ID but missing values for BMI and age that are duplicates. My output should look like below.Thanks for your help.

1 0.2 12 ibuprofen
1   .  . crocin
1   .  . cetrizine
2 0.3 14 rituxim
2   .  . belimu

Re: Simple question on setting up missing values

tomrvincent — Fri, 23 Feb 2018 18:44:53 GMT

data test2; set test;
by sub;
if not first.sub then do;bmi=.; age=.; end;
run;

Re: Simple question on setting up missing values

art297 — Fri, 23 Feb 2018 18:53:35 GMT

Depends upon what you consider duplicates. Possibly you're looking for something like:

data test;
input  sub bmi age med$;
datalines;
1 0.2 12 ibuprofen
1 0.2 12 crocin
1 0.2 12 cetrizine
2 0.3 14 rituxim
2 0.3 14 belimu
;

data test2;
  set test;
  by sub bmi age;
  if not first.age then do;
    call missing(bmi);
    call missing(age);
  end;
run;

Art, CEO, AnalystFinder.com