topic Re: Help exporting correct format in SAS Procedures

Help exporting correct format

gstullo — Fri, 01 Feb 2013 20:00:02 GMT

Hi,

I am using the following to reformat some data from 9999 to 163-KN9-999:

proc format;

picture KH_Format

low-high='9-999'

(prefix='163-KH');

run;

This gives me exactly what I need and the variables look great when I export to .csv. Problem is that I need to export to .xlsx and the format does not "stick." In the .xlsx file the formats go back to only a 4 digit rather than the desired 163-KH9-999.

Any thoughts on why this is or ideas on another method that will not cause problems?

Thank!

Re: Help exporting correct format

AncaTilea — Fri, 01 Feb 2013 20:02:43 GMT

You could try the

ODS TAGSETS.EXCELXP and PROC PRINT

Anca.

Re: Help exporting correct format

Reeza — Fri, 01 Feb 2013 20:03:14 GMT

In the log SAS tells you that exporting to Excel will not maintain formats.

You have two options:

1) create a new variable and recode the variable using a put statement and output that variable instead.

2) Output using another destination, principally, tagsets.excelxp that will maintain the format.

Re: Help exporting correct format

data_null__ — Fri, 01 Feb 2013 20:03:43 GMT

I think you will need to create a character version of the variable and export it insead of the numeric.

put(x,KH_FORMAT.)