topic Re: Problem with array dimension when is a macro variable in SAS Programming

Problem with array dimension when is a macro variable

rodbriv — Thu, 22 Dec 2022 08:19:28 GMT

Hi, i have a problem with the dimension definiton of an array. My code works good in SAS Guide, but in the bash does't works.

The macro variables nvars and obs are definited as:

data _null_;

set sashelp.vtable (where= (memname='ABT_DUMMY'));

call symput('nvars', nvar-1);

call symput('obs', nobs);

run;

I wish to put the macros in array dimension:

data bt_lambda (keep= var dot);

array xx[&nvars.] x_1-x_&nvars.;

array xd[&obs., &nvars.] _temporary_;

run;

But return the errors:

The code works if i defined the macros as:

%let nvars=23;

%let obs=84000;

But i need the dynamical dimension. Someone can tell me a solution?

Re: Problem with array dimension when is a macro variable

andreas_lds — Thu, 22 Dec 2022 08:37:56 GMT

The log shows that "nvars" is -1 not 23. Using call symputx is recommended, so that blanks are automatically stripped from the macro-variable.

Re: Problem with array dimension when is a macro variable

Kurt_Bremser — Thu, 22 Dec 2022 08:43:33 GMT

First of all, use CALL SYMPUTX instead of CALL SYMPUT. SYMPUTX strips leading and trailing blanks.

It looks as if your dataset does not contain any variables (resulting in nvars being -1, which is an invalid dimension for the array).

Re: Problem with array dimension when is a macro variable

rodbriv — Thu, 22 Dec 2022 09:03:32 GMT

Yea, i got a problem with teh data step of definition.
With a proc sql
proc sql; select cats(nvar) into :nvars from sashelp.vtable where memname=’ABT_DUMMY’;
proc sql; select cats(nobs) into :obs from sashelp.vtable where memname=’ABT_DUMMY’;
Works well, the problem was the symput and the blanks. Thanks.

Re: Problem with array dimension when is a macro variable

rodbriv — Thu, 22 Dec 2022 09:03:41 GMT