topic Re: Any ideas on how to create a report? (picture included) in New SAS User

Any ideas on how to create a report? (picture included)

AVUH777 — Tue, 20 Dec 2022 18:47:16 GMT

Hello,

So, I am attempting to create a report similar to the attached image.

To get the numbers in the original, I used a comprehensive sas data set to create 3 separate tables (male, female, missing) to obtain the frequencies and calculated the totals and percent by hand. I have no idea of how to get started on completely automating the process so any thoughts would be helpful.

Re: Any ideas on how to create a report? (picture included)

PaigeMiller — Tue, 20 Dec 2022 18:49:56 GMT

In order to write any code, we would need to see (a portion of) your original data. Please provide the data as working SAS data step code, which you can type in yourself or follow these instructions. Do not provide data as screen captures or file attachments.

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Tue, 20 Dec 2022 18:54:29 GMT

Hey! I'm unable to share any code. Just looking for general ideas on how to create a similar report. Thanks.

Re: Any ideas on how to create a report? (picture included)

PaigeMiller — Tue, 20 Dec 2022 19:01:37 GMT

@AVUH777 wrote:

Hey! I'm unable to share any code. Just looking for general ideas on how to create a similar report. Thanks.

I didn't ask to see your code, I need to see your data. If you can't send real data, then make some up so that it is organized the same as your real data; put it in the requested form, and show us.

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Tue, 20 Dec 2022 19:21:05 GMT

Sorry, I misunderstood. Does this help?

data WORK.STUDENTS;
input UniqueID Gender $ Grade_Level;
datalines;
89562 F 1
78921 M 2
78961 F 5
46526 M 4
;
run;

Re: Any ideas on how to create a report? (picture included)

PaigeMiller — Tue, 20 Dec 2022 19:24:10 GMT

The data (even if it is fake) must match the arrangement of your original data, and must contain all the elements needed to produce the table that you want. There are variables in the table that you want that are not in this data. So, no, this doesn't help.

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Tue, 20 Dec 2022 19:37:13 GMT

Everything calculated in the report came from the data. Originally, I created new data sets based on gender. So, a table for females, males, and missing gender. Then, calculated the frequency of the gender variable for each table. By hand, I added together the totals and calculated the cumulative percent.

Re: Any ideas on how to create a report? (picture included)

PaigeMiller — Tue, 20 Dec 2022 19:39:44 GMT

Where is the freshman, sophomore ... etc. part? It's not in your data.

Where is the Year (on the left of your table it says Enrollment by Grade span 2008-2009)?

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Tue, 20 Dec 2022 19:40:49 GMT

Forgot to add that I grouped by grade_level before calculating frequencies. I'm not looking for an exact way to create the report. Just an idea to eliminate the hand calculations and create a similarly formatted report.

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Tue, 20 Dec 2022 19:41:29 GMT

The entire dataset is from that year so I do not have a year variable.

Re: Any ideas on how to create a report? (picture included)

PaigeMiller — Tue, 20 Dec 2022 19:46:05 GMT

data STUDENTS;
input UniqueID Gender $ Grade_Level;
datalines;
89562 F 1
78921 M 2
78961 F 5
46526 M 4
;
run;
proc freq data=students;
   tables grade_level*gender;
run;

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Tue, 20 Dec 2022 19:52:37 GMT

Thanks! Any idea on how to use SAS to create a similar report in terms of the image I provided? I'm being asked to cut out the use of Microsoft Word (which I used to create the attached image) to create the report and use only SAS.

Re: Any ideas on how to create a report? (picture included)

Quentin — Tue, 20 Dec 2022 21:48:37 GMT

Look into examples of using PROC TABULATE. PROC REPORT would be another option.

If you search lexjansen.com for PROC TABULATE should find lots of papers that could help get you started.

Re: Any ideas on how to create a report? (picture included)

ballardw — Tue, 20 Dec 2022 22:06:39 GMT

An example that creates a report of similar structure using a SAS supplied data set you should be able to use:

proc tabulate data=sashelp.class;
   class sex age;
   tables age,
          sex=''*n='' all=''*(n='Total' pctn='%')
          /misstext=' '
   ;
run;

The ='' bits are suppressing default labels.

Sex is basically the same as your Gender variable for role, Age as grade.

There are many appearance options available.

Re: Any ideas on how to create a report? (picture included)

fja — Wed, 21 Dec 2022 08:17:29 GMT

If you search lexjansen.com for PROC TABULATE should find lots of papers that could help get you started.

Hmm, isn't the information provided there a bit hard to digest for beginners? The site is great, though. Thank you for bringing that (back) to my attention/memory.

--fja

Re: Any ideas on how to create a report? (picture included)

Quentin — Wed, 21 Dec 2022 13:29:59 GMT

@fja wrote:

If you search lexjansen.com for PROC TABULATE should find lots of papers that could help get you started.

Hmm, isn't the information provided there a bit hard to digest for beginners? The site is great, though. Thank you for bringing that (back) to my attention/memory.

--fja

Could be hard to digest for some beginners, but I think it's worth the effort. There is a wealth of wisdom is papers written by users (and developers). For a general "how can I make this sort of table" question, reading papers will provide lots of interesting approaches. It also introduces beginners to the existence of SAS user group conferences, another great way to learn.

This paper by guru Art Carpenter has examples similar to yours. https://support.sas.com/resources/papers/proceedings11/260-2011.pdf

I also recommend books for beginners. I think of Lauren Haworth's book as the classic text on PROC TABULATE. Sadly, looks like it's out of print. But you can find used versions available online. https://support.sas.com/en/books/authors/lauren-haworth.html

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Wed, 21 Dec 2022 15:17:23 GMT

Thank you! I will look into this. 🙂

Re: Any ideas on how to create a report? (picture included)

AVUH777 — Wed, 21 Dec 2022 15:18:31 GMT

Thank you so much! This was very helpful.