Try it with the map file included below. <?xml version="1.0" encoding="windows-1252"?> <!-- ############################################################ --> <!-- 2021-03-12T14:34:43 --> <!-- SAS XML Libname Engine Map --> <!-- Generated by XML Mapper, 904700.0.0.20200715190000_v940m7 --> <!-- ############################################################ --> <!-- ### Validation report ### --> <!-- ############################################################ --> <!-- XMLMap validation completed successfully. --> <!-- ############################################################ --> <SXLEMAP name="AUTO_GEN" version="2.1"> <NAMESPACES count="4"> <NS id="1" prefix="">http://www.cdisc.org/ns/odm/v1.3</NS> <NS id="2" prefix="xs">http://www.w3.org/2001/XMLSchema-instance</NS> <NS id="3" prefix="nciodm">http://ncicb.nci.nih.gov/xml/odm/EVS/CDISC</NS> <NS id="4" prefix="xml">http://www.w3.org/XML/1998/namespace</NS> </NAMESPACES> <!-- ############################################################ --> <TABLE description="ODM" name="ODM"> <TABLE-PATH syntax="XPathENR">/{1}ODM</TABLE-PATH> <COLUMN class="ORDINAL" name="ODM_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="ODM_schemaLocation"> <PATH syntax="XPathENR">/{1}ODM/@{2}schemaLocation</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>73</LENGTH> </COLUMN> <COLUMN name="ODM_FileType"> <PATH syntax="XPathENR">/{1}ODM/@FileType</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>8</LENGTH> </COLUMN> <COLUMN name="ODM_FileOID"> <PATH syntax="XPathENR">/{1}ODM/@FileOID</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>24</LENGTH> </COLUMN> <COLUMN name="ODM_Granularity"> <PATH syntax="XPathENR">/{1}ODM/@Granularity</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>8</LENGTH> </COLUMN> <COLUMN name="ODM_CreationDateTime"> <PATH syntax="XPathENR">/{1}ODM/@CreationDateTime</PATH> <TYPE>numeric</TYPE> <DATATYPE>datetime</DATATYPE> <FORMAT width="19">IS8601DT</FORMAT> <INFORMAT width="19">IS8601DT</INFORMAT> </COLUMN> <COLUMN name="ODM_AsOfDateTime"> <PATH syntax="XPathENR">/{1}ODM/@AsOfDateTime</PATH> <TYPE>numeric</TYPE> <DATATYPE>datetime</DATATYPE> <FORMAT width="19">IS8601DT</FORMAT> <INFORMAT width="19">IS8601DT</INFORMAT> </COLUMN> <COLUMN name="ODM_ODMVersion"> <PATH syntax="XPathENR">/{1}ODM/@ODMVersion</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>5</LENGTH> </COLUMN> <COLUMN name="ODM_Originator"> <PATH syntax="XPathENR">/{1}ODM/@Originator</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>55</LENGTH> </COLUMN> <COLUMN name="ODM_SourceSystem"> <PATH syntax="XPathENR">/{1}ODM/@SourceSystem</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>13</LENGTH> </COLUMN> <COLUMN name="ODM_SourceSystemVersion"> <PATH syntax="XPathENR">/{1}ODM/@SourceSystemVersion</PATH> <TYPE>numeric</TYPE> <DATATYPE>date</DATATYPE> <FORMAT width="10">IS8601DA</FORMAT> <INFORMAT width="10">IS8601DA</INFORMAT> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="Study" name="Study"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study</TABLE-PATH> <COLUMN class="ORDINAL" name="ODM_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="Study_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="Study_OID"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/@OID</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>24</LENGTH> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="GlobalVariables" name="GlobalVariables"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}GlobalVariables</TABLE-PATH> <COLUMN class="ORDINAL" name="Study_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="GlobalVariables_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}GlobalVariables</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="StudyName"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}GlobalVariables/{1}StudyName</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>33</LENGTH> </COLUMN> <COLUMN name="StudyDescription"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}GlobalVariables/{1}StudyDescription</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>45</LENGTH> </COLUMN> <COLUMN name="ProtocolName"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}GlobalVariables/{1}ProtocolName</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>33</LENGTH> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="MetaDataVersion" name="MetaDataVersion"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion</TABLE-PATH> <COLUMN class="ORDINAL" name="Study_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="MetaDataVersion_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="MetaDataVersion_OID"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/@OID</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>40</LENGTH> </COLUMN> <COLUMN name="MetaDataVersion_Name"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/@Name</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>33</LENGTH> </COLUMN> <COLUMN name="MetaDataVersion_Description"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/@Description</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>45</LENGTH> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="CodeList" name="CodeList"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList</TABLE-PATH> <COLUMN class="ORDINAL" name="MetaDataVersion_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="CodeList_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="CodeList_OID"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/@OID</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>12</LENGTH> </COLUMN> <COLUMN name="CodeList_Name"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/@Name</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>15</LENGTH> </COLUMN> <COLUMN name="CodeList_DataType"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/@DataType</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>4</LENGTH> </COLUMN> <COLUMN name="CodeList_ExtCodeID"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/@{3}ExtCodeID</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>6</LENGTH> </COLUMN> <COLUMN name="CodeList_CodeListExtensible"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/@{3}CodeListExtensible</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>2</LENGTH> </COLUMN> <COLUMN name="CDISCSubmissionValue"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{3}CDISCSubmissionValue</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>2</LENGTH> </COLUMN> <COLUMN name="CDISCSynonym1"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{3}CDISCSynonym</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>15</LENGTH> </COLUMN> <COLUMN name="PreferredTerm"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{3}PreferredTerm</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>64</LENGTH> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="Description" name="Description"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}Description</TABLE-PATH> <COLUMN class="ORDINAL" name="CodeList_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="Description_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}Description</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="TranslatedText" name="TranslatedText"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}Description/{1}TranslatedText</TABLE-PATH> <COLUMN class="ORDINAL" name="Description_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}Description</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="TranslatedText_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}Description/{1}TranslatedText</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="TranslatedText_lang"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}Description/{1}TranslatedText/@{4}lang</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>2</LENGTH> </COLUMN> <COLUMN name="TranslatedText"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}Description/{1}TranslatedText</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>100</LENGTH> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="EnumeratedItem" name="EnumeratedItem"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem</TABLE-PATH> <COLUMN class="ORDINAL" name="CodeList_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="EnumeratedItem_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="EnumeratedItem_CodedValue"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem/@CodedValue</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>2</LENGTH> </COLUMN> <COLUMN name="EnumeratedItem_ExtCodeID"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem/@{3}ExtCodeID</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>6</LENGTH> </COLUMN> <COLUMN name="CDISCDefinition"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem/{3}CDISCDefinition</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>70</LENGTH> </COLUMN> <COLUMN name="PreferredTerm"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem/{3}PreferredTerm</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>14</LENGTH> </COLUMN> </TABLE> <!-- ############################################################ --> <TABLE description="CDISCSynonym" name="CDISCSynonym"> <TABLE-PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem/{3}CDISCSynonym</TABLE-PATH> <COLUMN class="ORDINAL" name="EnumeratedItem_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN class="ORDINAL" name="CDISCSynonym_ORDINAL"> <INCREMENT-PATH beginend="BEGIN" syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem/{3}CDISCSynonym</INCREMENT-PATH> <TYPE>numeric</TYPE> <DATATYPE>integer</DATATYPE> </COLUMN> <COLUMN name="CDISCSynonym"> <PATH syntax="XPathENR">/{1}ODM/{1}Study/{1}MetaDataVersion/{1}CodeList/{1}EnumeratedItem/{3}CDISCSynonym</PATH> <TYPE>character</TYPE> <DATATYPE>string</DATATYPE> <LENGTH>14</LENGTH> </COLUMN> </TABLE> </SXLEMAP> The map-file was created using the automap with XML feature in the SAS XLM Mapper.   ... View more

Can you close the SAS Studio session using signout. Then close the browser. And in a new browser window connect again to the server and try again? I had no issue with your code example using SAS Studio from SAS OnDemand for Academics (welcome.oda.sas.com) Best regards, Jos ... View more

Does the answer: SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition (nullchar=no) from @jakarman help? https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=n1hmopc3y74oy2n1svhu03pfoiy9.htm&locale=en ... View more

Have you tried using the option client_encoding='utf-8' in the libname? See: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=acreldb&docsetTarget=n1q0m2sl5jsi7mn125qfkflg9hfl.htm&locale=en ... View more

Does the answer from @Reeza help? See thread: https://communities.sas.com/t5/General-SAS-Programming/Output-of-Proc-Compare-get-only-differences/td-p/345147 Best regards, Jos ... View more

Have you seen this post: https://communities.sas.com/t5/SAS-Communities-Library/SAS-Viya-deployment-Patterns-multiple-CAS-servers/ta-p/610901 Best regards, Jos ... View more

Does this hotfix resolve the issue? https://support.sas.com/kb/65/919.html Best regards, Jos ... View more

I used your code and ran a test on SAS OnDemand for Academics (ODA). I don't see the issue there. Can you try to run your code on ODA and verify the results? See attached pdf. Best regards, Jos ... View more

SAS and python can be used together. That allows developers and organizations to use the best of both worlds. There are many blogposts that provide useful information. Some examples: https://blogs.sas.com/content/sgf/2019/06/04/using-python-functions-inside-sas-programs/ & https://blogs.sas.com/content/sgf/2020/06/19/getting-started-with-python-integration-to-sas-viya-index/. If you are interested in actual conversion of sas code to python you can start by reading this guide: https://towardsdatascience.com/beginners-guide-to-transition-from-sas-to-python-fcd17438a7a6. ... View more