topic Re: concatinating macro variable in SAS Programming

concatinating macro variable

sourabhy — Sun, 24 Jun 2018 07:25:38 GMT

i have two macro vatiable as below
%let path='c:/users/sourabh/'
%let file='online.csv'
i need
'c:/users/sourabh/online.csv'
kindly suggest how can i achieve dat

Re: concatinating macro variable

Kurt_Bremser — Sun, 24 Jun 2018 07:41:06 GMT

Start by not putting quotes into macro variables, and it is very easy:

%let path=c:/users/sourabh/;
%let file=online.csv;

%let want=&path.&file.;

Only use (double) quotes where you use the macro variable, eg in a filename statement.

Re: concatinating macro variable

Ksharp — Sun, 24 Jun 2018 11:00:33 GMT

%let path='c:/users/sourabh/' ;
%let file='online.csv' ;

%let want=%str(%')%sysfunc(dequote(&path))%sysfunc(dequote(&file))%str(%');

%put &want ;