DATA Step, Macro, Functions and more

SAS output is text but excel paste is number.

Reply
Contributor
Posts: 36

SAS output is text but excel paste is number.

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?

Super User
Posts: 10,610

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 72 views
  • 1 like
  • 2 in conversation