Syntax for 'in' and 'keep' statements

[Paul_NYS]

Hi

I have tried every variation that I can think of for a combined 'keep' and 'in' statements (below in bold) for one data set in a merge function and can't seem to get it to run. Anyone done this prior?

Paul

data courtevents1ee (rename=judge_entity_id=agecat4);

length judge_entity_id 8;

merge s1 (keep=start stop exit entity_id durat gender spellage docket1 (in=a)) courtevents (keep=entity_id edate judge_entity_id judge_type ucms_table);

by entity_id;

if a;

format start mmddyy10.;

format edate mmddyy10.;

format stop mmddyy10.;

if edate ge start;

if edate le stop;

if ucms_table="APPEARANCE";

/*if exit ne "ZTC" then do;

if edate le stop;

end;

*/

if not missing(judge_entity_id);

count=1;

drop agecat4 ucms_table;

run;

[ballardw · Accepted solution]

The IN=A doesn't want the () around it.

[Paul_NYS]

Thanks Ballard. Thats it.

Paul