• Print |
• E-mail  |
• Bookmark

When using the PREFIX= option as well as an ID statement in PROC
TRANSPOSE, the format associated with the numeric ID variable may cause
the output data set to have variables named X__1, X_10, etc. where X is
the PREFIX= value, and 1 and 10 are values of the ID variable. There
should be NO underbars(_).  If the ID variable is NUMERIC, then the
format associated with the ID variable is causing the problem.
Therefore, remove the format with:

   proc transpose data=dataset prefix=prefix;
     format /* ID variable here */;
     id /* ID variable here */;
     /* rest of code here */

If the ID variable is CHARACTER, then using the option: VALIDVARNAME=V6
on an OPTIONS statement before the TRANSPOSE step will prevent the
problem:

options validvarname=v6;
   proc transpose data=dataset prefix=prefix;
     id /* ID variable here */;
      /* rest of code here */
   run;
/* reset VALIDVARNAME to the default */
options validvarname=v7;

Operating System and Release Information