36278 proc import datafile='D:\MorningStar_data\Monthly Officer Director History 2018\Monthly_OfficerDirectorHistory_0C00000823_2018-2.dat' 36278! dbms=dlm out=work.test787 replace; delimiter="|"; getnames=no; guessingrows=50;data test787;set test787; CompanyID=var1;ReportYear=var2; 36278! delimiter="|"; getnames=no; guessingrows=50; 36278! data test787;set test787; CompanyID=var1 36278! ;ReportYear=var2;FiscalYear=var3;PersonID=var4;DataID=var5;Value=var6; drop var1 var2 var3 var4 var5 var6; run; 36279 /********************************************************************** 36280 * PRODUCT: SAS 36281 * VERSION: 9.4 36282 * CREATOR: External File Interface 36283 * DATE: 05APR18 36284 * DESC: Generated SAS Datastep Code 36285 * TEMPLATE SOURCE: (None Specified.) 36286 ***********************************************************************/ 36287 data WORK.TEST787 ; 36288 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 36289 infile 'D:\MorningStar_data\Monthly Officer Director History 2018\Monthly_OfficerDirectorHistory_0C00000823_2018-2.dat' delimiter = '|' 36289! MISSOVER DSD lrecl=32767 ; 36290 informat VAR1 $10. ; 36291 informat VAR2 best32. ; 36292 informat VAR3 best32. ; 36293 informat VAR4 $10. ; 36294 informat VAR5 best32. ; 36295 informat VAR6 $808. ; 36296 format VAR1 $10. ; 36297 format VAR2 best12. ; 36298 format VAR3 best12. ; 36299 format VAR4 $10. ; 36300 format VAR5 best12. ; 36301 format VAR6 $808. ; 36302 input 36303 VAR1 $ 36304 VAR2 36305 VAR3 36306 VAR4 $ 36307 VAR5 36308 VAR6 $ 36309 ; 36310 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 36311 run; NOTE: The infile 'D:\MorningStar_data\Monthly Officer Director History 2018\Monthly_OfficerDirectorHistory_0C00000823_2018-2.dat' is: Filename=D:\MorningStar_data\Monthly Officer Director History 2018\Monthly_OfficerDirectorHistory_0C00000823_2018-2.dat, RECFM=V,LRECL=32767,File Size (bytes)=357681, Last Modified=02Mar2018:17:46:24, Create Time=20Mar2018:13:43:16 NOTE: 4785 records were read from the infile 'D:\MorningStar_data\Monthly Officer Director History 2018\Monthly_OfficerDirectorHistory_0C00000823_2018-2.dat'. The minimum record length was 39. The maximum record length was 1447. NOTE: The data set WORK.TEST787 has 4785 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.08 seconds cpu time 0.04 seconds 4785 rows created in WORK.TEST787 from D:\MorningStar_data\Monthly Officer Director History 2018\Monthly_OfficerDirectorHistory_0C00000823_2018-2.dat. NOTE: WORK.TEST787 data set was successfully created. NOTE: The data set WORK.TEST787 has 4785 observations and 6 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.18 seconds cpu time 0.09 seconds NOTE: There were 4785 observations read from the data set WORK.TEST787. NOTE: The data set WORK.TEST787 has 4785 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 36312 36313 proc print; run; WARNING: Data too long for column "Value"; truncated to 145 characters to fit. NOTE: There were 4785 observations read from the data set WORK.TEST787. NOTE: PROCEDURE PRINT used (Total process time): real time 0.06 seconds cpu time 0.06 seconds