DATA Step, Macro, Functions and more

MACROS

Accepted Solution Solved
Reply
Contributor
Posts: 70
Accepted Solution

MACROS

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


Accepted Solutions
Solution
‎03-15-2012 08:56 AM
Super Contributor
Posts: 1,636

MACROS

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;

View solution in original post


All Replies
Solution
‎03-15-2012 08:56 AM
Super Contributor
Posts: 1,636

MACROS

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;

Contributor
Posts: 70

MACROS

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

PROC Star
Posts: 7,492

MACROS

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

As for the explanation you asked for, the scan function is described at: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm

and call symputx is described at: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002295697.htm

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 150 views
  • 0 likes
  • 3 in conversation