Initialize variables

Hi

The best way (I think) is to use an ARRAY statement.

The issue is how to list the variable names in the ARRAY statement.  If the variables follow a certain numbering format (say VAR1  VAR2  VAR3 ... VAR53) then the statement can be as follows:

ARRAY ArrName (*) VAR1 - VAR53;

If the variable's are in  the correct order in the dataset, then you can use the following code to get a list of variable names into the macro variable &var_names:

proc sql noprint;
  select name into : var_names separated by ' '
   from dictionary.columns where libname = 'WORK' and memname = 'TEST';
%put &var_names;

Note that WORK and TEST must be in CAPITALS.  (TEST is the name of the dataset)


To answer your query, try the following full code:


 

proc sql noprint;
  select name into : var_names separated by ' '
   from dictionary.columns where libname = 'WORK' and memname = 'TEST';

%put &var_names;

DATA Test;
  set test;
    array ArrName (*) &var_names;

IF Certain_variable ~= 0 then do i = 4 to 53;
   ArrName[i] = 0;
end;
RUN;

Select allOpen in new window

Hi,

Tx for your answer but i get the message :
ERROR: All variables in array list must be the same type, i.e., all numeric or character.