macro text manipulation

[l***@gmail.com]

I have a macro variable

%macro snap(yyyymm);
data temp;
set temp;
mm=substr(&yyyymm,5,2);
yyyy=substr(&yyyymm,1,4);
run;
%mend;

The macro fails since there is no yyyymm column in temp.
How to correct the macro?
Thanks in advance.

[Kenneth M. Lin]

Aren't you supposed to pass the correct column name?

wrote in message news:c59f64de-6ca0-4085-a6d6-***@googlegroups.com...

I have a macro variable

%macro snap(yyyymm);
data temp;
set temp;
mm=substr(&yyyymm,5,2);
yyyy=substr(&yyyymm,1,4);
run;
%mend;

The macro fails since there is no yyyymm column in temp.
How to correct the macro?
Thanks in advance.