topic using cats function with an apostrophe in SAS Enterprise Guide

using cats function with an apostrophe

alepage — Thu, 18 May 2023 18:12:59 GMT

Hello,

I am using a cats function to generate one json record (see the code below). But the cats function failed when there is an apostrophe either in the first name or last Name.

How do we solve that issue ?

Ex last Name = D'agostina

Data ConsentInfo&j.;
length record $4000;
set info_1;
i=_n_;
record=cats("'", '{ "firstName" : ',' "',firstName,'", ',' "lastName" : ','"',lastName,'", ','"email" :',
'"',email,'"}',"'");
call symputx(cats('NewRec',i),record,'g');
run;

Re: using cats function with an apostrophe

Tom — Thu, 18 May 2023 18:26:12 GMT

Don't try to add the quotes yourself. Use the QUOTE() function to properly add the quotes around a string. That will properly double up any quotes that are in the string.

Use the optional second argument when you want it to use single quotes instead of the default double quotes.

record=quote(cats('{ "firstName":',quote(trim(firstname))
                 ,',"lastName":',quote(trim(lastName))
                 ,',"email" :',quote(trim(email))
                 ,'}')
      ,"'");

Re: using cats function with an apostrophe

alepage — Thu, 18 May 2023 19:53:59 GMT

By doing that, for example instead of seeing D'agostina, we will have D ' ' Agostina and the cats function will take it. However at the end, when this lastName will be sent to an API Web Site, the lastName will look like as D ' ' Agostina instead of D'agostina.

Is there another work around solution ?

Re: using cats function with an apostrophe

Tom — Thu, 18 May 2023 20:06:28 GMT

You will need to show the full code to see whether or not that is true.

In normal SAS code that is NOT what will happen. Try it.

data test;
  name="D'Agostina";
  string1=cats('{"name":',quote(trim(name)),'}');
  qstring=quote(trim(string1),"'");
  call symputx('mvar',qstring);
run;

data test2 ;
 set test;
 string2=&mvar;
 put (_all_) (=/);
run;

Re: using cats function with an apostrophe

ballardw — Thu, 18 May 2023 20:30:48 GMT

If you are doing this to create JSON output why are you sticking values into a macro variable?

And did you try the Libname JSON engine to create JSON files?