topic MACROS in SAS Programming

MACROS

rawindar — Thu, 15 Mar 2012 07:09:54 GMT

I have an dataset variable x=p.q,r

these three letters seperated with a single comma.Now my requirement is i need to assign these values to macro variable.

There are three macro variables m1,m2,m3

i need output like m1=p

m2=q

m3=r

Can anybody give a solution and explanation.Thnk.............u

Linlin — Thu, 15 Mar 2012 12:56:41 GMT

data _null_;

x='p,q,r';

call symputx('m1',scan(x,1));

call symputx('m2',scan(x,2));

call symputx('m3',scan(x,3));

run;

%put &m1 &m2 &m3;

art297 — Thu, 15 Mar 2012 15:28:22 GMT

FWIW: Linlin's suggested code will also work with your example input, i.e.: p.q,r

rawindar — Fri, 16 Mar 2012 07:40:02 GMT

thanks .... Linlin.You gave me a code in easy pattern.