topic Re: How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 o in SAS Programming

How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 obs?

Hello_there — Fri, 04 Feb 2022 20:13:43 GMT

For example, if we use the following data sets:

data practice;
      input name $ fav_color $ no.;
datalines;
mark blue 3
lisa red 9
laquisha orange 2
shauna blue 8
ray purple 1
;
run;

data practice1;
   set practice;

if fav_color="pink";
run;

data _empty;
infile datalines dsd dlm ",";
  input name $ fav_color $ no.;
datalines;
 , There is no one with this fav_color,
;
run;

Since i try to return back a data set with people who only liked "pink", and no one existed in the data set, there are 0 observations.

How do i have it so that i could use either some kind of code with complicated logic or a macro to be able to return that says effectively that

if this dataset has 0 observations, please return back the work._empty data set?

Thanks

Re: How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 o

Reeza — Fri, 04 Feb 2022 20:16:30 GMT

Example 13: Print Information to the Output Window If a Data Set Is Empty

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p011imau3tm4jen1us2a45cyenz9.htm

@Hello_there wrote:

For example, if we use the following data sets:
data practice;
      input name $ fav_color $ no.;
datalines;
mark blue 3
lisa red 9
laquisha orange 2
shauna blue 8
ray purple 1
;
run;

data practice1;
   set practice;

if fav_color="pink";
run;

data _empty;
infile datalines dsd dlm ",";
  input name $ fav_color $ no.;
datalines;
 , There is no one with this fav_color,
;
run;
Since i try to return back a data set with people who only liked "pink", and no one existed in the data set, there are 0 observations.

How do i have it so that i could use either some kind of code with complicated logic or a macro to be able to return that says effectively that

if this dataset has 0 observations, please return back the work._empty data set?

Thanks

Re: How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 o

s_lassen — Mon, 07 Feb 2022 11:19:21 GMT

That's not so hard:

data want;                   
  if nobs=0 then set _empty; 
  set practice1 nobs=nobs;   
run;

It looks kind of strange, as the NOBS variable is referred before the PRACTICE1 dataset is read, but it works (NOBS is set at compile time). If you swap the two statements, it will not work, because the datastep then terminates at SET PRACTICE1.

Re: How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 o

Hello_there — Mon, 07 Feb 2022 13:38:12 GMT

data practice;
      input name $ fav_color $ no;
datalines;
mark blue 3
lisa red 9
laquisha orange 2
shauna blue 8
ray purple 1
;
run;

data practice1;
   set practice;

if fav_color="pink";
run;

data _empty;
retain name fav_color no1;
length name $50 fav_color $50;

infile datalines dsd dlm=",";

no1=put(no, best.);

if no1 eq . then no1= " ";

drop no;

rename no1=no;

  input name $ fav_color $ no;
datalines;
 , There is no one with this fav_color,
;
run;


/****solution*****/

data want;                   
  if nobs=0 then set _empty; 
  set practice1 nobs=nobs;   
run;

Thanks for replying!

Unfortunately it did not work for me.

In this example, practice1 has 0 obs, and I'm looking for the logic that says return back work._empty bc practice 1 had 0 obs.

When I ran your code, it returned back an empty data set.

Re: How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 o

Tom — Mon, 07 Feb 2022 14:40:43 GMT

@s_lassen wrote:

That's not so hard:
data want;                   
  if nobs=0 then set _empty; 
  set practice1 nobs=nobs;   
run;
It looks kind of strange, as the NOBS variable is referred before the PRACTICE1 dataset is read, but it works (NOBS is set at compile time). If you swap the two statements, it will not work, because the datastep then terminates at SET PRACTICE1.

That won't work. When PRACTICE1 is empty the first iteration will still read past the end of PRACTICE1 so no observations will be written.

Perhaps you meant to include an ELSE?

data want;                   
  if nobs=0 then set _empty; 
  else set practice1 nobs=nobs;   
run;

Re: How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 o

Hello_there — Mon, 07 Feb 2022 15:22:16 GMT

Thanks this worked!

Re: How to write the logic or a macro to output a dataset on the condition that 1st data set has 0 o

Hello_there — Mon, 07 Feb 2022 15:24:07 GMT

Thanks, s_lassen, for your help! I got it working because of your code.