I am importing an excel file. The start and end is numeric. When I try to import the character "OTHER" SAS can't digest it. proc import datafile='/folders/myfolders/Informat Test.csv' out=Formats replace dbms=csv; run; Proc format Cntlin=formats; Run; I get an import unsuccessful : NOTE: The infile '/folders/myfolders/Informat Test.csv' is: Filename=/folders/myfolders/Informat Test.csv, Owner Name=root,Group Name=vboxsf, Access Permission=-rwxrwx---, Last Modified=15Aug2018:11:04:31, File Size (bytes)=1583 NOTE: Invalid data for Start in line 55 18-22. NOTE: Invalid data for End in line 55 24-28. NOTE: Invalid data for Label in line 55 30-31. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 55 f1956DiscountTbl,OTHER,OTHER,NA 31 FMTName=f1956DiscountTbl Start=. End=. Label=. _ERROR_=1 _N_=54 NOTE: 54 records were read from the infile '/folders/myfolders/Informat Test.csv'. The minimum record length was 25. The maximum record length was 31. NOTE: The data set WORK.FORMATS has 54 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds Errors detected in submitted DATA step. Examine log. 54 rows created in WORK.FORMATS from /folders/myfolders/Informat Test.csv. ERROR: Import unsuccessful. See SAS Log for details. I am trying to approximate : Proc format; value fmt 1 = "70" 2 = "80" other = "NA"; Run;
... View more