topic problem importing currency symbol column (in particular British pound currency) that comes up as ? in SAS Programming

problem importing currency symbol column (in particular British pound currency) that comes up as ?

reubens — Thu, 28 Sep 2023 17:26:53 GMT

Please help (if indeed there is a solution)

I’m running a proc import (see 21.sas)

I'm using SAS 9.4 (unicode support), which I need to use to ensure my data files are consistent in their encoding.

However, the proc import shows the British pound symbol as a question mark with a black diamond around it.

Can you please help with resolving the proc import command to show the data the correct currency symbol?

[Note: Using SAS9.4 (english) will import the british pound currency just fine]

I look forward to your response.

Attached is a small CSV file with my proc import code

cheers,

Reuben

Re: problem importing currency symbol column (in particular British pound currency) that comes up as

Kurt_Bremser — Thu, 28 Sep 2023 17:37:43 GMT

For one, do never use PROC IMPORT for csv files; you are MUCH better off writing the DATA step yourself.

Second, I suspect that your csv file was created in a single-byte environment, and you should use the ENCODING= option of the INFILE statement, most probably with a value of WLATIN1.

Re: problem importing currency symbol column (in particular British pound currency) that comes up as

reubens — Thu, 28 Sep 2023 17:46:54 GMT

thanks you so much Kurt for the quick reply and solution

Perfect, that works great!