I use a DATA step. The incoming data is char 4, like so: GBPF. When I do a proc contents on the SAS file that is used to create the Excel file, all the char fields show as at least $63 format with a length of 63. I tried the TRIM function and the SUBSTR function in the data step, but no change. Is there a way to specify field types/lengths in the proc export step? Thanks. BTW: We have been using Hyperion to do this with no problems so I don't think it's the data.
... View more