topic Re: Multiple if last observations in SAS Programming

Multiple if last observations

Q1983 — Wed, 18 Nov 2020 20:56:05 GMT

proc sql;
create table cars2 as
select make, type
from sashelp.cars
where make in ('Acura','Audi')
;quit;

data cars3;
set cars2;
by make type;
if last.make and last.type;
run;

The query gives the last make and type. I want to show the last make and type in each category. For example

Make Type

Accura Sedan

Accura Sports

Same scenario for Audi. Instead I am getting the last observation period. Is there a way to address in the proc sql statement or must it be done in the datastep?

Re: Multiple if last observations

Shmuel — Wed, 18 Nov 2020 21:03:51 GMT

It is not clear to me what you want.

Try each of next IF statements:

1) if last type;

2) if last make;

3) if last.type then putlog type=;
if last.make then putlog make=;

4) if last.make or last.type;

Re: Multiple if last observations

PeterClemmensen — Wed, 18 Nov 2020 21:06:48 GMT

This logic is not clear to me. Why do you want two observations for Accura? If you want to show the last make and type for each category, then what is your overall category?

Re: Multiple if last observations

ballardw — Wed, 18 Nov 2020 21:10:46 GMT

If you want the last of each type for all of the makes then you want:

if last.type;

proc sort data=sashelp.cars
   out=work.cars;
   by make type;
run;

data want;
   set work.cars (keep=make type);
   by make type;
   if last.type;
run;

Re: Multiple if last observations

PGStats — Wed, 18 Nov 2020 21:56:10 GMT

It is not clear what you mean by category. Maybe you want this:

data cars2;
set sashelp.cars;
where make in ('Acura','Audi');
by make type notsorted;
if last.type;
/* keep make type; */
run;

proc print data=cars2 noobs; var make type; run;