topic Re: Determine Character Set used in a SAS Data File in SAS Programming

Determine Character Set used in a SAS Data File

ghassanzghaib — Mon, 05 Feb 2018 18:43:19 GMT

Hi,

How can I tell what character set (locale) is used in a SAS data file?

I have an issue using some SAS datafiles in Tableau. When I connect to the data file and view it in Tableau, some rows are missing. These rows show up in SAS EG. When I create a copy of the SAS data file using proc copy and connect to it with Tableau, the rows appear.

Thanks in advance.

Re: Determine Character Set used in a SAS Data File

SASKiwi — Mon, 05 Feb 2018 21:48:25 GMT

PROC CONTENTS will tell you the encoding (character set) of a SAS dataset:

proc contents data = sashelp.class;run;

You will find the SAS NLS Guide helpful in fixing NLS options:

http://documentation.sas.com/?docsetId=nlsref&docsetTarget=n1d2i07lune0dxn1bsah301axr4v.htm&docsetVersion=9.4&locale=en