topic Re: Display first and last observation in SAS Programming

Display first and last observation

Rambo_UK — Sun, 04 Aug 2013 11:59:20 GMT

Hi!!! please help me out to get output for this input without using if statement and loops

Input:

110 111 101 113 109

108 105 101 109 101

122 123 124 125 101

127 128 129 130 103

102 103 101 104 107

106 107 101 109 103

101 109 107 109 107

111 101 999 105 101

Output:

110 111 101 113 109

111 101 999 105 101

Re: Display first and last observation

pau_figuera — Sun, 04 Aug 2013 14:48:31 GMT

Rambo_UK

Hi Rambo, here's my solution (its in 2 data steep) I hope it usefull.

Pau Figuera (Spain)

data rambo;

input var1 var2 var3 var4 var5;

cards;

110 111 101 113 109

108 105 101 109 101

122 123 124 125 101

127 128 129 130 103

102 103 101 104 107

106 107 101 109 103

101 109 107 109 107

111 101 999 105 101

;

run;

data rambo;

set rambo;

counter = 0;

run;

data rambo_counter (drop = counter);

set rambo;

by counter;

if first.counter then output;

counter = counter +1;

if last.counter then output;

run;

proc print data = rambo_counter;

run;

Re: Display first and last observation

Astounding — Sun, 04 Aug 2013 16:31:38 GMT

Sounds like another question from the same homework assignment. Similar tools, which you may need to look up and study:

data want;

set have nobs=_nobs_;

output;

set have point=_nobs_;

output;

stop;

run;

Good luck.

Re: Display first and last observation

Rambo_UK — Sun, 04 Aug 2013 18:09:36 GMT

Thanks Pau its working perfect.

Re: Display first and last observation

Rambo_UK — Sun, 04 Aug 2013 18:11:33 GMT

Thanks Astounding its working like charm.