topic creating array for each row based on a count in SAS Procedures

creating array for each row based on a count

Filipvdr — Thu, 28 Jul 2011 10:43:50 GMT

options symbolgen mlogic mprint;

data &InputParam/*(keep = Info Wafers_1 CO1-CO10)*/;

format Info Wafers_1 CO1-CO10;

set Recipe_transp;

Nr = countc(COL1,'+');

CALL SYMPUT('Nummer', Nr);

array CO{10} $50.;

do L = 1 to Nr;

CO{L} = scan(COL1,L,'+');

end;

Info = "&InputParam";

run;

what i want to do is replace the CO{10} by CO{Nr} but i dont know how?

creating array for each row based on a count

art297 — Thu, 28 Jul 2011 12:59:08 GMT

Not quite sure what you are trying to do. Does it approximately something like the following?:

data have;

informat COL1 $30.;

input COL1;

cards;

+3+4+5

+1+2+3+4+5

;

proc sql noprint;

select max(countc(COL1,'+')) into : nummer

from have;

quit;

data want;

set have;

array CO{&nummer.} $50.;

L=1;

do while (scan(COL1,L,'+') ne "");

CO{L} = scan(COL1,L,'+');

L+1;

end;

run;

creating array for each row based on a count

Filipvdr — Thu, 28 Jul 2011 13:08:02 GMT

well i gues it solves my problem, as i want to make sure of the exact number of CO (columns). But after all it is a dataset so the maximum is OK for this.

But is there a way to make a different Nummer for each single row in my dataset because now i always count to the max

creating array for each row based on a count

art297 — Thu, 28 Jul 2011 13:13:14 GMT

As long as you initially set the array high enough to capture all values, there are numerous ways to limit the number of iterations.

For example, the method I used, the method you originall used, a slight variant of that method:

do l=1 to countc(COL1,'+');

and many others.

Two things to note: the array dimensions are set just once and you can't access a macro variable you create from within the datastep it is created.

creating array for each row based on a count

Ksharp — Wed, 03 Aug 2011 05:21:01 GMT

Just write as

array CO{nr} $50.;

cann't it work?

or use a data _null_ before your data step to make a macro variable "call symputx(....)",

then use this macro variable to instead of 10.

Ksharp