topic Re: Concatenate multiple Variables in SAS Programming

Concatenate multiple Variables

sanjay1 — Fri, 02 Nov 2018 14:35:33 GMT

Hi Experts,

I am tryng to create a link variable by concotinating certain variables. But I am getting blank data.
Please suggest.

Below is my data.

Data test;
input number subject$ status$ EMAIL_$ 10.;
datalines;
123 abc yes khgkjh@123
246 bcv no jhhgjh@234
run;

/*What I am trying*/
data test1;
set test;
link = "https://Company.abc.def.com/ghi/form/fghfjghkkkkl="||strip(number)||
%nrstr("&Q_subject=")||strip(subject)||%nrstr("&status=")||strip(yes)||%nrstr("&EMAIL_ADDRESS_=")||strip(EMAIL_);
run;

Desired output
https://Company.abc.def.com/ghi/form/fghfjghkkkkl=123&Q_subject=abc&status=yes&EMAIL_ADDRESS_=khgkjh@123

Thanks,

Sanjay

Concatination

sanjay1 — Fri, 02 Nov 2018 14:45:03 GMT

Hi Experts,

I am tryng to create a link variable by concotinating certain variables. But I am getting blank data.
Please suggest.

below is my data

Data test;
input number subject$ status$ EMAIL_$ 10.;
datalines;
123 abc yes khgkjh@123
246 bcv no jhhgjh@234
run;

/*What I am tryng*/

data test1;
set test;
link = "https://Company.abc.def.com/ghi/form/fghfjghkkkkl="||strip(number)||
%nrstr("&Q_subject=")||strip(subject)||%nrstr("&status=")||strip(yes)||%nrstr("&EMAIL_ADDRESS_=")||strip(EMAIL_);
run;

Desired output
https://Company.abc.def.com/ghi/form/fghfjghkkkkl=123&Q_subject=abc&status=yes&EMAIL_ADDRESS_=khgkjh@123

Thanks,

Sanjay

Re: Concatenate multiple Variables

gamotte — Fri, 02 Nov 2018 14:49:23 GMT

Hello,

You have written 'yes' instead of 'status'.

By using simple quotes to vaoid macrovariables resolution and the cats function, you can make the expression shorter :

data test2;
set test;
link = cats("https://Company.abc.def.com/ghi/form/fghfjghkkkkl=",number,'&Q_subject=',subject,'&status=',status,'&EMAIL_ADDRESS_=',EMAIL_);
run;

Re: Concatination

PaigeMiller — Fri, 02 Nov 2018 15:12:23 GMT

@sanjay1 wrote:

Hi Experts,

I am tryng to create a link variable by concotinating certain variables. But I am getting blank data.

Blank data where? In test or in test1 or in your variables? Be specific.

To debug these things, it is extremely helpful if you actually look, with your own eyes, at the data sets created, using PROC PRINT or viewtable. Have you actually done that?

Are there errors in the SASLOG? Have you tried to figure these out? Can you show us the SASLOG?

Also there is no reason to post your question twice. Please help us maintain some order in the forums by not posting questions twice. ~~All replies ought to go into your other thread at https://communities.sas.com/t5/SAS-Programming/Concatenate-multiple-Variables/m-p/509884#M137131~~ UPDATE: The moderator has combined your two identical questions into one thread.

Re: Concatenate multiple Variables

ballardw — Fri, 02 Nov 2018 14:57:38 GMT

@sanjay1 wrote:

Hi Experts,

I am tryng to create a link variable by concotinating certain variables. But I am getting blank data.
Please suggest.

Below is my data.

Data test;
input number subject$ status$ EMAIL_$ 10.;
datalines;
123 abc yes khgkjh@123
246 bcv no jhhgjh@234
run;

/*What I am trying*/
data test1;
set test;
link = "https://Company.abc.def.com/ghi/form/fghfjghkkkkl="||strip(number)||
%nrstr("&Q_subject=")||strip(subject)||%nrstr("&status=")||strip(yes)||%nrstr("&EMAIL_ADDRESS_=")||strip(EMAIL_);
run;

Desired output
https://Company.abc.def.com/ghi/form/fghfjghkkkkl=123&Q_subject=abc&status=yes&EMAIL_ADDRESS_=khgkjh@123

Thanks,

Sanjay

You have I believe a terrible confusion between Macro functions, macro variable and dataset variables.

Show us what the final result should be for the two lines in the example data.

If you do not use " " around literal text then the &Q do not try to resolve and %nrstr are not needed.

You code also fails because you reference a variable YES that does not exist. I believe you meant to use STATUS which sometimes has a value of yes.

I am guessing that you want something similar to:

The CATS function strips so there are no leading or trailing spaces

Data test;
   input number subject$ status$ EMAIL_$ 10.;
   length link $ 200.;
   link=cats('https://Company.abc.def.com/ghi/form/fghfjghkkkkl=',number,
'&Q_subject=',subject,'&status=',status,'&EMAIL_ADDRESS_=',EMAIL_);
datalines;
123 abc yes khgkjh@123
246 bcv no jhhgjh@234
run;