topic Re: proc append to merge two macro datasets in SAS Programming

proc append to merge two macro datasets

radha009 — Fri, 07 Sep 2018 16:11:17 GMT

trying two merge two datasets, each dataset has 3 varables. in each dataset 2 variables are same and one is different. giving error as below

proc append base=patch.other_final data=Patch.Other_Infra&i force; run;

NOTE: Appending PATCH.OTHER_INFRA2 to PATCH.OTHER_FINAL.
WARNING: Variable TKT0200342_Oracle_TFT was not found on BASE file. The variable will not be
added to the BASE file.
WARNING: Variable TKT0197527_STTPoint_PTP was not found on DATA file.
NOTE: FORCE is specified, so dropping/truncating will occur.
NOTE: There were 140 observations read from the data set PATCH.OTHER_INFRA2.

Re: proc append to merge two macro datasets

VDD — Fri, 07 Sep 2018 16:28:14 GMT

this should give you what you are asking for.

data want;

set PATCH.OTHER_FINAL(in=ina) PATCH.OTHER_INFRA2(in=inb);

run;

Or you can merge the data.

Append is used to stack tables that are the same.

Re: proc append to merge two macro datasets

Astounding — Fri, 07 Sep 2018 16:30:13 GMT

SAS has many, many ways to combine data sets. PROC APPEND is only one of them. If that's not working (and it won't work if you are trying to add a new variable), give a small example of what you would like the outcome to be. Just show 2 observations for each incoming data set, and what you would like the final data set to look like.

Re: proc append to merge two macro datasets

Reeza — Fri, 07 Sep 2018 16:32:19 GMT

PROC APPEND does not support adding new variables.

Re: proc append to merge two macro datasets

VDD — Fri, 07 Sep 2018 16:42:04 GMT

merge may be what you want to do

proc sort data= a out=asort;
by var1 var2;
run;
proc sort data= b out=bsort;
by var1 var2;
run;
data want;
merge asort(in=ina) bsort(in=inb);
by var1 var2;
run;

if you only want records found in table a you can do this

data want;
merge asort(in=ina) bsort(in=inb);
by var1 var2;

if ina;

run;