topic Re: first non missing value in SAS Programming

first non missing value

pawandh — Fri, 26 Feb 2016 16:14:21 GMT

i have a datset

data test;
input store sales;
cards;
1 .
1 200
1 300
1 .
2 .
2 300
2 150
2 560
3 900
3 560
3 .
;
run;

i want the first non missing value of each store?

Re: first non missing value

SAS_inquisitive — Fri, 26 Feb 2016 16:43:31 GMT

data test;
 input store sales;
 cards;
1 .
1 200
1 300
1 .
2 .
2 300
2 150
2 560
3 900
3 560
3 .
;
run;

data want;
 set test;

 if not missing(sales) then
 output;
run;

data want2;
 set want;
 by store;

 if first.store;
run;

Re: first non missing value

Haikuo — Fri, 26 Feb 2016 16:52:47 GMT

Here is a one-step solution, for the sake of efficiency:

data want;

set test;

by store sales notsorted;

ct=ifn(first.store,0,ct);

ct+(first.sales and not missing(sales));

if ct=1;

drop ct;

run;

Re: first non missing value

Astounding — Fri, 26 Feb 2016 17:01:32 GMT

It's easy with a WHERE statement:

data want;

set have;

by store;

if first.store;

where sales > .;

run;