Hi, Thank you so much for your responce. I would like to import all xlsx/csv into SAS data sets, what ever present in the folder, So i need the autamated code and the below code i am using and it is converting only one file.if you know any thing kindly provide me the CODE. PROC IMPORT DATAFILE="/ctshared/clinpharm/amg176/onc/20150161/cdm/sas/edc/data/ssd/adverse.xls" OUT=WORK.test REPLACE DBMS=XLS; OPTIONS VALIDVARNAME=V7; /* SHEET="manufacturing_lot_data_report";*/ GETNAMES=YES; RUN; Regards, Sony.
... View more