1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 proc import datafile= "/home/u44662193/Electricity/CMP5.FULLEXT.CSV" 70 dbms=dlm 71 out=electric.Elec 72 replace; 73 GETNAMES=YES; 74 75 delimiter=','; 76 guessingrows=10000; 77 78 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. 79 /********************************************************************** 80 * PRODUCT: SAS 81 * VERSION: 9.4 82 * CREATOR: External File Interface 83 * DATE: 09MAR22 84 * DESC: Generated SAS Datastep Code 85 * TEMPLATE SOURCE: (None Specified.) 86 ***********************************************************************/ 87 data ELECTRIC.ELEC ; 88 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 89 infile '/home/u44662193/Electricity/CMP5.FULLEXT.CSV' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; 90 informat " DATE"N yymmdd10. ; 91 informat TC best32. ; 92 informat "ACC NUM"N best32. ; 93 informat "SER NO"N $1. ; 94 informat AMOUNT best32. ; 95 informat "STATEMENT CODE"N best32. ; 96 informat DESCR $20. ; 97 informat NARR $15. ; 98 format " DATE"N yymmdd10. ; 99 format TC best12. ; 100 format "ACC NUM"N best12. ; 101 format "SER NO"N $1. ; 102 format AMOUNT best12. ; 103 format "STATEMENT CODE"N best12. ; 104 format DESCR $20. ; 105 format NARR $15. ; 106 input 107 " DATE"N 108 TC 109 "ACC NUM"N 110 "SER NO"N $ 111 AMOUNT 112 "STATEMENT CODE"N 113 DESCR $ 114 NARR $ 115 ; 116 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ 117 run; NOTE: The infile '/home/u44662193/Electricity/CMP5.FULLEXT.CSV' is: Filename=/home/u44662193/Electricity/CMP5.FULLEXT.CSV, Owner Name=u44662193,Group Name=oda, Access Permission=-rw-r--r--, Last Modified=03 March 2022 21:47:02, File Size (bytes)=286296808 NOTE: 2862498 records were read from the infile '/home/u44662193/Electricity/CMP5.FULLEXT.CSV'. The minimum record length was 98. The maximum record length was 112. NOTE: The data set ELECTRIC.ELEC has 2862498 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 3.76 seconds user cpu time 2.37 seconds system cpu time 0.26 seconds memory 11772.56k OS Memory 36636.00k Timestamp 2022/03/09 10:05:08 AM Step Count 30 Switch Count 3 Page Faults 0 Page Reclaims 394 Page Swaps 0 Voluntary Context Switches 4061 Involuntary Context Switches 4 Block Input Operations 0 Block Output Operations 448272 2862498 rows created in ELECTRIC.ELEC from /home/u44662193/Electricity/CMP5.FULLEXT.CSV. NOTE: ELECTRIC.ELEC data set was successfully created. NOTE: The data set ELECTRIC.ELEC has 2862498 observations and 8 variables. NOTE: PROCEDURE IMPORT used (Total process time): real time 7.23 seconds user cpu time 5.66 seconds system cpu time 0.35 seconds memory 11772.56k OS Memory 37152.00k Timestamp 2022/03/09 10:05:08 AM Step Count 30 Switch Count 11 Page Faults 0 Page Reclaims 7781 Page Swaps 0 Voluntary Context Switches 4209 Involuntary Context Switches 9 Block Input Operations 288 Block Output Operations 448360 118 119 proc freq data = electric.Elec; 120 tables DATE; ERROR: Variable DATE not found. 121 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 1787.68k OS Memory 30888.00k Timestamp 2022/03/09 10:05:08 AM Step Count 31 Switch Count 0 Page Faults 0 Page Reclaims 253 Page Swaps 0 Voluntary Context Switches 1 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 122 123 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 133
... View more
