Hi @cuevasj,
While there isn't the concept of SAS macros for user identification, it is possible to apply conditional grants on your table and have row-level security imposed to achieve what you're after. If you want your graphs and charts not to have row-level security though, you would need to have 2 versions of the table, one with row-level security and use this in your tables/cross-tabs and the standard table in your charts/graphs. Be aware though the aggregated figures will be different due to the subsetting imposed.
Please note if you allow the export data option from your graphs/charts ALL your end-users will be able to export and see the underlying data for all schools. So you may want to restrict this capability or ensure row-level security is consistent across all report objects.
Some reference SAS Global Forum papers that you may find useful:
http://support.sas.com/resources/papers/proceedings16/11701-2016.pdf
http://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf
http://support.sas.com/resources/papers/proceedings15/3298-2015.pdf
Kind Regards,
Michelle
... View more