topic Reading Euro symbol from external file in SAS Data Science

Reading Euro symbol from external file

garag — Wed, 06 Jun 2012 10:31:52 GMT

Hi,

I'm getting problem reading Euro symbol € from exeternal file.

Here you are the code:

data mydatset;

infile "&localfilename" delimiter=',' dsd missover firstobs=2;

            informat
              Date                      yymmdd10.
              Name               $100.

;

format
Date date9.;

            input
              Date
              Index_Name               $
              ;

run;

If in my external file there is an Europ symbol (€), I can't get it in mydataset but a strange square is showed.

Any idea abou thow to fix it?

Many thanks

Re: Reading Euro symbol from external file

Tom — Wed, 06 Jun 2012 11:40:33 GMT

The square is probably how your current character set displays that character. To see what actual ASCII code has been read from your file put the string using the $HEX format. This will display each character as two hexadecimal digits representing the 8 bit code. For example the digit zero is 30 in hex. The letter A is 41. The letter J is 4A.

Re: Reading Euro symbol from external file

Andre — Wed, 06 Jun 2012 12:57:26 GMT

I have tried from a french excel 2010 saving in csv like this but my sas is also regulated in latin1 with french language.

My try with amounf countaining an euro formatted excel

saved in european csv where delimiter is = ; as comma is the decimal separator gives under ultraedit

euro symbol is represented in hex as 80 issued from excel2010

under ultraedit i saved too the csv file in utf8 encoding for my second try

and in both case in sas this program was correct with the same result for both

code but recall i am under a french version of sas

so you may try with the encoding of euro exists too under iso8859-15 equivalent of latin9

data try1;

infile "d:\temp\euro1.csv" delimiter=';' dsd missover firstobs=2;* encoding='latin9';

informat

Name $10. amount eurox10.2 Date ddmmyy10. ;

format Date date9.;

input

name $ amount Date ;

run;

data try2;

infile "d:\temp\euro1utf8.csv" delimiter=';' dsd missover firstobs=2 encoding='utf8';

informat

Name $10. amount eurox10.2 Date ddmmyy10. ;

format Date date9.;

input

name $ amount Date ;

run;

the other solution is applying a nls informat to a variable that is not well presenting

as some utf8 character was embedded inside so perhaps:

x=input ( name, $utf8x10.);

HTH

Andre

Re: Reading Euro symbol from external file

Andre — Fri, 08 Jun 2012 10:13:11 GMT

There is a new book at SAS

"Sas encoding understanding the details " by Manfred Kiefer 175 p

where the euro symbol is well mentionned as Latin9 !

http://support.sas.com/publishing/authors/kiefer.html

options locale=fr_FR; this options seems now from 9.3 accepted by SAS Foundation

so if anybody in the USA can test my answer on an american version of SAS

it may be now more easier to treat those kind of difficulties without the reserve i have presented in matter of encoding=

and after return to

options local=English_UnitedStates;

sorry but after reading more into the nls manual

the change of locale has only effect upon

dflang= datestyle= and papersize=

sorry again you have to start sas with another encoding or make use of the encoding= options in proc import, infile and so on

Andre