creating multiple records from single record

[prajakta]

I need to create a new record if multiple values are available in id column.

Input:

id	name	city
1	abc	mumbai
2	def/jkl	pune
3	mnop	Delhi

Required Output:

id	name	city
1	abc	mumbai
2	def	pune
2	jkl	pune
3	mnop	Delhi

Thanks..!!

[andreas_lds]

You need:

• if + countw to check if there are multiple values in id
• a loop, with scan to extract the values
• the output-statement create the observations

If you want code, post data in usable form.

[yabwon · Accepted solution]

Hi @prajakta ,

try this:

data have;
  input id	name $	city $;
  cards;
1	abc	Mumbai
2	def/jkl	Pune
3	mnop	Delhi
;
run;

data want (rename=(n=name));
  set have;
  n = name;
  _N_ = countw(n, "/");
  do _N_ = 1 to _N_;
    name = scan(n, _N_, "/");
    output;
  end;
  drop n;
run;
proc print;
run;

All the best

Bart

[prajakta]

Thanks..!! it works for me...