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