use proc sql to merge two subset in specific criteria

Seashore — Thu, 02 Jul 2015 15:04:10 GMT

for example:

Dataset a:

month

...

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!

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

RW9 — Thu, 02 Jul 2015 15:56:17 GMT

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.

topic use proc sql to merge two subset in specific criteria in SAS Programming

use proc sql to merge two subset in specific criteria

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