It is CSV file having data as below Request id,Date,Request time,Dropoff time,Pickup point,Driver id,Status 1,11-07-2016,00:11:31,12:43:12 AM,Airport,285,Trip Completed 2,11-07-2016,00:12:58,NA,Airport,NA,No Cars Available 3,11-07-2016,00:12:58,1:19:12 AM,Airport,80,Trip Completed I want to read the whole data as is also i need only fields Request id,Date,Request time and Status , and i wrote the belo code. data uber; infile '/folders/myfolders/datafiles/uber.csv' delimiter= ',' firstobs=2; input request_id Date DDMMYY10. status $35; run;
... View more