topic creating multiple records from single record in SAS Programming

creating multiple records from single record

prajakta — Fri, 17 Jan 2020 06:12:10 GMT

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..!!

Re: creating multiple records from single record

andreas_lds — Fri, 17 Jan 2020 07:44:41 GMT

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.

Re: creating multiple records from single record

yabwon — Fri, 17 Jan 2020 08:41:02 GMT

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

Re: creating multiple records from single record

prajakta — Fri, 17 Jan 2020 09:43:24 GMT

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