UPDATED: Within a PROC SQL step, I comment code using </* comment */>, like this; proc sql;
create table comment_test as
select *
from sashelp.cars
where make = 'Acura' /*filter by make*/ order by model;
;
quit; During development, however, I may want to comment out large sections of code, like the where statement in the above snippet. proc sql;
create table comment_test as
select *
from sashelp.cars
/*where make = 'Acura' /*filter by make*/*/ order by model;
;
quit; However, you'll notice that the right-hand, closing comment characters are now executable, so the step fails. A similar problem comes up if developing with, say, the data step. data comment_test;
set sashelp.cars;
/* where make = 'Acura'; /* filter by make */*/
run; Here, everything after the comment characters is commented out, so the run statement will not execute and the program fails. The solution in the data step is to use <* comment ;> statements, rather than </* comment */>: data comment_test;
set sashelp.cars;
/* where make = 'Acura'; * filter by make; */
run; But this style of commenting is not available in proc sql. Try: proc sql;
create table comment_test as
select *
from sashelp.cars
where make = 'Acura' *filter by make;
order by model;
;
quit; Can somebody please advise on a development workflow in proc sql that accommodates this issue?
... View more