|
View previous topic :: View next topic
|
| Author |
Message |
purushottam
New User
Joined: 26 Feb 2007
Posts: 37
Location: pune
|
|
|
|
I need your help while converting CSV mainframe flat file to XLS format using SAS ODS function.
Everthing work but field which has lenght more than 10 and has numeric value in it, they show up in exponential format in xls file. For example - 2,01087E+14, actual value in my CSV mainframe flat file is 201086508850506.
It works well if I try seprating the fields by some seprater something like 201086508-850506.
This fields is defined as below in my SAS code
length Fieldname A 20
Can you help me to resolve it. |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA
|
|
|
|
| Have you tried a FORMAT for the variable? If not, you could use the PUT function to convert the numeric variable to a character variable. |
|
| Back to top |
|
|
vasanthz
Global Moderator
Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India
|
|
|
|
Hi,
| Quote: |
| I need your help while converting CSV mainframe flat file to XLS format using SAS ODS function. |
How are you actually doing this? With ODS TAGSETS.EXCELXP or ODS MSOFFICE2K or ODS CSV & naming the output file as .CSV?
Could you show the program that you are using. |
|
| Back to top |
|
|
|
|
