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.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.