why does my SAS9.4 open excel output everytime I run my program?

HitmonTran — Tue, 03 Nov 2020 22:58:46 GMT

Does anyone know if this is a setting in SAS9.4 or is in in my proc report?

Everytime I run my program it opens 15 excel outputs of each subjects.

%MACRO pp;
	%do i=1  %to &subj_n.;
		%let select_subj = %scan(&subj., &i., '#');  *Creating macro variables to select patients one by one;


		************************************************************************************************************************
		**********************************	Generating pdf reports with patients profiles	************************************
		************************************************************************************************************************;
		options;
		ods listing close;
		ods escapechar='^';
		ods tagsets.excelxp options(sheet_interval="NONE") file="Patient Profile Subject &select_subj..xml";
		*ods tagsets.ExcelXP file="Patient Profile Subject &select_subj..xml" style=statistical;
	
	*	ods html close;
		
	*	ods pdf file = "Patient Profile Subject &select_subj..pdf" startpage=no style= TLF_CN_9;
		option formchar="|----|+|---+=|-/\<>*" ls=70 ps=70 missing = " " nobyline nocenter nodate nonumber orientation=landscape;
		title; 
		title1 j=l "" j=r "DNDI-Master";
		title2 j=l "" j=r "Page ^{thispage} of ^{lastpage}";
		title3 j=c " ";
		title4 j=c "Patient Profile";
		title5;
		title6 j=l "Subject:&select_subj. 	";

		footnote;
		footnote1 j=l " ";
		footnote2 j=l " ";
		footnote3 j=l " ";
		footnote4 j=c "Patient Profile - MMB Request";
		footnote5 j=l "Program Name: &prname." j=c "Dataset Extraction Date: (&datextrt.)" j=r "Generation Date/Time: %sysfunc(today(), yymmdd10)/&systime.";

		*****	dm report	********;
		proc report data = dmlst.demographics (where=(sub_profile_id="&select_subj.")) split = "|" spacing = 3 missing nowindows headline headskip style(header)={textalign=l} spanrows;
			columns ("Dataset(s) : Demographics, Informedconsentconsenteme_2" sub_profile_id dsstdat version_id icprsubj age sex_decode race);
		
			define sub_profile_id /group left width = 38 "Subject ID";
			define dsstdat /display left width = 40 "Informed Consent Date|/dsstdat";
			define version_id /display left width = 40 "Protocol Version Number|/version_id";
			define icprsubj /display left width = 40 "Previous Subject Number|/icprsubj";
			define age /display left width = 40 "Age|/icprsubj";
			define sex_decode /display left width = 40 "Gender|/sex_decode";
			define race /display left width = 20 "Race|/multi vars";
		run;



	%end;
%mend pp;
*************************************************************************************************************************************************************
*************************************************************************	END OF MACRO *************************************************************
*************************************************************************************************************************************************************;
%pp;

Re: why does my SAS9.4 open excel output everytime I run my program?

SASKiwi — Tue, 03 Nov 2020 23:06:52 GMT

You need to post the SAS log with the SAS option MPRINT so we can see what is going on.

Re: why does my SAS9.4 open excel output everytime I run my program?

ballardw — Tue, 03 Nov 2020 23:54:06 GMT

If you are running the SAS Display Manage (Base or Foundation) the opening of each of these is because the default before have has been set that way.

You can check the menu:

Tools>Options>Preferences, go to the Results tab. If you see a group of options called Result Options and a check mark in the box before "View results as they are generated" that is the setting.

Uncheck the results and the file will quite opening. Until you go back re-check the box.

Re: why does my SAS9.4 open excel output everytime I run my program?

Reeza — Wed, 04 Nov 2020 00:27:07 GMT

It's a setting in SAS. Studio, EG and Base all have settings to stop the opening, usually under preferences somewhere. It's a "show results as generated" option.

topic Re: why does my SAS9.4 open excel output everytime I run my program? in SAS Programming

why does my SAS9.4 open excel output everytime I run my program?

Re: why does my SAS9.4 open excel output everytime I run my program?

Re: why does my SAS9.4 open excel output everytime I run my program?

Re: why does my SAS9.4 open excel output everytime I run my program?