Solved: Using macro variable in %Let - SAS Support Communities

🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

Pyrite | Level 9

Pyrite | Level 9

Using macro variable in %Let

Posted 11-01-2016 02:59 PM (8204 views)

Why doesn't this work ? It assigns the path with &diag as the string value and not the value of &diag. Is there a work-around ?

%Let diag=ovarian ;
%Let path=Z:\Analysis\&diag ;

1 ACCEPTED SOLUTION

Accepted Solutions

Meteorite | Level 14

Meteorite | Level 14

Re: Using macro variable in %Let

Posted 11-01-2016 03:30 PM (8874 views) | In reply to CP2

%Let diag=ovarian ;

%Let path=%str(Z:\Analysis\&diag) ;

FYI

http://www2.sas.com/proceedings/forum2007/152-2007.pdf

Thanks,
Suryakiran

View solution in original post

4 REPLIES 4

Meteorite | Level 14

Meteorite | Level 14

Re: Using macro variable in %Let

Posted 11-01-2016 03:30 PM (8875 views) | In reply to CP2

%Let diag=ovarian ;

%Let path=%str(Z:\Analysis\&diag) ;

FYI

http://www2.sas.com/proceedings/forum2007/152-2007.pdf

Thanks,
Suryakiran

PROC Star

Re: Using macro variable in %Let

Posted 11-01-2016 03:33 PM (8193 views) | In reply to CP2

Works fine for me:

23 %Let diag=ovarian ;
24 %Let path=Z:\Analysis\&diag ;
25
26 %put &path;
Z:\Analysis\ovarian

Please post your log.

Barite | Level 11

Barite | Level 11

Re: Using macro variable in %Let

Posted 11-01-2016 03:35 PM (8189 views) | In reply to CP2

Works for me:

Meteorite | Level 14

Meteorite | Level 14

Re: Using macro variable in %Let

Posted 11-01-2016 03:36 PM (8188 views) | In reply to CP2

Make sure you run %Let diag=ovarian ;

If you run only %Let path=Z:\Analysis\&diag ;
it will not resolve the macro variable.

Thanks,
Suryakiran