Team ,
I have a code to read Excel file from Share Drive to SAS folder as SAS Data set but it's not working for CSV file , any suggestions on it.
Also on the share drive we will have a file name like this xxx_2021-19-05 (name with date every day) , how can we read only latest file using the same program.
libname TESTf '/test/';
run;
proc import datafile="\\abc999.cloud.me.org\abc\test_2021-05-19.CSV"
out=TESTf.xxx_date
DBMS=CSV REPLACE;
server="sasabc.xxx.me.org";
port=1234;
serveruser="12345";
serverpass="1234";
run;
server="sasabc.xxx.me.org";
______
180
32 port=1234;
____
180
33 serveruser="1234";
__________
180
34 serverpass="1234";
__________
180
Error :
ERROR 180-322: Statement is not valid or it is used out of proper order.
Appreciate any details on it.
Thanks