topic Re: missing values in SAS Programming

missing values

sascodequestion — Thu, 16 Mar 2017 10:54:32 GMT

data input;
input ID $ period amt;
cards;
X 201001 10000
X 201004 800
X 201006 200
Y 201101 100
Y 201102 100
Z 201201 .
Z 201202 .
Z 201203 .

;
run;

Re: missing values

Astounding — Wed, 15 Mar 2017 18:40:23 GMT

Assuming that I understand what you want, here's one way:

data defaults;

set test1 (keep=id amt);

by id;

where amt > .;

if first.id;

rename amt=default_amt;

run;

data want;

merge test1 defaults;

by id;

if amt > . then default_amt = amt;

else amt = default_amt;

drop default_amt;

run;

It's untested, but looks like it should work just fine.

Re: missing values

ballardw — Wed, 15 Mar 2017 19:24:07 GMT

Please repost your orginial question or a close version.

Without the question the response makes no sense.

Re: missing values

Ksharp — Thu, 16 Mar 2017 04:47:38 GMT



data input;
input ID $ period amt;
cards;
X 201001 10000
X 201004 800
X 201006 200
Y 201101 100
Y 201102 100
Z 201201 .
Z 201202 .
Z 201203 .
;
run;
data want;
 merge input input(keep=id period 
 rename=(id=_id period=_period) firstobs=2);
 output;
 if id=_id then do;
  do i=period+1 to _period-1;
   period=i;output;
  end;
 end;
 drop _: i;
run;