How do I organize my variables to make a descriptive data table comparing certain columns

[crocena]

I have gotten a means descriptive table with my simplified data, but I need the layout to be different. I need it to be arranged like the table attached that is blank. 

[PaigeMiller]

Many of us will not download Microsoft Office documents because they are a security threat. Please make a screen capture of the desired layout and use the "Insert Photos" icon to include this in your reply.

In addition, in order for us to help you with programming, we would need to see (a portion of) the original data. This portion of the original data needs to be provided as SAS data step code (instructions), you can see an example here. We cannot program from data in screen captures or Excel files.

[crocena]

 

 The blank is what I need it to look like and the filled out is as much as I could get from my data.

[PaigeMiller]

Please don't ignore my request for (a portion of) your original data, we can't help you without that.

Please don't ignore my instructions on how to provide the original data.

Please explain how you get the numbers in the 2nd table from the first table.

[crocena]

I am not ignoring! I am trying to get it to you. I am very new to sas and I do not know how to do that even with the link you provided. Can you please assist me?

[crocena]

The second table layout is one determined by my professor and how he wants it to be displayed. 

[PaigeMiller]

---

@crocena wrote:

The second table layout is one determined by my professor and how he wants it to be displayed. 

---

But this doesn't EXPLAIN anything, we need to understand how to derive the numbers in the table. Your professor didn't explain it to us, so I am asking you to explain it to us.

[crocena]

The data is a comparison of BMI less that 24.9 and greater than 24.9 to age, gender, location, and food intake in the content of those listed.

[crocena]

 

This is a screenshot of my data!

[PaigeMiller]

The link I gave has a .zip file at the bottom that you can download, and then use the DATA2DATASTEP macro as explained in the text.

[crocena]

I downloaded the zip, but I am unable to open it. When I put in how it is instructed I get a syntax error and that the order is incorrect. Does this picture assist with what I am doing wrong?

 

[PaigeMiller]

When you unzip the SAS file contained in the download, you then paste the code from the SAS file into your SAS and run it. Then you can run the %DATA2DATASTEP command.