BookmarkSubscribeRSS Feed
ybz12003
Rhodochrosite | Level 12

Hello,

I would like to create a table for top row is year, the most left column is month, then site is the subgroup under year.  I'm not sure if there is a way to do it.

1 REPLY 1
ballardw
Super User

Data is helpful.

 

Proc tabulate is a very likely candidate as I find it easier to nest things vertically.

 

And what goes into the intersection of month and site columns?

Here is an example of a similar report using the SASHELP.STOCKS set that you likely have available. The first data step basically just adds a month variable.

data fortable;
   set sashelp.stocks;
   month=month(date);
run;

proc tabulate data=fortable;
   class date month stock;
   format date year4.;
   var close;
   table month,
         date*stock=' '*close="Max close"*max=''*f=dollar10.2
         /misstext=' '
   ;
run;

The =' ' that appear are just to modify the default column heading text. When it is '' or ' ' then that suppresses a level of the column (or row) heading. This report show the maximum closing price of each Stock, which would be your SITE variable, for each month.

I am using the format YEAR4. on a date value to just display the year.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 628 views
  • 0 likes
  • 2 in conversation