How does one put # sign that is included in text for a column label in PROC SQL?  When the following is run, # gets dropped from the column header.   proc sql; select make, count(*) "# of cars" from sashelp.cars group by make; ... View more

Is there a way to put a text box at the beginning of the analysis in the output window in SAS EG (report or html  windows)?  I do not want to save the results to an html or pdf file using ODS but I want it to go to the output window, and if needed I would like to save the output myself.  I do not want it occupying the entire page.    I use the following code and it works fine but the font is too small.  Is there a way to change the font or an easier way to do it that does not require too many lines of code.  Sample code attached below. data _null_; file print; line1="Data : aaa"; line2="Years of study: xxx"; line3="Outcomes: BBB"; put #1 line1 10-35 #2 line2 10-35 #3 line3 10-35; file log; run;   ... View more

I would like to report counts with percentages in the next column after  the counts for several sepecific conditions.  The easiest way for me is to do with PROC SQL.  However the third line of code given the sample code does not work. I want to report percentages after counts, not the other way around.  It seems the order of variables matter when using INTO in SAS.  Is there a way around it without using multiple SELECT statements? data one; do x=-2 to 2 by 0.01; y=(x-2)*(x-1.5)*(x-1)*(x-.5)*x*(x+.5)*(x+1)*(x+1.5)*(x+2); output; end; run; proc sql; select count(x),sum(x) into :a from one; **works; select sum(x) into :a,count(x) from one; **does not work; ... View more