Help using Base SAS procedures

excel to dataset

Reply
Frequent Contributor
Posts: 145

excel to dataset

I have an excel file and I am planning to convert them SAS dataset using proc import..

some of the columns in Excel has special characters like $%@ etc.... As a result I getting the following warning..........

'

some character data was lost during transcoding

'

Any suggestions on this....

Thanks

Super User
Posts: 10,020

Re: excel to dataset

Posted in reply to rakeshvvv

try to save this excel file as CSV file .

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