topic Re: SAS Proc Summary in SAS Programming

SAS Proc Summary

shivrajpawar98 — Tue, 02 Jan 2024 07:06:37 GMT

Hi All,

I want to run proc summary for all the datasets in one library and store it in on pdf file how can i do it.
Any help would be appreciated.

Regards,

Shivraj

Re: SAS Proc Summary

PaigeMiller — Tue, 02 Jan 2024 13:10:37 GMT

Saying you want PROC SUMMARY results to go into a PDF file isn't specific enough. There are many choices of output that you can create from PROC SUMMARY. What specifically do you want from PROC SUMMARY to go in the PDF file?

Why do you need all of this in a PDF file anyway? These types of statistics can be stored in a SAS data set, where they would be much more useful in the long run.

Here is a way to obtain the names of all data sets in a library: https://communities.sas.com/t5/SAS-Programming/How-can-I-read-the-filenames-from-a-library-into-a-dataset/td-p/91395

Here is a way to create a data dictionary for all data sets in a library: https://communities.sas.com/t5/SAS-Communities-Library/Library-Datasets-Summary-Macro-DATA-SPECS/ta-p/544757

Re: SAS Proc Summary

Al14 — Wed, 03 Jan 2024 14:17:40 GMT

Try something like this:

%macro libraryProcMeans(library);
	%macro a; %mEnd a; /* restores color coding in SAS Enterprise Guide */

	/* Standardize capitalization of &library */
	%let library = %upcase(&library);

	/* Create space separated list of dataset names, and save
	   them into a macro variable named libraryList */
	proc sql noPrint;
		%local libraryList;
		select memname 
				into :libraryList separated by ' '
			from dictionary.tables 
			where libname="&library"
				and memtype="DATA"
		;
	quit;

	/* Loop over spaced separated items in &libraryList */
	%local i next_name;
	%let i=1;
	%do %while (%scan(&libraryList, &i) ne );
	   %let next_name = %scan(&libraryList, &i);

	   %** DO whatever needs to be done for &NEXT_NAME;
	   title"&library..&next_name";
	   ods noProctitle;
	   proc summary data=&library..&next_name print;
	   run;
	   title;	
	   ods procTitle;

	   %let i = %eval(&i + 1);
	%end;

%mEnd libraryProcMeans;

/* To output to default location and PDF */
ods pdf file="FULL_FILE_PATH\FILE_NAME.pdf";
%libraryProcMeans(sashelp)
ods pdf close;

Though, you'll probably want to customize the PROC SUMMARY, or even replace it with a PROC MEANS.

Shout out to Cindy Puryear's blog post that helped me make this response