Syntax for 'in' and 'keep' statements

Paul_NYS — Thu, 17 Apr 2014 16:28:10 GMT

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;

Re: Syntax for 'in' and 'keep' statements

ballardw — Thu, 17 Apr 2014 16:38:22 GMT

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

Re: Syntax for 'in' and 'keep' statements

Paul_NYS — Thu, 17 Apr 2014 16:44:05 GMT

Thanks Ballard. Thats it.

Paul

topic Re: Syntax for 'in' and 'keep' statements in SAS Programming

Syntax for 'in' and 'keep' statements

Re: Syntax for 'in' and 'keep' statements

Re: Syntax for 'in' and 'keep' statements