data lemon;
input accountno1 accountno2 accountno3 ;
datalines;
1234567890 123456789012 12345678901234
run;
data test;
set lemon;
result1=compress(substr(accountno1,1,8)||put((input(substr(accountno1,9,1),1.)-1),5.)||substr(accountno1,10,7)||put((input(substr(accountno1,17,1),1.)+1),5.)||substr(accountno1,18,2)," ");
result2=compress(substr(accountno2,1,8)||put((input(substr(accountno1,9,1),1.)-1),5.)||substr(accountno1,10,7)||put((input(substr(accountno1,17,1),1.)+1),5.)||substr(accountno1,18,2)," ");
result3=compress(substr(accountno3,1,8)||put((input(substr(accountno1,9,1),1.)-1),5.)||substr(accountno1,10,7)||put((input(substr(accountno1,17,1),1.)+1),5.)||substr(accountno1,18,2)," ");
output out=test;
run;
proc print data=test;
run;
GETTING BELOW ERRORS, PLEASE KINDLY TAKE A LOOK FOR ME, THANKS.
78 result1=compress(substr(accountno1,1,8)||put((input(substr(accountno1,9,1),1.)-1),5.)||substr(accountno1,10,7)||put((inpu
78 ! t(substr(accountno1,17,1),1.)+1),5.)||substr(accountno1,18,2)," ");
79 result2=compress(substr(accountno2,1,8)||put((input(substr(accountno1,9,1),1.)-1),5.)||substr(accountno1,10,7)||put((inpu
79 ! t(substr(accountno1,17,1),1.)+1),5.)||substr(accountno1,18,2)," ");
80 result3=compress(substr(accountno3,1,8)||put((input(substr(accountno1,9,1),1.)-1),5.)||substr(accountno1,10,7)||put((inpu
80 ! t(substr(accountno1,17,1),1.)+1),5.)||substr(accountno1,18,2)," ");
81 output out=test;
_
79
___
455
ERROR 79-322: Expecting a RC.
ERROR 455-185: Data set was not specified on the DATA statement.
82 run;
... View more