This is exactly what I needed! Thanks! For those using Miner, I have an account number 15 digits long (Char15). I only need the first 11. SAS Code Node read: data &EM_EXPORT_TRAIN; set &EM_IMPORT_DATA; CM11=SUBSTR(ACCT_NO,1,11); run; Returns the same value as Excel; = Left(ACCT_NO,11)
... View more