title: sas add prefix to column names
body: <p>I need to add a prefix to certain column names in a table. The names at the moment range from <code>_15</code> to <code>_49</code> and I would simply like to add the prefix <code>N</code> to give <code>N_15</code>,...,<code>N_49</code> etc.</p>
  
  <p>I tried the following:</p>
  
  <pre><code>proc sql noprint;
  select cats(name,'=','N',name)
  into :prefixlist
  separated by ' '
  from dictionary.columns
  where libname = 'WORK' and memname = 'Freq_nais_2006_2010';
  quit;
  </code></pre>
  
  <p>However this does nothing as I just get the message <code>no rows were selected</code> in the log output. What must I change?</p>