Prev: Nomograms using annotate?
Next: Unable to read Unicode file into SAS file - able to do after
From: Cherish K on 19 Jan 2010 10:36
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
DATAFILE=chr
DBMS=DLM REPLACE;
DELIMITER = '|';
GETNAMES=YES;
DATAROW=2;
RUN;

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
properly.

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?)

Regards,
Cherish
 | 
Pages: 1
Prev: Nomograms using annotate?
Next: Unable to read Unicode file into SAS file - able to do after