First of all, by using month names, you will never get a chronological order, because August comes before any month not beginning with A (lexically). Convert your month/year first to something that sorts, like 2021-08 for August 2021. As it is ALWAYS better to store dates or date-related values as SAS dates, and assign appropriate formats (YYMMD7. will display the date 2021-08-01 as 2021-08, and TRANSPOSE will use the formatted value). And next, add jurisdiction as a BY variable to avoid the duplicates. ... View more

You have the define the macro (run the code with %MACRO .... %MEND) before you can execute the macro (the code with %ds2post()). ... View more

You have the define the macro (run the code with %MACRO .... %MEND) before you can execute the macro (the code with %ds2post()). ... View more

For procedures that do not have an out= data set option, or do not allow what you want in the data set you move into the ODS OUTPUT statement. Which specifies the specific table name created by the procedure and you assign a target data set name.   Generic looks like ods output generatedtable = mydatasetname; Proc whatever data= mydata <other proc options>; <other proc statements> ; run; You can either look up the tables created in the documentation in the details tab for most procedures, which usually has the options needed to create the table. Or run your code once with ods trace on; <your proc goes here> ods trace off; The LOG will then show the names of the tables generated. So you could then place them into one or more ODS OUTPUT statement.   The datasets generated by ODS output are often in a different structure, with additional variables, than in the older Output statements for most procs.   Note that ODS OUTPUT will also allow you to capture the plotted points in the procedures that provide statistical graphs such as created by the Plot statement in Proc Power, most of the regression procedures and such. ... View more