sas cut charter string

[shursulei2]

%let sqlcodetest=%nrstr(/*how sql*/select * from tables);
%put &sqlcodetest;

The result is "select * from tables", the "/*how sql*/" is not exits.I want to know how to use macro to get the "/*how sql*/"

[ed_sas_member · Accepted solution]

Hi @shursulei2 

Try this:

%let sqlcodetest=%str(/)*how sql*%str(/) select * from tables;
%put &sqlcodetest;

Best,