That is an example of my data (as I posted before, there is a total of 100 ops_ko-columns) What I need is to add another variable that has the value 1 if in any of the ops_ko in a row has a certain value. For example if that value was 0107 then the newly added variable would be 1 for the first, second and fifth data row, if it was 9260 it would only be 1 for the second. typ_alter typ_geb aufn_anl aufn_grd ops_ko1 ops_ko2 ops_ko3 ops_ko4 ops_ko5 ops_ko6 ops_ko7 18 2 N 0107 96030 80103 19 2 G 0107 9260 8800c0 10 2 E 0101 12750 14 2 E 0101 57583 17 2 N 0107 3222 1632 21 1 N 0501 87161 ... View more

I'll try 🙂 The part of the macro that uses proc iml and where it stops is: proc iml;     call symput('anzahl_eintraege',left(char(nrow({&liste})))); quit; %let anzahl_eintraege= %eval(&anzahl_eintraege*1); proc iml;     a = t(1:&anzahl_eintraege);     b = {&liste};     c = length(b);     create listfile var{a b c};     append;     close listfile; quit; I have a dataset with a variable "ops_ko" for which I have 100 columns, "ops_ko1", "ops_ko2" and so on to "ops_ko100". If any single one of these columns within a row contains a certain value, I want a (newly added) dummy variable to say 1, else 0. The macro is supposed to do that, except that my SAS does not seem to work with proc iml so it is not beeing executed 😞 Does that make it better...? ... View more