10-13-2015 07:20 AM
I'm trying to pull customer names from Access.I looking for DDE to run Ms_access from sas. The Ms-acess is pulling data from Oracle DB. I cant connect directly to the DB because the customer name is in chinese character.
10-13-2015 07:24 AM
I don't know if you can use DDE with MS Access. Euther way, it's ancient tehnology, and you suggest that you look for alternatives.
The main way to acess MS Access data (among other sources) is SAS/ACCESS to PC FIle Formats. Once there, you can use a libname directly to the Access database.
Just out of curiosity, how does Access handle the chineese character problem? And how do you wish to use the names in SAS?
10-13-2015 08:14 AM
Yes. MS-Access handles the china characters.
"The main way to acess MS Access data (among other sources) is SAS/ACCESS to PC FIle Formats. Once there, you can use a libname directly to the Access database."
Can you give out an example how to do this.
I tell you how Access is pulling the data from Oracle. Once I run the queryin Access there are some intermediate small tables are created. These intermediate table are just nothing but to make the data diff. From these tables they made final query in Access and running the query to get the chinese character.
This is the first time I'm trying to pull the data from access. I'm still exploring those intermediate tables. Just want to know is there any easy way to pull data from it by using DDE/some other method either in Base/EG sas.
10-13-2015 05:43 PM - edited 10-13-2015 05:48 PM
If you need these chinese characters in SAS in the end then going via SAS/Access won't help. What you need in such a case is your SAS session to run in a multi-byte mode.
If the chinese characters also end up in MS Access then you'll have exactly the same issue there when trying to pull this data into SAS.
If you just need to do some processing with these chinese names but you don't need to pull this column into SAS then process on the data base using pass-through SQL and only pull the result of this operation into SAS (whithout the column with chinese names). This should work as long as none of the charater fields transferred to SAS contains a multi-byte character.