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,
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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.