DATA Step, Macro, Functions and more

Syntax for 'in' and 'keep' statements

Accepted Solution Solved
Reply
Regular Contributor
Posts: 216
Accepted Solution

Syntax for 'in' and 'keep' statements

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;


Accepted Solutions
Solution
‎04-17-2014 12:38 PM
Super User
Posts: 10,483

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

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

View solution in original post


All Replies
Solution
‎04-17-2014 12:38 PM
Super User
Posts: 10,483

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

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

Regular Contributor
Posts: 216

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

Thanks Ballard. Thats it.

Paul

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 192 views
  • 0 likes
  • 2 in conversation