Error when merging data sets

[Paul_NYS]

Hi

When I run the below data step to merge two data sets, I am getting the below errors for missing columns. However, both columns exist on both data sets. Is there something syntax-wise wrong? I have also sorted both data sets prior to running the merge.

Paul

ERROR: BY variable cnty_name is not on input data set WORK.S1AGESHORTYEARFREQSORT.

ERROR: BY variable startyear is not on input data set WORK.S1AGESHORTYEARFREQSORT.

data s1ageyear1;

merge work.s1ageshortyearfreqsort (keep=count rename=(count=cohortyearcount)) work.s1ageshorttestsort;

by cnty_name startyear;

run;

[SteveDenham · Accepted solution]

I am sure you will get better answers than this, but I think that keep=count statement has the result of only the variable 'count' being available for the merge.

Steve Denham

[art297]

: I don't think he'll get a better answer than the one you provided!

[Paul_NYS]

That was it, thanks.

Paul