Author: kuekawa

I want to keep variables when they start from SUM_*.  Could you advise?

You can use the colon modifier to do this.  I have include sample code below.

data sums;

set these2;

keep subgroup

sum_:;

run;

data indiv4;
set indiv3;
if N_entry > 9;
run;
proc sort;by subgroup;
run;

data indiv5;
retain sequence;
set indiv4;
by subgroup;
if first.subgroup then sequence=0;
sequence=sequence+1;
run;

http://www.albany.edu/~msz03/epi514/notes/first_last.pdf

 

data indiv4;
set indiv3;
if N_entry > 9;
run;
proc sort;by subgroup;
run;

data indiv5;
set indiv4;
by subgroup;

first_id=first.subgroup;
last_id=last.subgroup;

run;

when a SAS syntax generates errors involving macro's, SAS stops doing anything even if you submit a new command.  You can submit the following to clean-quit without shutting down SAS.

;*%mend;*);*';*";**/;