I know this is a really old thread, but I finally have a use for this - I've got a SAS dataset with hundreds of hospital diagnosis codes, and I only want to keep the code fields that have at least one non-blank value (to save space). I was going to use Sridharma's %DROPMISS macro mentioned above (it's hundreds of lines of SAS code, but it works well). However, this option using the NLEVELS option (which I've never heard of) also works well, and it's MUCH shorter. I think I'll use that. Thanks! ... View more

@LukaszStasiak,   I would suggest you to use the utility called sas-list-objects to get an XML with all reports from the specific metadata folder, here is an example:   /<SASHome>/SASPlatformObjectFramework/9.4/tools/sas-list-objects -host <METADATA_HOST> -port 8561 -user <METADATA_USER> -password <METADATA_PASSWORD> -folder "/Products/SAS Visual Analytics/Samples/" -types Report -format xml   Here are results:   <?xml version='1.0' encoding='UTF-8'?> <Objects> <Object Path="/Products/SAS Visual Analytics/Samples/Capital Exposure and Risk Sample(Report)" Name="Capital Exposure and Risk Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo illustrates how financial institutions can gain an understanding of their portfolio risks across the business they can better manage exposures and make well informed decisions." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/> <Object Path="/Products/SAS Visual Analytics/Samples/Casino Floor Performance Sample(Report)" Name="Casino Floor Performance Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo example looks at casino floor performance at a two-casino gaming company." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/> <Object Path="/Products/SAS Visual Analytics/Samples/Revenue Optimization Sample(Report)" Name="Revenue Optimization Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo illustrates how retailers can see which products are not priced competitively, which products should be considered for a price markdown, and how well promotional plans are performing." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/> <Object Path="/Products/SAS Visual Analytics/Samples/SAS Visual Analytics Sample(Report)" Name="SAS Visual Analytics Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="SAS Visual Analytics Sample" Created="2015-09-16T22:20:56Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:23Z" ModifiedBy="sasadm"/> <Object Path="/Products/SAS Visual Analytics/Samples/SAS Visual Analytics Sample Includes Exploration Content(Report)" Name="SAS Visual Analytics Sample Includes Exploration Content" Type="Report.BI" TypeLabel="SAS report (2G)" Description="" Created="2015-09-16T22:19:57Z" CreatedBy="sasadm" Modified="2016-12-13T23:20:05Z" ModifiedBy="sasadm"/> <Object Path="/Products/SAS Visual Analytics/Samples/Student Analysis Sample(Report)" Name="Student Analysis Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="" Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/> <Object Path="/Products/SAS Visual Analytics/Samples/Warranty Analysis Sample(Report)" Name="Warranty Analysis Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo explores how organizations can effectively analyze warranty claims to identify potential issues and understand the drivers of these issues." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/> <Object Path="/Products/SAS Visual Analytics/Samples/Wireless Call Quality Analysis Sample(Report)" Name="Wireless Call Quality Analysis Sample" Type="Report.BI" TypeLabel="SAS report (2G)" Description="This demo explores how a network operations manager or engineer might analyze call quality at a communications service provider." Created="2015-09-16T22:21:06Z" CreatedBy="sasadm" Modified="2016-12-13T23:21:36Z" ModifiedBy="sasadm"/>   All you need to do after that is parse an XML file. ... View more

I believe this message is shown if you have more than one date for one ore more geo categories. Are you able to either aggregate (change the format on the date field) or filter out the relevant entries? Maybe you can use a crosstab using both the date and geo category and check for entries with frequency > 1. Hope this helps. Falko ... View more