topic Re: sas in SAS Programming

sas

nayab_shaik — Fri, 28 Feb 2020 10:22:43 GMT

Hi Team,

data bm;
input id sex$ age;
cards;
10 m 45
11 m 12
12 f 25
13 f 30
14 m 14
15 f 30
16 m 41
17 f 19
18 f 21
run;

i need only first observation and last observation by using first.last.

Thanks and advance

PeterClemmensen — Fri, 28 Feb 2020 10:24:16 GMT

Do like this

data want;
    set bm end=last;
    if _N_=1 or last;
run;

PeterClemmensen — Fri, 28 Feb 2020 10:26:21 GMT

Or..

data want;
    p=1; set bm point=p;        output;
    set bm nobs=nobs point=nobs;output;
    stop;
run;

ed_sas_member — Fri, 28 Feb 2020 10:37:15 GMT

Do you need the first / last observation BY groups or for the overall dataset?

In case it is "by group", you will need:

1- To sort the data:

e.g.

proc sort data=bm;
	by sex age;
run;

2- To use the first/last flag to select the data. The "BY" statement identifies the 'groups' and create 2 internal variables: last. first.

e.g.

data want;
	set bm;
	by sex age;
	if first.sex or last.sex then output;
run;

-> in the following example, you will gather the youngest and the oldest men, and the youngest and the oldest women.

Best,