topic Re: How to exit if values in one variable is empty. in SAS Programming

How to exit if values in one variable is empty.

SASMom2 — Sun, 08 Dec 2019 18:49:27 GMT

I have a dataset that has two variables. The first columns has string variable called savings and another column has dollar amount of savings. There are three types of savings. So, basically, there are three rows and two columns. I use this table to create an excel file using ODS tagset.

I do not want to create an excel file if there was no dollar amount in ALL three savings I second column.

Savings	Saving_Amount
ABC
DEF
GHI

How do I program this?

Thanks for your help.

Re: How to exit if values in one variable is empty.

novinosrin — Sun, 08 Dec 2019 19:03:55 GMT

Hi @SASMom2 You could use a conditional macro IF THEN statement

proc sql noprint;
select nmiss(Saving_Amount) ne count(*) into :check trimmed
from have;
quit;

%put &=check;

%if  &check %then %put creat excel file;

I hope you get the idea

Re: How to exit if values in one variable is empty.

ed_sas_member — Sun, 08 Dec 2019 19:06:01 GMT

Hi @SASMom2

You can use a macro to run your code conditionally:

data mydata;
	input Savings $	Saving_Amount;
	cards;
ABC .
DEF .
GHI .
;
run;


%macro _savings ();
	proc sql noprint;
		select count(*) into:mis_amount from mydata where Saving_Amount=.;
	quit;
	%if &mis_amount = 3 %then %do;
		proc print;/*<ODS TAGSETS statement>*/
	%end;
%mend;

%_savings

Re: How to exit if values in one variable is empty.

SASMom2 — Sun, 08 Dec 2019 20:04:18 GMT

Thank you for your reply. I think I am almost there except I want to say below.

%macro _savings ();
proc sql noprint;
select count(*) into:mis_amount from mydata where Saving_Amount=.;
quit;
%if &mis_amount = 0 %then %do;

got to the end of the code and exit.

%end;
%mend;
%_savings

Re: How to exit if values in one variable is empty.

SASMom2 — Sun, 08 Dec 2019 23:08:38 GMT

thank you both for your reply. It worked!

Re: How to exit if values in one variable is empty.

s_lassen — Mon, 09 Dec 2019 10:04:15 GMT

Another possibility is to skip the macro stuff, and write to a temporary file instead:

filename tempsas temp;
set have;
  where saving_amount is not null;
  file tempsas:
  put 'Proc Print data=have;run;';
  stop;
run;

%include tempsas;

That way, if there are no non-missing values, nothing will be written to your temporary SAS file, and nothing will be executed with the %INCLUDE statement.