Data visualization with SAS programming

GTL BeginGraph Collation=Binary: What does it mean?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

GTL BeginGraph Collation=Binary: What does it mean?

When using the TMPLOUT= option in SGPLOT, the resulting code has COLLATION=BINARY on the BEGINGRAPH statement.

 

   define statgraph sgplot;

   begingraph / collation=binary datacolors=(CXFF0000 CX008000 CXB26306);

   ...

 

I cannot find the option COLLATION in the documentation. Does anybody out there know what it does?


Accepted Solutions
Solution
‎03-02-2017 05:50 AM
SAS Super FREQ
Posts: 1,080

Re: GTL BeginGraph Collation=Binary: What does it mean?

This is an undocumented GTL option used for sorting.  Collation can be BINARY or LINGUISTIC (Default).  BINARY collation uses the system encoding.  For ASCII "Z" comes before "a".  For EBCDIC "z" comes before "A".   So the sort order can change based on encoding, and words with upper case and lower case are in separate blocks.  In LINGUISTIC collation, lower and upper case letters come adjascent, so you get expected results, like in a dictionary.

 

See:  http://www2.sas.com/proceedings/forum2007/297-2007.pdf

 

Note, this option is undocumented, so it has not received extensive user level testing.   If you use it, it is at your own risk.

View solution in original post


All Replies
Solution
‎03-02-2017 05:50 AM
SAS Super FREQ
Posts: 1,080

Re: GTL BeginGraph Collation=Binary: What does it mean?

This is an undocumented GTL option used for sorting.  Collation can be BINARY or LINGUISTIC (Default).  BINARY collation uses the system encoding.  For ASCII "Z" comes before "a".  For EBCDIC "z" comes before "A".   So the sort order can change based on encoding, and words with upper case and lower case are in separate blocks.  In LINGUISTIC collation, lower and upper case letters come adjascent, so you get expected results, like in a dictionary.

 

See:  http://www2.sas.com/proceedings/forum2007/297-2007.pdf

 

Note, this option is undocumented, so it has not received extensive user level testing.   If you use it, it is at your own risk.

Occasional Contributor
Posts: 16

Re: GTL BeginGraph Collation=Binary: What does it mean?

this option is undocumented

No wonder I couldn't find it!

Thanks for the explanation. This confirms my suspicion that I can simply ignore (or even delete) this option when capturing GTL code produced by the TMPLOUT option of SGPLOT.

 

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 131 views
  • 1 like
  • 2 in conversation