Have you using utf-8 encoding? It works for some unicode files.
From: Cherish K
Sender: SAS(r) Discussion
ReplyTo: Cherish K
Subject: Unable to read Unicode file into SAS file - able to do after using 'convert into DOS'. Please help
Sent: Jan 19, 2010 11:36 PM
From MS SQL, I extracted a huge file of size 2.5GB. But the file was unicode
encoded. So the usual import function wasn't working.
From the archives I found a code written by DATA_NULL which says to use
filename and encoding option;
Below is the code given by data null
filename chr "File_LOCATION\FILENAME.csv" encoding = Unicode;
proc import datafile = chr out = chk
DELIMITER = '|';
what was happening is initial few columns were getting imported properly,
i.e. out of 97 columns 25 were imported properly, 5-7 partial import, and
the rest blanks.
When i opened the file in textpad, i could see that all the fields are
populated. What might be the problem?
I used convert to DOS option in textpad and then converted using usual
import option and it was working well i.e. all columns are getting imported
But to do this I had to split the file into smaller ones so that I can open
it in textpad and then use convert to DOS option.
Is there a way in SAS where I can directly convert the unicode csv file to
SAS (reading all the columns?)
Sent from my BlackBerry Wireless Handheld
Certified Advanced Programmer for SAS V9
Certified Basic Programmer for SAS V9