BookmarkSubscribeRSS Feed
maggi2410
Obsidian | Level 7

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!

1 REPLY 1
Tom
Super User Tom
Super User

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?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 2801 views
  • 0 likes
  • 2 in conversation