topic Re: Proc Export to Excel dropping dollar sign in SAS Programming

Proc Export to Excel dropping dollar sign

ScotchCat — Wed, 17 Apr 2019 22:43:36 GMT

Hi - I have a dataset that I need to export into excel. Several variables have currency formatting - example: $199,999.99

When exported the $ sign is not retained - how can I retain the $ sign? Please help!!

PROC EXPORT DATA=rwork.Test3

OUTFILE= "Shared\Myfolder\Test3.xlsx"

DBMS=xlsx REPLACE;

RUN;

Re: Proc Export to Excel dropping dollar sign

Reeza — Wed, 17 Apr 2019 23:00:55 GMT

formats typically are not retained via PROC EXPORT. You can create them as character variables or use ODS which will maintain formatting.

ods excel file='shared\myfolder\test3.xlsx';
proc print data=rwork.test3;
run;
ods excel close;

Re: Proc Export to Excel dropping dollar sign

ScotchCat — Thu, 18 Apr 2019 14:36:27 GMT

Thanks! This does work, however I found I don't have sufficient memory in order to complete the process.

Back to the drawing board!!