topic Re: merge datasets in Statistical Procedures

merge datasets

factorhedge — Sat, 09 Nov 2013 17:51:09 GMT

I have 2 tables/datasets , I would like to merge Table 2 with Table 1 and arrive at the output table which looks like Table 3

Table 1 - time series table with year months from 2002 to 2010 (12 months * 9 years) , each Name1 goes for every month and year

Names1	CompanyName	Code	YearMonth
A	XYZ
A	ABC
A	DEF
B	XYZ
B	EFH
B	JKL
B	DEF

Table 2 (each CompanyName has four occurrences)

Output table - Table 3 (I want all the columns of table 1) + the earnings dates to be populated for corresponding 'Code' variable.

Name1	CompanyName	Yearmonth	EarningsDates
A	xyz	Month1	Jan 2002
A	xyz	Month1	Apr 2002
A	xyz	Month1	July 2002
A	xyz	Month1	Nov 2002

Thanks

Tom — Sat, 09 Nov 2013 23:15:54 GMT

Did you try just doing it? What happened?

pronabesh — Wed, 27 Nov 2013 19:13:57 GMT

This is a one to many merge.

The code is simple;

data table_3

merge table_1 table_2;

by name1 companyname;

run;

Anotherdream — Wed, 27 Nov 2013 19:28:49 GMT

Pronabesh your code has a small error. He does not have name1 in data table_2, so remove that from your merge.

data table_3;

merge table_1 Table_2;

by companyname;

run;

pronabesh — Wed, 27 Nov 2013 19:34:13 GMT

Yes! Did not notice. Thanks for correcting that.