topic Append one record from a dataset to all records in another dataset in SAS Data Science

Append one record from a dataset to all records in another dataset

bharath86 — Mon, 18 Oct 2021 09:10:20 GMT

Hi,

I want to append one record from dataset A to all records in dataset B.

Dataset A doesnt have an id column but this should be appended to all records in B dataset.

There may be multiple records in dataset B for each ID.

Dataset-A

bb	cc
Test record	Test record

Dataset-B

id	bb	cc
1	fadfafa	adafa
2	adfa	adafa
3	rtwt	kghj
4	ghjkgdgh	luy
5	fgs	gsyhs

Output dataset should look like this.

id	bb	cc
1	fadfafa	adafa
1	Test record	Test record
2	adfa	adafa
2	Test record	Test record
3	rtwt	kghj
3	Test record	Test record
4	ghjkgdgh	luy
4	Test record	Test record
5	fgs	gsyhs
5	Test record	Test record

Re: Append one record from a dataset to all records in another dataset

Ksharp — Mon, 18 Oct 2021 12:31:13 GMT

data A;
input bb $ cc $;
cards;
test test
;
run;
data B;
infile cards expandtabs truncover;
input id bb $ cc $;
cards;
1	fadfafa	adafa
2	adfa	adafa
3	rtwt	kghj
4	ghjkgdgh	luy
5	fgs	gsyhs
;
run;

data temp;
 set B(keep=id);
 if _n_=1 then set A;
run;
data want;
 set B temp;
 by id;
run;

Re: Append one record from a dataset to all records in another dataset

Astounding — Mon, 18 Oct 2021 13:16:57 GMT

A one-step approach:

data want;
   retain recno 1;
   drop recno;
   set b;
   output;
   set a point=recno;
   output;
run;