BookmarkSubscribeRSS Feed
lalohg
Quartz | Level 8

Hi there,

I have a data set that looks like the one in Sheet1 of the attached Excel file and would like to get columns for each gender's color (total and by zone) for each year and age group as shown on Sheet2

 

could you please help?

 

Thanks

Eduardo.

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Hi,

 

I am sorry, I don't access Excel files on the web, its a security risk.  But in a general response to your question there are many, many articles, papers and such like out there on the subject of reshaping your data, for example:

http://www.ats.ucla.edu/stat/sas/modules/longtowide_data.htm

http://www.lexjansen.com/nesug/nesug12/ff/ff01.pdf

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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