SAS PROC export to excel and save format

Question

I have SAS guide output. I want to PROC export him, the problem is that when i export him to excel All the format changes.

When I use in the SAS guide the "export as step in the..." everything is ok.

But I need the PROC export

So , how can I export and save all of the format ?

Thanks

Please review the guidelines on how to ask a question. This question is unclear, and I have no idea what 'him' refers to. Data typically doesn't have a gender. https://stackoverflow.com/help/how-to-ask — Reeza, Aug 29 '17 at 14:47

score 0 · Answer 1 · answered Sep 01 '17 at 07:58

PROC EXPORT DATA= WORK.data
        OUTFILE= "c:\your_path\OutputFileName" 
        DBMS=XLS LABEL REPLACE;
        NEWFILE=YES; 
RUN;

1 Answers1