topic Re: Error in first. and last. statement in SAS Procedures

Error in first. and last. statement

Shivi82 — Fri, 24 Oct 2014 09:13:26 GMT

data ttt (drop=value period);

set testing;

by region;

if first.region and last.region then output ttt;

else output =duplicate;

run;

I get the error message that variable duplicate is uninitialized. PLease advice.

Re: Error in first. and last. statement

Kurt_Bremser — Fri, 24 Oct 2014 09:24:39 GMT

That's very simply because "duplicate" is not in the input data set.

Re: Error in first. and last. statement

KachiM — Fri, 24 Oct 2014 09:48:12 GMT

It is not due to FIRST. or LAST.

Place the data set names in the Output like:

data ttt (drop=value period) duplicate;

Re: Error in first. and last. statement

Kurt_Bremser — Fri, 24 Oct 2014 10:15:18 GMT

And drop the erroneous equal sign

Re: Error in first. and last. statement

Shivi82 — Fri, 24 Oct 2014 19:23:56 GMT

Just one more thing - as you mentioned duplicate in the data step statement, would it create a new dataset which will capture other values excluding the first and the last obs of the group.