topic Re: Last.X and First.X on the same time in SAS Programming

Last.X and First.X on the same time

DmytroYermak — Fri, 16 Feb 2018 15:06:38 GMT

Hi all,

For instance a dataset is sorted by variable X.

How in one iteration reveal if an observation is only one in a group:

if first.X and last.X ...

Thank you!

Re: Last.X and First.X on the same time

RW9 — Fri, 16 Feb 2018 15:08:28 GMT

Thats it you have it.

data want;
  set have;
  by x;
  if first.x and last.x then only_one="Yes";
  else only_one="No";
run;

Re: Last.X and First.X on the same time

srinath3111 — Fri, 16 Feb 2018 15:21:05 GMT

Hi,

If you sort a data set and in a data step when you specify by variable then sas creates two automatic variables back end they are first.by variable and last.by variable.

first.by variable value is=1 for the first observation in a dataset and rest of all the by group will be =0 except last.by variable. that will be one

You can observe it by writing example

proc sort data=ds;
by sex;
run;
data ds;
set sashelp.classfit;
by sex;
put _all_;'

if first.sex and last.x then flag=1;

else flag=0;
run;

Thanks

Re: Last.X and First.X on the same time

DmytroYermak — Fri, 16 Feb 2018 15:23:55 GMT

You are definitely right ). It was rather a "tough" day today (

Re: Last.X and First.X on the same time

RW9 — Fri, 16 Feb 2018 15:27:52 GMT

No probs, it likely not be the first or last tough day!