Prev: Start and End References
Next: SAS 9.2 on NT vs XP-Pro
From: Elvira Sojli on 7 Jan 2010 11:12
Dear all,

I am using saszipam to read zipped csv files (code at the end of email). I
am getting an error message because there is an extra empty line in the csv
file. If I remove this line then I can unzip and read the csv, otherwise I
get an error message. I don't mind removing the line but I have over 1000
files to unzip. Is there a different way to remove the extra line from the
zipped csv file?

Thanks for the time.
Elvira

filename in saszipam 'F:\Cash\EuronextAmsterdam-BBO-200404-1.zip';
data test;
infile in(EuronextAmsterdam-BBO-200404-1.csv)
dlm = ';' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat Internal_code best32. ;
informat ISIN_code $9.;
informat Instrument_name $35. ;
informat Quotation_place $9.;
informat BBO_date yymmdd10.;
informat BBO_time time12.;
informat BBO_number best32.;
informat Best_bid_price best32.;
informat Best_ask_price best32.;
informat Size_best_bid best32. ;
informat Size_best_ask best32. ;
informat Number_orders_best_bid best32. ;
informat Number_orders_best_ask best32. ;

input
Internal_code
ISIN_code $
Instrument_name $
Quotation_place $
BBO_date $
BBO_time $
BBO_number
Best_bid_price
Best_ask_price
Size_best_bid
Size_best_ask
Number_orders_best_bid
Number_orders_best_ask
;
run;
 | 
Pages: 1
Prev: Start and End References
Next: SAS 9.2 on NT vs XP-Pro