topic quotes for list of letters in SAS Programming

quotes for list of letters

BrahmanandaRao — Tue, 14 Mar 2023 05:52:11 GMT

data quots;
x='(A,B,C,D,E)';
z=quote(x);
run;

hi guys

I want give quotes for list of letters

desired output

z=('A','B','C','D','E')

Kurt_Bremser — Tue, 14 Mar 2023 06:33:17 GMT

The function can only put quotes around the whole argument (read the documentation).

To put quotes around each comma-separated substring within the brackets, you need a DO loop with SCAN and rebuild the string in a new variable.

But there are two important questions: how is the string originally built, and what do you intend to do with it later?

Hao_Luo — Tue, 14 Mar 2023 06:37:13 GMT

1. Remove the brakets outside;

2. Subtitute " , " as " ',' " ;

3. Concatenate brakets, single quotes and string in step 2;

data quots;
  x='(A,B,C,D,E)';
  y1=substr(x,2,length(x)-2);
  y2=tranwrd(y1,",","','");
  z="('"||trim(y2)||"')";
run;

Ksharp — Tue, 14 Mar 2023 12:59:04 GMT

data quots;
length x $ 40;
x='(A,B,C,D,E)';
z=prxchange("s/(\w+)/'\1'/",-1,x);
run;
proc print;run;