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!