topic Re: Can you set a variable's value during multiple sets? in SAS Procedures

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

G_I_Jeff — Tue, 07 May 2013 16:27:50 GMT

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

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

Haikuo — Tue, 07 May 2013 16:33:43 GMT

INDSNAME=

SAS(R) 9.3 Statements: Reference

Haikuo

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

ballardw — Tue, 07 May 2013 22:35:13 GMT

Do you mean:

SET PDBA;

SET PDBB;

SET PDBC;

SET PDBD;

SET PDBE;

SET PDBA

PDBB

PDBC

PDBD

PDBE;

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

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

UrvishShah — Wed, 08 May 2013 06:28:57 GMT

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