topic Re: proc append certain fields in SAS Procedures

proc append certain fields

tmm — Tue, 04 Dec 2012 19:38:40 GMT

I have looked and looked and cannot find how to append just certain fields of a table. I normally append by doing this:

proc append data=base_table data=&tbl_nm force;

> run;

But in this case I want to append only 2 fields. The base table had the same fields, label and dataset as the data I am appending.

The base table looks like this:

sys_cd sys_desc amount1 amount2 amount3 amount4

1 jason 1 1 1 1

2 john 2 2 2 2

3 sara 3 3 3 3

the data table looks like this:

sys_cd sys_desc

4 sue

5 michael

6 linda

I just want to append the above to the base but because the base has amount stuff and the other does not it does not work and just does everything when I append as null values even for the sys_cd and sys_desc

Re: proc append certain fields

Linlin — Tue, 04 Dec 2012 19:57:36 GMT

have you tried adding option force?

Re: proc append certain fields

Reeza — Tue, 04 Dec 2012 20:05:17 GMT

Your code is incorrect, it should be

BASE= and DATA=

not two DATA= statements.

proc append base=base_table data=&tbl_nm force;

run;

Re: proc append certain fields

twocanbazza — Tue, 04 Dec 2012 20:07:39 GMT

There is an issue in your append ie have two data's

try

data base;

infile datalines delimiter=',';

input sys_cd sys_desc $ amount1 amount2 amount3 amount4 ;

datalines;

1,jason,1,1,1,1

2,john,2,2,2,2

3,sara,3,3,3,3

;

run;

data data;

infile datalines delimiter=',';

input sys_cd sys_desc $ ;

datalines;

4,sue 5,michael

6,linda

;

run;

proc append base=base data=data force; run;

Re: proc append certain fields

umashankersaini — Sun, 22 Jun 2014 17:12:49 GMT

Hey...

Have you tried after correcting your codes as all suggestion above ?

You may also refer to below one for more info :Why We Use FORCE Option In PROC APPEND To Upload Data To Data Warehouse ~ SAS Certification prep and basic understanding

Regards

Uma Shanker Saini

Re: proc append certain fields

Ksharp — Mon, 23 Jun 2014 12:19:15 GMT

Your can try:

proc append data=base_table(keep=sys_cd sys_desc ) data=&tbl_nm(keep=sys_cd sys_desc ) force;run;

proc sql;

create table want as

select * from base_table

union all corr

select * from &tbl_nm

;

quit;

Xia Keshan

Re: proc append certain fields

RW9 — Mon, 23 Jun 2014 12:45:08 GMT

Another method:

proc sql;

insert into BASE_TABLE (SYS_CD,SYS_DESC)

select *

from DATA_TABLE;

quit;