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 (1350 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 (1313 views) | In reply to mrdlau

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

744853-sas-innovate-data-ai (1).jpg

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →