DATA Step, Macro, Functions and more

use proc sql to merge two subset in specific criteria

Reply
Occasional Contributor
Posts: 7

use proc sql to merge two subset in specific criteria

for example:

Dataset a:

month

1

2

3

4

...

12

dataset b:

col1-col300

then I would like to merge these to as :

if month=1, merge col1-10 in b with a(month=1)

if month=2. merge col2-11 in b with b(month=2)

....

Thank you!

Super User
Super User
Posts: 7,417

Re: use proc sql to merge two subset in specific criteria

What do you want the output to look like?  Also is it really any saving, just merge the two tables.  I.e.

proc transpose data=datasetb out=t_datasetb;

     var col1-col300;

...

proc sql;

     create table WANT as

     select     A.*,

                    B.VAL

     from       DATASET A

     left join  T_DATASETB B

     on          A.MONTH <= B.COL <= (A.MONTH + 9);

quit;

Then you can always transpose up.  Note that I guessed as the variable names as you haven't provided any test data in a datastep format, I have only written the code from memory.

Ask a Question
Discussion stats
  • 1 reply
  • 231 views
  • 0 likes
  • 2 in conversation