BookmarkSubscribeRSS Feed
ranikeka
Calcite | Level 5
Hi

I started working on qc of tables and graphs. I know proc freq will give the numbers and frequency. But how to bring the table output as per the mock shell.

Can you please give me some papers or codes that could help and understand the process.
Thanks
4 REPLIES 4
PaigeMiller
Diamond | Level 26

Please provide more explanation and detail about what you are doing. "qc of tables and graphs" is very vague, and doesn't mean anything to me.

--
Paige Miller
ballardw
Super User

@ranikeka wrote:
Hi

I started working on qc of tables and graphs. I know proc freq will give the numbers and frequency. But how to bring the table output as per the mock shell.

Can you please give me some papers or codes that could help and understand the process.
Thanks

Mock shell? If there is supposed to be an attachment it didn't get attached.

If your shell is in Excel be aware that many of use will not, or cannot by organization policy, open such documents from unknown sources.

 

Reeza
Super User

Welcome to the world of reporting. 

 

Unfortunately everyone's definition of a mock shell is often different so you usually need to roll your own. Fortunately there's lots of examples to get you started. QC isn't as popular, but clinical reporting is exactly the same concept and there are thousands of examples out there. 

 

You can search lexjansen.com for your topics and you'll find many user written examples. 

 

Here are two in the Knowledge Library to help get you started, that cover demographic summaries and data specification macros:

 

https://communities.sas.com/t5/SAS-Communities-Library/Demographic-Table-and-Subgroup-Summary-Macro-...

https://communities.sas.com/t5/SAS-Communities-Library/Library-Datasets-Summary-Macro-DATA-SPECS/ta-...

 

A quick way for PROC FREQ:

https://gist.github.com/statgeek/e0903d269d4a71316a4e

 

 

Here's some instructions and explanations on how to capture output that is shown.
https://blogs.sas.com/content/sastraining/2017/03/31/capturing-output-from-any-procedure-with-an-ods...

 

 

Macro tutorials are below. Before you start macros, first ensure you have a working prototype then convert your program to a macro!!!!!!!!!!!!!

 

UCLA introductory tutorial on macro variables and macros
https://stats.idre.ucla.edu/sas/seminars/sas-macros-introduction/

Tutorial on converting a working program to a macro
This method is pretty robust and helps prevent errors and makes it much easier to debug your code. Obviously biased, because I wrote it 🙂 https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

Examples of common macro usage
https://communities.sas.com/t5/SAS-Communities-Library/SAS-9-4-Macro-Language-Reference-Has-a-New-Ap...

ranikeka
Calcite | Level 5
Thank you so much 😊 there’s a lot of information.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1251 views
  • 0 likes
  • 4 in conversation