Determine Character Set used in a SAS Data File

Accepted Solution Solved
Reply
Established User
Posts: 1
Accepted Solution

Determine Character Set used in a SAS Data File

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.


Accepted Solutions
Solution
‎02-12-2018 03:38 PM
Super User
Posts: 3,918

Re: Determine Character Set used in a SAS Data File

Posted in reply to ghassanzghaib

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&docsetVe...

View solution in original post


All Replies
Solution
‎02-12-2018 03:38 PM
Super User
Posts: 3,918

Re: Determine Character Set used in a SAS Data File

Posted in reply to ghassanzghaib

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&docsetVe...

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 108 views
  • 1 like
  • 2 in conversation