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; |