Do i=1 to variable name?

[ywhui9]

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). 

[FreelanceReinh · Accepted solution]

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.

[ywhui9]

Thank you for the explanation! Have a nice day 🙂

[PaigeMiller]

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.

[ywhui9]

Thanks all !!! 

[AMSAS]

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

[ywhui9]

Thank you for the explanation! It helps a lot 🙂