topic Re: Do i=1 to variable name? in New SAS User

Do i=1 to variable name?

ywhui9 — Thu, 01 Nov 2018 12:05:13 GMT

Hi can anyone please help me out with this?

infile datalines dlm=',' dsd missover;
input id:$ no_visit unit_purchased@;
do i=1 to no_visit;
input unit_purchased@;
if unit_purchased=. then unit_purchased =0;
output;	
end;
drop i no_visit;
datalines; 
C005,3,15,,39
D2356,4,11,,,5
A323,3,10,15,20
F123,1,
;
run;

I somehow got an error and SAS failed to output (15,11,10&1).

Re: Do i=1 to variable name?

FreelanceReinh — Thu, 01 Nov 2018 12:17:19 GMT

Hi @ywhui9 and welcome to the SAS Support Communities!

Try this corrected DATA step:

data test;
infile datalines dlm=',' dsd missover;
input id $ no_visit @;
do i=1 to no_visit;
  input unit_purchased @;
  if unit_purchased=. then unit_purchased=0;
  output;	
end;
drop i no_visit;
datalines; 
C005,3,15,,39
D2356,4,11,,,5
A323,3,10,15,20
F123,1,
run;

Edit: In your code you read the first value of UNIT_PURCHASED with the first INPUT statement, but before the OUTPUT statement you read the second value with the second INPUT statement, so the first value was overwritten.

Re: Do i=1 to variable name?

PaigeMiller — Thu, 01 Nov 2018 12:15:45 GMT

Show us the SASLOG. Click on the {i} icon and paste your SASLOG into that window.

When I execute your code, I do not get an error.

Re: Do i=1 to variable name?

ywhui9 — Thu, 01 Nov 2018 12:23:26 GMT

Thanks all !!!

Re: Do i=1 to variable name?

AMSAS — Thu, 01 Nov 2018 12:23:28 GMT

Hi, The reason you are not getting first unit_purchased, in the output is that you override the value before the output statement with the 2nd input statement.
In the 1st input statement, the code reads in id=C005 no_visit=3 unit_purchased=15. Then you drop into the do loop and the 2nd input statement reads in unit_purchased=. (missing). This happens each time you go to a new observation.

Add another output statement after the 1st input statement, should solve the issue

Re: Do i=1 to variable name?

ywhui9 — Thu, 01 Nov 2018 12:28:26 GMT

Thank you for the explanation! Have a nice day 🙂

Re: Do i=1 to variable name?

ywhui9 — Thu, 01 Nov 2018 12:33:10 GMT

Thank you for the explanation! It helps a lot 🙂