topic Re: How do I organize my variables to make a descriptive data table comparing certain columns in New SAS User

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

crocena — Tue, 30 Nov 2021 14:43:53 GMT

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.

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

PaigeMiller — Tue, 30 Nov 2021 14:51:00 GMT

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.

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

crocena — Tue, 30 Nov 2021 14:53:25 GMT

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

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

PaigeMiller — Tue, 30 Nov 2021 14:57:41 GMT

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.

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

crocena — Tue, 30 Nov 2021 15:00:07 GMT

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?

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

crocena — Tue, 30 Nov 2021 15:01:49 GMT

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

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

crocena — Tue, 30 Nov 2021 15:15:15 GMT

This is a screenshot of my data!

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

PaigeMiller — Tue, 30 Nov 2021 15:22:19 GMT

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.

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

PaigeMiller — Tue, 30 Nov 2021 15:56:28 GMT

@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.

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

crocena — Tue, 30 Nov 2021 16:21:39 GMT

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?

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

crocena — Tue, 30 Nov 2021 16:23:50 GMT

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.

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

PaigeMiller — Tue, 30 Nov 2021 16:58:27 GMT

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.