SAS output is text but excel paste is number. - SAS Support Communities

Obsidian | Level 7

Obsidian | Level 7

SAS output is text but excel paste is number.

Posted 04-13-2018 07:46 PM (972 views)

I have a sas output that outputs an integer result as text. For example, instead of "1" the output is "01".

However when I export or copy and paste it to excel, my '01' is now just '1'.

how do I make it where my output is '01'? Is this something I can do in SAS or is this something from excel?

1 REPLY 1

Super User

Super User

Re: SAS output is text but excel paste is number.

Posted 04-14-2018 07:05 AM (935 views) | In reply to mrdlau

Firstly , set the cell of excel be TEXT attribution, and then Past the number into that cell .

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!