How to use an array referencing variables for the to and from

[SASMuggleE]

Hi all,

I have a dataset that has a variable "start" and a variable "end" with count data representing an interval. I want to convert that data to be 1 row per count rather than by interval, like this:

Subject  start  end  var

1             1       3       x

1             4       5       y

2             1       5       z

To look like this:

Subject  count  var

1             1        x

1             2        x

1             3        x

1             4        y

1             5        y

2             1        z

2             2        z

...

I dont know how to manipulate the array code to reference these variables instead of doing from i=1 to x. Any help is appreciated. Thank you..

[Qinzhu · Accepted solution]

Is below code what you want? 

data foo;
	input subject start end var $;
datalines;
1 1 3 x
1 4 5 y
2 1 5 z
;

data convert;
	set foo;
	do count=start to end;
		output;
	end;
	drop start end;
run;