Hi I have a data like this                            var1                                         var2 Room 192 - Seats 10 #                       5643 Room 307 - Seats 8                              768 Room 407 - Seats 8 ♿                         4324 Room 307 - Seats 8 §                          5612 Room number 192 - Seats 103 ♿        2111   And I need to make an Indicator variable Like        Disabled = 1 if there is "♿" in Data        Disabled = 0 If not   My Code   data work.&&outSRB&i.; length Var1 $35 Var2 5 set work.&&midSRB&i.;     if (scan(Var1, -1, ' ') = unicode("\u267f", "utf8") then Disabled=1;     else Disabled=0; run;   When I am running this it is showing   Disabled 0 0 0 0 0   Please I need your expert suggestions.   ... View more

Hi,   I was trying to write some macro in sas. However, it is not working. Here is the code.   * %macro product(num, v1, v2, v3, v4, v5, v6, v7, v8);        %macro product(num, variable1-variable&n);        %let produc = 0;        %let variable = 'var';          %do j = 1 %to #               %let k=j;                &produc = &produc + j * v&k;          %end; %mend product;   %let n = 8; %let prod = 162; data zeo_corr.perm&n (keep= var1 - var&n produc) length default = 3; array a{&n} var1-var&n; do j = 1 to 10000;         do i = 1 to &n;                  a[i]=j;         end;     %product(&n, var1- var&n);    * %product(&n, var1, var2, var3, var4, var5, var6, var7, var8);     if produc = &prod then output; end; run;   it is showing the following error NOTE: Line generated by the macro variable "PRODUC". 1             0               -               180   ERROR 180-322: Statement is not valid or it is used out of proper order.   or   ERROR: More positional parameters found than defined.   Where is the problem? Please suggest me the possible solution. ... View more