Unlike 9.4 the "DATA Step Functions for Reading and Writing Metadata" are not working with Viya. I have tried with a lot of SAS function regarding metadata fetching or update and all of them fail. I believe it is all aroung setting metadata profile, which I am unable to do. Below is example of code I am running. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 options metaserver="XXXXXXXXXXXX.XX.XX.com" 74 metaport=8561 75 metauser="XXXXXXXX" 76 metapass=XXXXXXXXXXXXX 77 metarepository="Foundation"; 78 79 /* Get macro variable bit flags. */ 80 %mdseccon(); 81 82 data _null_; 83 format tc $20.; 84 length uri $256; 85 tc = ""; 86 uri=""; 87 88 /* Create a PhysicalTable object. */ 89 rc=metadata_newobj("PhysicalTable", 90 uri, 91 "My Demo Table for METASEC"); 92 93 /* Start transaction on object created above using the URI. */ 94 rc=METASEC_BEGTRAN(uri,0,tc); 95 if (rc < 0 ) then do; 96 sysmsg = sysmsg(); 97 put sysmsg; 98 end; 99 100 /* ... other operations using the TC ... */ 101 102 /* End the transaction and commit any changes made to */ 103 /* the transaction since it was started. */ 104 rc=METASEC_ENDTRAN(uri,tc, &_SECAD_COMMIT_TC ); 105 if (rc < 0 ) then do; 106 sysmsg = sysmsg(); 107 put sysmsg; 108 end; 109 110 /* Delete the PhysicalTable */ 111 rc=metadata_delobj(uri); 112 113 run; ERROR: A Transaction Context handle was not specified for the METASEC_ENDTRAN function. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 114 115 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 128
... View more