topic Re: How do I code this array in SAS Programming

How do I code this array

SASMuggleE — Mon, 15 May 2023 22:37:30 GMT

I have some data the looks like this

Subject Start End Var1 V2

1 1 4 xx yy

1 5 6 xx zz

2 1 3 yy ww

...

I want it to look like this:

Subject Time Var1 V2

1 1 xx yy

1 2 xx yy

1 3 xx yy

1 4 xx yy

1 5 xx zz

1 6 xx zz

2 1 yy ww

2 2 yy ww

2 3 yy ww

...

What would my program array look like?

Re: How do I code this array

GeorgeBonanza — Tue, 16 May 2023 19:29:44 GMT

I think this should work.

data HAVE;
	input SUBJECT $ START END VAR1 $ VAR2 $;
	datalines;
1 1 4 xx yy
1 5 6 xx zz
2 1 3 yy ww
;
run;

data WANT (drop= START END);
	retain SUBJECT TIME VAR1 VAR2;
	set HAVE;
	do TIME = START to END;
		output;
	end;
run;

Re: How do I code this array

Reeza — Tue, 16 May 2023 19:34:37 GMT

This wouldn't require an array. SAS data steps loop automatically so no need to control that. You need to output multiple records per line so create a loop and use an explicit OUTPUT statement to print that line out once for each time.

In SAS arrays are used for working with multiple variables with the data on a single row, though you can across rows it's a bit more complex. It is not used to represent columns however.

Here's a tutorial on using Arrays in SAS
https://stats.idre.ucla.edu/sas/seminars/sas-arrays/