topic Re: Resolving 2 consecutive macro variables with a space in SAS Programming

Resolving 2 consecutive macro variables with a space

NJGIRL — Thu, 29 Jun 2017 20:05:03 GMT

Dear all,

here is an example:

%let client = ABC PHARM;

%let study = 123;

title1 "&client &study" ;

proc print;

run;

how do I get a space between client and study in the title? thanks so much!

Re: Resolving 2 consecutive macro variables with a space

mkeintz — Thu, 29 Jun 2017 20:10:17 GMT

I ran this version of your program and got the result you want:

%let client = ABC PHARM;
%let study = 123;

title1 "&client &study" ;
proc print data=sashelp.class (obs=1);
run;

producing ...

                                                     ABC PHARM 123                         09:41 Thursday, June 29, 2017   3

                                        Obs     Name     Sex    Age    Height    Weight

                                          1    Alfred     M      14      69       112.5

Do you not get the same results?

Re: Resolving 2 consecutive macro variables with a space

NJGIRL — Thu, 29 Jun 2017 20:32:49 GMT

Hi thanks --

I am not getting a space between 'Pharm' and '123'

Thanks 🙂

Re: Resolving 2 consecutive macro variables with a space

ballardw — Thu, 29 Jun 2017 20:57:11 GMT

@jill1 wrote:
Hi thanks --

I am not getting a space between 'Pharm' and '123'

Thanks 🙂

I agree with @mkeintz, I get a space in the title.

You may have to show the log including and ODS destination and options. If so please post the log in a code box opened using the forum {i} menu icon to prevent the message window from reformatting text.

Re: Resolving 2 consecutive macro variables with a space

Quentin — Thu, 29 Jun 2017 21:19:35 GMT

I can't imagine how it could be that you don't get a space.

Just for curiosity, and to remove ODS from the process, what to you get from:

%let client = ABC PHARM;
%let study = 123;
title1 "&client &study" ;

proc sql;
  create table mytitle as 
  select text 
  from dictionary.titles;
quit;


data _null_;
  set mytitle;
  if text="ABC PHARM 123" then do;
    put "Confirmed: title has a space! " text=;
  end;
  else do;
    put "ERROR: No space! " text=;
  end;
run;

In the log, I get:

Confirmed: title has a space! text=ABC PHARM 123