delete multiple observations

shivamarrora0 — Tue, 20 Jun 2017 12:17:50 GMT

dataset

id include exclude

a . abc

a . xyz

b j abf

b . gtj

output required

a . abc,xyz

b j abf,gtj

Re: delete multiple observations

RW9 — Tue, 20 Jun 2017 12:56:29 GMT

Its a good idea to foloow the guidance given by the Post button. Clarify the test data and the output by describing the relation between them. At a guess, I would say include is a list of inclusions separated by ", " and exclude is a the same. So you want one id and two lists yes? If so then (note how I put the test data in a datastep):

data have; 
  infile datalines dlm="," dsd;
  input id $ include $ exclude $;
datalines;
a,,abc
a,,xyz
b,j,abf
b,,gtj
;
run;

data want (drop=include exclude);
  set have;
  length inc exc $200;
  retain inc exc;
  by id;
  if first.id then call missing(inc,exc);
  inc=ifc(include ne "",catx(',',inc,include),inc);
  exc=ifc(exclude ne "",catx(',',exc,exclude),exc);
  if last.id then output;
run;

topic delete multiple observations in SAS Programming

delete multiple observations

Re: delete multiple observations