1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
72
73 proc import datafile="/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv"
74 dbms=csv
75 out=tsa.claims_cleaned
76 replace;
77 guessingrows=max;
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: 04JUN20
84 * DESC: Generated SAS Datastep Code
85 * TEMPLATE SOURCE: (None Specified.)
86 ***********************************************************************/
87 data TSA.CLAIMS_CLEANED ;
88 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
89 infile '/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv' delimiter = ',' MISSOVER DSD lrecl=32767
89 ! firstobs=2 ;
90 informat Claim_Number $13. ;
91 informat Date_Received best32. ;
92 informat Incident_Date best32. ;
93 informat Airport_Code $3. ;
94 informat Airport_Name $48. ;
95 informat Claim_Type $39. ;
96 informat Claim_Site $15. ;
97 informat Item_Category $834. ;
98 informat Close_Amount best32. ;
99 informat Disposition $23. ;
100 informat StateName $17. ;
101 informat State $2. ;
102 informat County $20. ;
103 informat City $33. ;
104 format Claim_Number $13. ;
105 format Date_Received best12. ;
106 format Incident_Date best12. ;
107 format Airport_Code $3. ;
108 format Airport_Name $48. ;
109 format Claim_Type $39. ;
110 format Claim_Site $15. ;
111 format Item_Category $834. ;
112 format Close_Amount best12. ;
113 format Disposition $23. ;
114 format StateName $17. ;
115 format State $2. ;
116 format County $20. ;
117 format City $33. ;
118 input
119 Claim_Number $
120 Date_Received
121 Incident_Date
122 Airport_Code $
123 Airport_Name $
124 Claim_Type $
125 Claim_Site $
126 Item_Category $
127 Close_Amount
128 Disposition $
129 StateName $
130 State $
131 County $
132 City $
133 ;
134 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
135 run;
NOTE: The infile '/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv' is:
Filename=/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv,
Owner Name=u48548322,Group Name=oda,
Access Permission=-rw-r--r--,
Last Modified=04 June 2020 11:09:42,
File Size (bytes)=35157057
NOTE: 220855 records were read from the infile '/home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv'.
The minimum record length was 23.
The maximum record length was 994.
NOTE: The data set TSA.CLAIMS_CLEANED has 220855 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 1.68 seconds
user cpu time 0.33 seconds
system cpu time 0.22 seconds
memory 12781.40k
OS Memory 43132.00k
Timestamp 04/06/2020 11:35:44 AM
Step Count 29 Switch Count 1
Page Faults 0
Page Reclaims 481
Page Swaps 0
Voluntary Context Switches 3152
Involuntary Context Switches 6
Block Input Operations 0
Block Output Operations 463624
220855 rows created in TSA.CLAIMS_CLEANED from /home/u48548322/Case Study- TSA Airport/TSAClaims2002_2017.csv.
NOTE: TSA.CLAIMS_CLEANED data set was successfully created.
NOTE: The data set TSA.CLAIMS_CLEANED has 220855 observations and 14 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 1:35.74
user cpu time 1:33.99
system cpu time 0.62 seconds
memory 12781.40k
OS Memory 43648.00k
Timestamp 04/06/2020 11:35:44 AM
Step Count 29 Switch Count 8
Page Faults 0
Page Reclaims 15216
Page Swaps 0
Voluntary Context Switches 3262
Involuntary Context Switches 115
Block Input Operations 288
Block Output Operations 463744
136
137
138 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
150 Here is the log I got.
... View more
