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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.