I'm using below Proc export code to export CSV excel file into path and able to create second dataset(recs&i), But i am not able to create multiple sheets(header, recs&i) in same excel I've tried to use statement SHEET option in both procs, but getting error. /*create files on local server*/ PROC EXPORT DATA= header LABEL OUTFILE= "&full_path_outfile." DBMS=CSV REPLACE; RUN; PROC EXPORT DATA= recs&i. LABEL OUTFILE= "&full_path_outfile." DBMS=CSV REPLACE; DELIMITER=';'; RUN; As i am creating CSV file with ; delimiter, and able to open CSV file directly into excel, Could you please suggest the way to create multiple sheets in same csv excel file?
... View more