Hi, The Orders table in library sales has a variable CustomerId char(3). On running below both the SQL, creates table with no result in variable NewID. Environment: SAS base 9.2 Log shows note as : NOTE: Invalid argument 2 to function SUBSTR. Missing values may be generated How to get result in the variable NewId as 00123 from 123. Option 1
proc sql;
create table NewList as
select unique substr(cat('00000',CustomerId),-5,5) as NewID,
customerid
from Sales.orders;
quit;
Option 2
proc sql;
create table NewList as
select unique input(substr(cat('00000',CustomerId),-5,5),$char5.) as NewID,
customerid
from Sales.orders;
quit; Thanks, UA
... View more