Dear all, I have recently come across a very surprising behaviour of PROC METALIB: if the format (same format name, same catalog) indicated at the metadata server level uses letter cases(s) different from the letter case(s) used in the descriptor portion of a dataset, PROC METALIB considers these formats as different. So if we have, say, the format at the metadata server level written as $ASquared. and the format stored in the descriptor portion of the dataset (to which the metadata object is pointing) written as $ASQUARED. PROC METALIB (noexec; report;) considers the formats are different. This is a problem because we are currently using PROC METALIB to identify any discrepancies between the (metadata server) metadata and the descriptor portion of datasets, and this is obviously giving us a (currently unknown) number of false positives (I haven't checked the informats yet, but I assume the same problem wil arise). And it is surprising because SAS does not allow the same format (even with different letter case(s)) to be present in the same catalog (this is SAS on Windows). Is this something one of you has already noticed? Is there a fix? Many TIA Cheers Anne.
Probably the most expedient fix would simply be to make the metada match (case-wise). For that, you could consider updating the physical metadata using these two macros (one to get the formats, the other to apply them (after an uppercase):
/Allan SAS Challenges - SASensei MacroCore library for app developers SAS networking events (BeLux, Germany, UK&I) Data Workflows, Data Contracts, Data Lineage, Drag & drop excel EUCs to SAS 9 & Viya - Data Controller DevOps and AppDev on SAS 9 / Viya / Base SAS - SASjs
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.