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

SASMuggleE — Mon, 15 May 2023 23:29:02 GMT

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

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

Qinzhu — Tue, 16 May 2023 00:24:27 GMT

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;

topic Re: How to use an array referencing variables for the to and from in SAS Procedures

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

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