BookmarkSubscribeRSS Feed
Neil_C
Calcite | Level 5

I have the data in format below:

 

id  group Sales Country1 Country2......  Region1 Region2.......

1     1         200   USA        Canada     East    South

2     1         300   USA        UK            West    North

3     2         400 ............

 

 

I have to equally distribute Sales based on the number of Country as well do the same for Regions; and then create a matrix on the sum of Sales with Country on the Row and Regions on the Columns.

 

Thanks,

 

 

3 REPLIES 3
Reeza
Super User

Ok. Please produce some sample data and expected output. 

 

You say matrix of data, are you planning to be using SAS IML, which is more matrix/array/R like R, or Base SAS programming. 

Neil_C
Calcite | Level 5

Please see the datafile attached.

I have the datafile on SAS. What I am trying to do is to create a crosstab where Sum of Sales would be shown with Country in row and 4 Regions in columns.

 

 

Reeza
Super User

That sounds like a transpose. Look into proc transpose.

 

I generally don't download XLSX files so if you can't post sample data, someone else will help. 

I still would recommend putting the expected output from your sample file, rather than having people guess at what you want. 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 3 replies
  • 1468 views
  • 0 likes
  • 2 in conversation