10-14-2011 01:12 AM
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'
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 .
10-14-2011 12:55 PM
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.
then do something like this:
filename in 'C:\Documents and Settings\Desktop\ExpMeet.tsv' encoding="uft-8";
proc import datafile=in
Here is an additionaly resource which covers all of SAS's Language capabilities:
SAS(R) 9.2 National Language Support (NLS): Reference Guide
10-17-2011 11:53 PM
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