Hi Below is the output from proc export. here extra quotes are coming.for character only one set of double quotes needed. when you do this with datastep for numeric columns having missing value is diplaying . so to change that converted blank .but needed is ,, not , ,. for numeric columns if it is missing value it should be ,, now it is , ,. filename TRAI 'exe.csv'; PROC EXPORT data = work.ext_accounts OUTFILE =TRAI dbms=csv replace; QUIT; proc sql; select name into :namelist separated by ',' from dictionary.columns where upcase(libname)="WORK" and upcase(memname)="EXT_ACCOUNTS"; quit; %put "&namelist."; options missing=''; option noquotelenmax; data _null_; set ext_accounts; original_balance=strip(original_balance); file "E:\exe.csv" dlm=','; if _n_=1 then put "&namelist."; put (_all_)(+0); run;
... View more