Hey guys, I'm brand new to SAS and have limited experience, and the problem that I'm having seems way over my head. I'm trying to import data from an excel file into SAS, but during a my data step I get an error about encoding. Here's the script that I'm running: libname surveyx pcfiles path='C:\Users\au551418\Desktop\Learning SAS\AUWork\Survey\Survey.xlsx'; data work.survset; set surveyx.’Data$’n; run; The surveyx library successfully is assigned each time, but when it comes to the set function, I always get this error: ERROR: Unable to transcode data to/from UCS-2 encoding Now, I don't know anything about encoding, and have tried to look up on previous forum posts what in the world to do. I have tried a lot of stuff, but none of it has worked, and many of the posts are not xlsx files (which I have no idea if that matters or not). Can anyone help me in a simplistic way? Thanks!
... View more