Help using Base SAS procedures

Maintaining data formats from sas to excel using proc export

Reply
N/A
Posts: 1

Maintaining data formats from sas to excel using proc export

Hello,

I have a dataset with numeric variable _MONTH with values 1,2,3, etc...

I've applied a format so that 1="Jan", 2="Feb", 3="Mar", etc... for this variable within the sas dataset.

I'd like to export this sas dataset into excel using proc export but the variable _MONTH continues to display the actual numeric (1,2,3,etc.) values instead of the formatted (Jan, Feb, Mar,etc) values.  Is there any way that I can maintain formats from the sas dataset into the excel file using proc export?

Thanks in advance for any suggestions,

Mackenzie

Super User
Posts: 17,828

Re: Maintaining data formats from sas to excel using proc export

Not with proc export no, the log says so.

Use tagsets.excelxp or another option.

Ask a Question
Discussion stats
  • 1 reply
  • 175 views
  • 0 likes
  • 2 in conversation