topic Importing a text file with invalid characters in SAS Programming

Importing a text file with invalid characters

Siddhartha — Fri, 14 Oct 2011 05:12:31 GMT

While Importing TSV ( tab separated value) data as a SAS data set all the Danish letters are not appearing as the same.

I was using the following code:

proc import datafile='C:\Documents and Settings\Desktop\ExpMeet.tsv'
     out=base_data
     dbms=dlm
     replace;
     delimiter='09'x;
     datarow=2;
run;

Sample Data:

Siddhartha

Helsinki 001/TelePresence || Lersø Parkalle 001/TelePresence

Bangalore 001/TelePresence ||Høje Taastrup 001/TelePresence

Anyone can help me in reading the Danish and swedish letters while importing .

Regards,

Re: Importing a text file with invalid characters

FriedEgg — Fri, 14 Oct 2011 16:55:19 GMT

You need to change your encoding option on the import. Since these are OS specific here is a link where you can find the one you need.

http://support.sas.com/documentation/cdl/en/nlsref/61893/HTML/default/viewer.htm#a002628552.htm

then do something like this:

filename in 'C:\Documents and Settings\Desktop\ExpMeet.tsv' encoding="uft-8";

proc import datafile=in
     out=base_data
     dbms=dlm
     replace;
     delimiter='09'x;
     datarow=2;
run;

Here is an additionaly resource which covers all of SAS's Language capabilities:

SAS(R) 9.2 National Language Support (NLS): Reference Guide

http://support.sas.com/documentation/cdl/en/nlsref/61893/HTML/default/viewer.htm#nlsrefwhatsnew902.htm

Re: Importing a text file with invalid characters

Ksharp — Tue, 18 Oct 2011 03:53:11 GMT

From your sample data, it looks like the delimiter is | or /, rather than tab .

And make sure your encoding of sas session has already contained Danish and swedish

Ksharp