topic Re: Possible to conditionally add variable based on obs from different datasets in set statement? in SAS Programming

Possible to conditionally add variable based on obs from different datasets in set statement?

Kristiaan — Thu, 18 Aug 2016 07:32:07 GMT

Hi there,

I havn't been able to google/find this issue, therefore this post.

data want;
set have1 have2 have3;
length Source $5;

where something = &a_variable.;

if [observations are from have1] then Source="have1";
if [observations are from have2] then Source="have2";
if [observations are from have3] then Source="have3";

run;

Is something like this possible? In the log it always shows how many observations SAS is able to find from the different datasets put in the set statement.

NOTE: There were 27834 observations read from the data set WORK.HAVE1.
NOTE: There were 0 observations read from the data set WORK.HAVE2.
NOTE: There were 22808 observations read from the data set WORK.HAVE3.

Is it also possible to conditionally do something based on those observations? Like add a variable with the source of the obs? I am running SAS 9.4.

Re: Possible to conditionally add variable based on obs from different datasets in set statement?

Kurt_Bremser — Thu, 18 Aug 2016 07:35:37 GMT

data want;
set
  have1 (in=have1)
  have2 (in=have2)
  have3 (in=have3)
;
length Source $5;
where something = &a_variable.;
if have1 then Source="have1";
if have2 then Source="have2";
if have3 then Source="have3";
run;

Re: Possible to conditionally add variable based on obs from different datasets in set statement?

Reeza — Thu, 18 Aug 2016 07:35:44 GMT

INDSNAME option on the SET statement.

See example 12 in the documentation, which is exactly your question.

http://support.sas.com/documentation/cdl/en/lestmtsref/68024/HTML/default/viewer.htm#p00hxg3x8lwivcn1f0e9axziw57y.htm

Re: Possible to conditionally add variable based on obs from different datasets in set statement?

Kristiaan — Thu, 18 Aug 2016 07:53:11 GMT

Both options work perfectly, thanks for the quick reply!