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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.