SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Create a tab delimited txt file from excel file

Reply
Contributor
Posts: 43

Create a tab delimited txt file from excel file

Hi,

I have to create a tab delimited txt file from excel using sas. Does anyone has any idea how can i do so, without creating any intermediate datasets?

Some of the cells in excel has values like 1.00, which have a format in excel cell. When i import this excel in dataset, SAS changes 1.00 to 1. I am working on UNIX. I have tried

1) Putting character values in the first row. so that SAS reads it as character and doesnt convert it. But still it does .

2) I cant use SAS libname statement in my case (due to some other issues)

Any idea!

Thanks!

Super User
Super User
Posts: 7,408

Re: Create a tab delimited txt file from excel file

Posted in reply to maggi2410

No.   If you want SAS to work on your data you will definitely need to convert it into data.

If you want a tab delimited file from Excel why not just have Excel save your file as tab delimited?

Ask a Question
Discussion stats
  • 1 reply
  • 683 views
  • 0 likes
  • 2 in conversation