Thank you for responding. ... View more

Hi, Try this: (year(date)<=year(datepart(now())) if you want to filter for previous years and filter the current year until the current month, you can use: (year(date) < year(datepart(now()))) or (Year(date)=year(datepart(now())) and month(date)<=month(datepart(now())))       ... View more

you can use the Format function for this ... View more

Hi, If the column you want to hide isn't a measure but a dimension, maybe it's an idea to use a hierarchy You can place the column you want to hide at the bottom of that hierarchy.   Good luck, Theun   ... View more

If I do not understand wrongly your concern, you can achieve updating the aggregated table correctly applying parameters in the filter of the aggregated table. this should keep them synchronized. ... View more

Consider this example (based on the Class dataset)   Calculated Category Male (if the condition isn't true, set the value to missing) if 'Sex'n = 'M' return 'Name'n else ''   Aggregated measure: Number of Males (count the distinct number of values and adjust (if necessary with the number of missing values) Distinct [_ByGroup_] ('Male'n) - (IF ( NumMiss [_ByGroup_] ('Male'n[Raw]) >= 1 ) RETURN 1 ELSE 0 )             ... View more

Hi,   SAS has this pretty well documented in their "Security Administration Guide". Look for the "User Import Macros", there is some sample code as well.   https://documentation.sas.com/api/docsets/bisecag/9.4/content/bisecag.pdf?locale=en   Good luck.   Theun   ... View more