topic Re: Run only when real time gt 0 in SAS Programming

Run only when real time gt 0

Reader587 — Thu, 26 Oct 2023 13:45:40 GMT

Hey all,

Is there a way to make SAS run only when real time is greater than 0?

The reason I am asking is because I wrote a macro and it executes.

For example,

" proc sgplot data=sashelp.cars;
vbar type/dataskin=pressed;
where make="BMW" and cylinders=3;
run; "

won't run because when make=BMW, cylinders is never equal to 3.

I want SAS to execute only when the where clause is true or when real time is greater than 0.

Thank You.

Re: Run only when real time gt 0

Kurt_Bremser — Thu, 26 Oct 2023 13:54:09 GMT

Please define "real time".

Re: Run only when real time gt 0

LinusH — Thu, 26 Oct 2023 14:01:47 GMT

Apart from defining "real time" (like in predicted execution time for the step?), could you describe your requirement, why do you want this logic?
To be able to understand if your where clause will be true for any records you need to look into the data somehow. If you can't execute your SGPLOT, but ok to run a simple data _null_ step with the same where clause, you can test that outcome and then decide to run the next step by using macro logic, or issue an ENDSAS statement if that's more appropriate,

Re: Run only when real time gt 0

Reader587 — Thu, 26 Oct 2023 14:27:55 GMT

Hey Kurt,

NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

You know how there's always a real time and cpu time in the log. I presented an example above.

Thanks.

Re: Run only when real time gt 0

PaigeMiller — Thu, 26 Oct 2023 14:30:35 GMT

I'm misunderstanding something here. What does real-time gt 0 when running PROC CONTENTS have to do with the case where BMWs don't have 3 cylinders?

Re: Run only when real time gt 0

ballardw — Thu, 26 Oct 2023 14:34:04 GMT

Why are you creating a WHERE with invalid data to begin with? That points to a very serious design flaw on your part.

Look at how you generate the where and fix that.

Re: Run only when real time gt 0

Tom — Thu, 26 Oct 2023 15:39:05 GMT

@Reader587 wrote:

Hey Kurt,

NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

You know how there's always a real time and cpu time in the log. I presented an example above.

Thanks.

I don't know of any way to retrieve that information. But if you need to know how long a step takes then you can remember when it starts and then calculate how long it took.

%let startdt = %sysfunc(datetime());
proc contents;
run;
%let duration=%sysevalf(&startdt - %sysfunc(datetime()));

What that has to do with PROC SGPLOT or WHERE statements I have not idea.

Re: Run only when real time gt 0

Astounding — Thu, 26 Oct 2023 16:33:12 GMT

It appears that you are trying to create the plot whenever the WHERE statement actually pulls observations. If so, here's a way to do that:

data _null_;
set sashelp.cars;
where make="BMW" and cylinders=3; 
call execute 
('proc sgplot data=sashelp.cars;
  vbar type/dataskin=pressed;
  where make="BMW" and cylinders=3;
  run;'
);
stop;
run;

There are other mildly similar ways to go about this as well. If any observations meet the WHERE condition, the DATA step generates a PROC SGPLOT. If no observations meet the WHERE condition, the DATA step generates nothing. Either way, the DATA step ends.