Can you set a variable's value during multiple sets?

[G_I_Jeff]

Creating 1 pdb from multiple:

DATA  PDB1;

SET PDBA

SET PDBB

SET PDBC

SET PDBD

SET PDBE;

Is there a way to create and set a single variable with a value to distinguish each SET pdb?

PDB=A for all observations from PDBA, so on and so on.....

Jeff

[Haikuo]

INDSNAME=

SAS(R) 9.3 Statements: Reference

Haikuo

[ballardw]

Do you mean:

SET PDBA;

SET PDBB;

SET PDBC;

SET PDBD;

SET PDBE;

or

SET PDBA

      PDBB

      PDBC

      PDBD

      PDBE;

As written I would expect error messages about not finding the dataset SET.

[UrvishShah]

Hi,

If you are going to append the data by using single SET statement, than you can use IN = option to identify the observations...But make sure that you are appending not one - to - one reading by using multiple SET statemsnts...

data test;

   set pdbA(in = a)

        pdbB(in = b)

        pdbC(in = c)

        .....and so on;

    if a then pdb = "A";

    if b then pdb = "B";

    if c then pdb = "C";

    .....and so on;

run;

Make sure you are going to append the datasets rather than one to one reading (Merging)...

-Urvish