Hello-      I'm running a 2-way crosstab in Proc Freq and am dumping the output into Excel using the ODS HTML output options. Proc Freq always pads the output with two columns.   The first column has this information in it:   "Frequency  Percent  Row Pct  Col Pct"   While the second column is blank.   What are the options that will suppress these two columns?   Thank you. ... View more

Hello-   I'm creating a set of macro variables that will sweep across a line of text and increment new values for "Start" and "End" fields based on the position of the pointer for the last value + 1. As the pointer sweeps across the line, it is searching for a specific character using the findc() function. Each time it finds that character, it uses that as the "End" value for the last field and the "Start" value for the next field plus 1:   Here's a sample of a line of text:            ƒƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆƒƒƒƒƒƒƒƒˆ   So, we know that the text begins in column 9 and the specific character that the findc() function is seeking is the 'ˆ'. This means that for the first field, we can set the start value to 9 and the end value to 18 since the 'ˆ' is the 18th character in the text. For each successive field, based on the position of the 'ˆ', the start and end values look like this:   Field   Start   End   1         9       18   2        19      28 and so on   The thing that makes this challenging is that the the End position can fluctuate, based on the line of text being processed.    To assign the End values to a set of macro variables, I'm using the findc() function.   x=findc(text,'ˆ',start+1);    I can't use "call symput" to assign a macro variable with the value of x because that will only resolve once the data step is completed. Similarly, the %let End=x; or %let End=%eval(x); don't work.    How do I assign the value of "x" into a macro variable and use it in the same data step?   Thank you.   ... View more

I've read that for SAS v12.1, there is a new null matrix operator, {}.  The challenge is that I am running SAS v9.3M1. So, in this earlier version, is there a way to test whether or not a matrix is null in v9.3M1? ... View more

Using the APPEND statement, output data can be created within Proc IML. Using Proc Append within a macro do loop, output can be concatenated from multiple, separate Proc IML calls within that macro.    My question concerns concatenating or updating output data within a do loop from a single Proc IML call. The APPEND statement only retains the most recent value from the loops. I would like to track the successive values within each iteration of that loop. So, if the loop iterates 100 times, then there would be 100 values appended to a single output data set.   Is this possible in Proc IML? ... View more