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
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.
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.