m**o
发帖数: 5261 | 1 proc sql;
select name into :names separated by ....;
if I want to get a macro variable like peter','john','mary then how can i
specify the statement after separated by?
if i get a string like peter','john','mary how can i turn it into 'peter','
john','mary'?
Thank you very much. |
a****g
发帖数: 8131 | 2 select "'"||name||"'" into |
m**o
发帖数: 5261 | 3 Thank you
【在 a****g 的大作中提到】
: select "'"||name||"'" into
|
a****g
发帖数: 8131 | 4 50个包子，不用谢
【在 m**o 的大作中提到】
: Thank you
|
h******e
发帖数: 1791 | 5 50个包子是500点，好大的胃口。
【在 a****g 的大作中提到】
: 50个包子，不用谢
|
j**********3
发帖数: 305 | 6 there is quote function in proc sql right now. No need to use the old school
way .LOL |
d******9
发帖数: 404 | 7 Details, please.
school
【在 j**********3 的大作中提到】
: there is quote function in proc sql right now. No need to use the old school
: way .LOL
|
j**********3
发帖数: 305 | 8 proc sql noprint;
select quote(xxx) into :xxx from xxx;
quit; |
