@RW9 wrote: I would agree with @rudfaden, the data imports fine for me as well. I wouldn't however import an Excel file. SAve the file to CSV, then use a datastep to read the csv in, specifying informats and lengths and such like. Proc import + Excel = garbage data. Thank you so much @RW9!!! That worked flawlessly! Saved the original file in CSV format and imported the dataset into SAS Studio it worked!. The following from the LOG window indicates that SAS did the job of specifying informats for the dataset. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 /* Generated Code (IMPORT) */ 74 /* Source File: test_002.csv */ 75 /* Source Path: /folders/myfolders */ 76 /* Code generated on: 14/08/2018 22:23 */ 77 78 %web_drop_table(WORK.rawct); NOTE: Table WORK.RAWCT has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 79 80 81 FILENAME REFFILE '/folders/myfolders/test_002.csv'; 82 83 PROC IMPORT DATAFILE=REFFILE 84 DBMS=CSV 85 OUT=WORK.rawct; 86 GETNAMES=YES; 87 RUN; NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary parameter values will be saved to WORK.PARMS.PARMS.SLIST. 88 /********************************************************************** 89 * PRODUCT: SAS 90 * VERSION: 9.4 91 * CREATOR: External File Interface 92 * DATE: 14AUG18 93 * DESC: Generated SAS Datastep Code 94 * TEMPLATE SOURCE: (None Specified.) 95 ***********************************************************************/ 96 data WORK.RAWCT ; 97 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 98 infile REFFILE delimiter = ',' MISSOVER DSD firstobs=2 ; 99 informat Age best32. ; 100 informat State best32. ; 101 informat Plate best32. ; ... ; 248 format meanHKG best12. ; 249 input 250 Age 251 ... 324 meanHKG 325 ; 326 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 327 run; NOTE: The infile REFFILE is: Filename=/folders/myfolders/test_002.csv, Owner Name=root,Group Name=vboxsf, Access Permission=-rwxrwx---, Last Modified=14 August 2018 22:23:02, File Size (bytes)=8010 NOTE: 20 records were read from the infile REFFILE. The minimum record length was 149. The maximum record length was 419. NOTE: The data set WORK.RAWCT has 20 observations and 75 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 20 rows created in WORK.RAWCT from REFFILE. NOTE: WORK.RAWCT data set was successfully created. NOTE: The data set WORK.RAWCT has 20 observations and 75 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.82 seconds cpu time 0.35 seconds 328 329 PROC CONTENTS DATA=WORK.rawct; RUN; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.31 seconds cpu time 0.31 seconds 330 331 332 %web_open_table(WORK.rawct); 333 334 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 347
... View more