topic Re: Create Combined data set with variable based on original table in SAS Programming

Create Combined data set with variable based on original table

jmmedina252 — Wed, 26 Apr 2023 19:12:52 GMT

Hello, I need to combine about ten tables all with different names (example: work.weight, work.diagnosis, work.dose) into one table with a variable that specifies their original table name.

Re: Create Combined data set with variable based on original table

PaigeMiller — Wed, 26 Apr 2023 19:16:41 GMT

@jmmedina252 wrote:

Hello, I need to combine about ten tables all with different names (example: work.weight, work.diagnosis, work.dose) into one table with a variable that specifies their original table name.

Could you define "combine"?? Do you want these tables to be combined horizontally, side by side? Or do you want these tables to be combined vertically, one on top of another? Or do you want something else?

Re: Create Combined data set with variable based on original table

Reeza — Wed, 26 Apr 2023 19:19:32 GMT

Are you stacking the data or merging the data (adding variables)?

data want;
set weight diagnosis dose indsname=src;
source = src;
run;

Merge (one option)

data want;
merge weight (in=t1) diagnosis (in=t2) dose (in=t3);
by subjid;
src=catx('|', t1, t2, t3);
run;

You likely need to provide more details to get an answer that's more specific to what you need.

Re: Create Combined data set with variable based on original table

jmmedina252 — Wed, 26 Apr 2023 19:25:24 GMT

stacked

Re: Create Combined data set with variable based on original table

jmmedina252 — Wed, 26 Apr 2023 19:25:49 GMT

I would want to stack the data sets

Re: Create Combined data set with variable based on original table

Reeza — Wed, 26 Apr 2023 19:32:52 GMT

Then try the first set of code I included.

Re: Create Combined data set with variable based on original table

jmmedina252 — Wed, 26 Apr 2023 19:38:11 GMT

is there anyway to exclude the libname without saving the data sets to work? instead of source=data.dose I would want source=dose

Re: Create Combined data set with variable based on original table

Reeza — Wed, 26 Apr 2023 19:43:25 GMT

Use SCAN() to parse just the second portion.

source =scan(src, 2, ".");