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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.