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
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.
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;
Thanks Pau its working perfect.
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.
Thanks Astounding its working like charm.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.