topic Re: add double quotes for words in string in SAS Programming

add double quotes for words in string

Nasser_DRMCP — Wed, 07 Feb 2018 11:06:40 GMT

Hello,

I have got a list of words and I would like get these words with double quotes.

%let list_have = word1 word2 word3 ...; the max number of word is 10

I would like to get the macro variable list_want that would contain "word1" "word2" "word3" ...

thanks in advance for your help

regards

Nasser

Re: add double quotes for words in string

RW9 — Wed, 07 Feb 2018 11:34:56 GMT

Really not the best idea to be using a text find and replace system for data. You can do it simply (shows the power of using the real programming language rather than find/replace) in a data _null_;

%let list_have = word1 word2 word3;

data _null_;
  length temp $2000;
  temp=cat('"',tranwrd("&list_have."," ",'" "'),'"');
  call symput('list_want',temp);
run;

%put &list_want.;

You can likely do the same if you create some ghastly complex macro code which is indecipherable and falls over every other run.

Re: add double quotes for words in string

foobarbaz — Wed, 07 Feb 2018 11:37:04 GMT

Within a macro you can also use the following which allows direct assignment in a let statement. This is adapted from http://documentation.sas.com/?docsetId=mcrolref&docsetTarget=p1n2i0ewaj1zian1ria5579z1zjh.htm&docsetVersion=9.4&locale=en

%let list_have = word1 word2 word3;

%macro quotelist(varlist);
   %let word_cnt=%sysfunc(countw(&varlist)); 
   %let list=;
   %do i = 1 %to &word_cnt; 
     %let temp=%qscan(%bquote(&varlist),&i);
     %let list = &list %bquote("&temp.");
   %end;
   &list;
%mend;

%let new = %quotelist(&list_have);

%put &=new;

Re: add double quotes for words in string

gamotte — Wed, 07 Feb 2018 11:38:23 GMT

Hello,

%let list_have=word1 word2 word3;
%let want="%sysfunc(tranwrd(&list_have.,%str( ),%str(%" %")))";

%put &want.;

Re: add double quotes for words in string

ballardw — Wed, 07 Feb 2018 16:14:08 GMT

@foobarbaz I reached a similar result. However note the difference in behavior with:

%macro addquote (wordlist);
/* word list is expected to be space delimited and no word containing
quotes or special symbols*/
%let result=;
%do i=1 %to %sysfunc(countw(&wordlist));
   %let result = &result %sysfunc(quote(%sysfunc(scan(&wordlist,&i))));
%end;
&result
%mend;

%put %addquote(var1 var2 var3);

data junk;
   set sashelp.class;
   where name in (%addquote(Alice Carol John Philip));
run;

and

data junk;
   set sashelp.class;
   where name in (%quotelist(Alice Carol John Philip));
run;

Re: add double quotes for words in string

Ksharp — Thu, 08 Feb 2018 13:13:25 GMT

%let list_have = word1 word2 word3;
%let list="%sysfunc(prxchange(s/\s+/" "/,-1,&list_have))";

%put &list ;

Re: add double quotes for words in string

Quentin — Thu, 08 Feb 2018 13:29:01 GMT

I'm a big fan of Richard DeVenezia's utility macro %SepList. It does a lot of list management, including adding quotes to items, changing delimiters, adding prefixes...

https://www.devenezia.com/downloads/sas/macros/index.php?m=seplist

83   %let list_have = word1 word2 word3 ;
84
85   %put %seplist(&list_have,indlm=%str( ),dlm=%str( ),nest=QQ) ;
"word1" "word2" "word3"
86
87   %put %seplist(&list_have,indlm=%str( ),dlm=%str( ),nest=Q) ;
'word1' 'word2' 'word3'
88
89   %put %seplist(&list_have,indlm=%str( ),dlm=|) ;
word1|word2|word3
90
91   %put %seplist(&list_have,indlm=%str( ),dlm=%str(, ),prefix=_) ;
_word1, _word2, _word3

I changed my personal version slightly, so that it %unquotes the value returned, and the default value for DLM is set to INDLM.

Re: add double quotes for words in string

Ksharp — Thu, 08 Feb 2018 13:45:01 GMT

I am big fan of PRXCHANGE for this kind of problem which is origined from @Patrick


 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         %let list_have = word1 word2 word3;
 70         %let list="%sysfunc(prxchange(s/\s+/" "/,-1,&list_have))";
 71         %put &list ;
 "word1" "word2" "word3"
 72         
 73         
 74         %let list_have = word1 word2 word3;
 75         %let list=%bquote('%sysfunc(prxchange(s/\s+/' '/,-1,&list_have))');
 76         %put &list ;
 'word1' 'word2' 'word3'
 77         
 78         
 79         %let list_have = word1 word2 word3;
 80         %let list=%sysfunc(prxchange(s/\s+/|/,-1,&list_have));
 81         %put &list ;
 word1|word2|word3
 82         
 83         %let list_have = word1 word2 word3;
 84         %let list=%sysfunc(prxchange(s/(\w+)/_$1%str(,)/,-1,&list_have));
 85         %put &list ;
 _word1, _word2, _word3,
 86         
 87         
 88         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 99