topic Re: How to exit if a dataset did not have any records in SAS Programming

How to exit if a dataset did not have any records

SASMom2 — Tue, 21 Apr 2020 23:10:58 GMT

I have a code that creates 3,000 individual excel reports through ODS Tagsets in SAS. Some of them are created even if there is not data in the source dataset. So, when you open the excel report there is no data in it.

I do not want to create the excel report if there is no data in the dataset.

How do I program that?

I tired to copy my table but for some reason I could not do it so I do not have any table to show you.

Thanks in advance.

Re: How to exit if a dataset did not have any records

Tom — Wed, 22 Apr 2020 01:00:03 GMT

Most report steps don't make any output when the input data is empty so seeing HOW you are making the report is important.

I don't think the table (if by table you mean the report you are producing) matters that much. The code is more important. And to understand the code it might help to show some sample of the DATASET(s). To show data just post a simple data step that recreates the data. That way the type/length and any formats attached to the variables are clear. Make sure to use the Insert SAS Code button to get a pop-up window to paste/type/edit your code so that formatting is preserved.

Re: How to exit if a dataset did not have any records

SASMom2 — Wed, 22 Apr 2020 01:53:09 GMT

Tom, thanks for your reply. I was able to resolve it by doing below.

proc sql noprint; select count(*) into :nobs from test where custrun = "&custrun."; quit; %if &nobs = 0 %then %do; %goto exitgoto; %end;