topic Re: How to import and export data sets in Korean characteristics in SAS Programming

How to import and export data sets in Korean characteristics

Cruise — Sun, 26 Apr 2020 19:19:06 GMT

Hi Folks:

I'd like to use English in writing SAS programs. But I have about 10 excel datasets sorted on the ID variables that are written in Korean characteristics. I'd like to merge these 10 data sets by ID in Korean characteristics. After merging, I'll have to proc export the resulting merged dataset into excel keeping ID in Korean characteristics.

I found u8 folder in my SASFoundation folder.

Can you please help what needed to be done from here? I find SAS documentation on the topic complex. One of excel sheets that I'm trying to import and export is attached for example.

Re: How to import and export data sets in Korean characteristics

Cruise — Sun, 26 Apr 2020 21:46:28 GMT

I'm not allowed to change nls/en to nls/u8 in the SASFoundation. This is my personal laptop but still not allowed to make changes. Maybe I should try linking the tables in Excel.

Re: How to import and export data sets in Korean characteristics

SASKiwi — Sun, 26 Apr 2020 22:29:46 GMT

Did you try Administrator mode for Notepad++? You should have administrator access to your own personal laptop.

Re: How to import and export data sets in Korean characteristics

Tom — Sun, 26 Apr 2020 22:37:25 GMT

If they setup your laptop right in addition to a command to launch SAS using single byte encoding you should have one to launch using
unicode support. Just start SAS with than icon/command.

Re: How to import and export data sets in Korean characteristics

Cruise — Sun, 26 Apr 2020 22:39:10 GMT

@SASKiwi

Yes, I was able to change in the notepad+++. ThenI tried following based on SAS help center's blog with no success. Resulting test dataset has nonsensical symbols instead Korean characteristics.

FILENAME IN "D:\mydata.txt" Encoding="utf-16";
       PROC IMPORT OUT= WORK.test
       DATAFILE= IN
       DBMS=TAB REPLACE;
       GETNAMES=YES;
       DATAROW=2;
       RUN;

	   proc options option=encoding; run;

proc options option=encoding; run;

SAS (r) Proprietary Software Release 9.4  TS1M5
 ENCODING=WLATIN1

Re: How to import and export data sets in Korean characteristics

Cruise — Sun, 26 Apr 2020 22:42:17 GMT

@Tom

This is what i see. It seems that all I have is SAS with DBCS. Opening 'SAS with DBCS' version help?

Re: How to import and export data sets in Korean characteristics

Cruise — Sun, 26 Apr 2020 22:45:34 GMT

@Tom

Yay, I found one with unicode support. Can you show me in SAS code how to import the file that I attached to this post for example? Given that I now have opened Unicode Support SAS, please?

Re: How to import and export data sets in Korean characteristics

Cruise — Sun, 26 Apr 2020 22:51:16 GMT

@Tom this worked. I can't believe my eyes!!!! Thank you so much. I struggled whole 5 hours. The problem was solved in just couple minutes. Thank you.

FILENAME IN "camp1.txt";
       PROC IMPORT OUT= WORK.test
       DATAFILE= IN
       DBMS=TAB REPLACE;
       GETNAMES=YES;
       DATAROW=2;
       RUN;

Re: How to import and export data sets in Korean characteristics

Tom — Sun, 26 Apr 2020 22:54:36 GMT

Glad it worked, but that code would NOT work with the file you originally posted. That files was an XLSX file, not a tab delimited text file your code is reading.

Re: How to import and export data sets in Korean characteristics

Cruise — Sun, 26 Apr 2020 23:00:50 GMT

@Tom

Yes, you're right. It didn't work with .xlsx datasets that I actually have unless I open them one by one and save to unicode.txt. I tried the code below which created non-sensical dataset. Any suggestion as to how to make/modify this code to work for .xlsx files?

PROC IMPORT OUT=test_excel
DATAFILE="camp.xlsx"
DBMS=TAB REPLACE;
GETNAMES=YES;
DATAROW=2;
RUN;

Re: How to import and export data sets in Korean characteristics

Tom — Sun, 26 Apr 2020 23:17:40 GMT

I am sure that is a good representation of what it would like if you read the binary XLSX file as if it was a text file.

You need to tell PROC IMPORT to use the XLSX engine.

proc import dbms=xlsx datafile="&path\&fname"
  out=test replace 
;
run;