topic Re: obs_sno in SAS Programming

obs_sno

BrahmanandaRao — Sat, 28 Mar 2020 07:43:58 GMT

Obs_Sno	Name	Sex	Age	Height	Weight
15	Philip	M	16	72	150
16	Robert	M	12	64.8	128
17	Ronald	M	15	67	133
18	Thomas	M	11	57.5	85
19	William	M	15	66.5	112

data one ; do obs_sno=1 to nobs; set sashelp.class nobs=nobs; if _n_>=nobs-4 ; output; end; run;

REQUIRED OUTPUT

Obs_Sno	Name	Sex	Age	Height	Weight
15	Philip	M	16	72	150
16	Robert	M	12	64.8	128
17	Ronald	M	15	67	133
18	Thomas	M	11	57.5	85
19	William	M	15	66.5	112

Re: obs_sno

Kurt_Bremser — Sat, 28 Mar 2020 08:25:34 GMT

And what is your question?

@BrahmanandaRao wrote:
Obs_Sno	Name	Sex	Age	Height	Weight
15	Philip	M	16	72	150
16	Robert	M	12	64.8	128
17	Ronald	M	15	67	133
18	Thomas	M	11	57.5	85
19	William	M	15	66.5	112
data one ; do obs_sno=1 to nobs; set sashelp.class nobs=nobs; if _n_>=nobs-4 ; output; end; run;
REQUIRED OUTPUT

Obs_Sno Name Sex Age Height Weight

15 Philip M 16 72 150

16 Robert M 12 64.8 128

17 Ronald M 15 67 133

18 Thomas M 11 57.5 85

19 William M 15 66.5 112

Re: obs_sno

BrahmanandaRao — Sat, 28 Mar 2020 08:47:34 GMT

i want below required output

Obs_Sno Name Sex Age Height Weight
15 Philip M 16 72 150
16 Robert M 12 64.8 128
17 Ronald M 15 67 133
18 Thomas M 11 57.5 85
19 William M 15 66.5 112

Re: obs_sno

ballardw — Sat, 28 Mar 2020 08:58:53 GMT

data want;
   set sashelp.class nobs=totalobs;
   obs_no = _n_;
   if _n_ ge totalobs - 4;
run;

You have to use the NOBS= option on the Set statement to create a variable that holds the number of observations in the input data set. Then you also have to explicitly assign the _n_ value to another variable to keep the observations number if you want that value.