• Print |
• E-mail  |
• Bookmark

The following error is produced by PROC TRANSPOSE when option
VALIDVARNAME=V6 is set and 82BX04 hot fix is applied. (Without 82BX04
or with VALIDVARNAME=V7 or ANY there are no errors).

   ERROR: The ID value "_" occurs twice in the same BY group.

To avoid the above error use VALIDVARNAME=V7, or install 82bb32 HotFix
(after 82bx04 has been installed)

The following sample program illustrates the problem.

   options validvarname=v6;
   data test;
     system='aaaa';
     do hour=0 to 23;
       val=hour;
       output;
     end;
   run;
   proc sort data=test;
     by system;
   run;
   proc transpose data=test out=testp;
     by system;
     var val;
     id hour;
   run;


A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009625

For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#009625


If the problem was not produced by the application of hotfix 82bx04, see
SAS Note 3844 for additional info.

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

A fix for Release 8.2 (TS2M0) with Asian Language Support (DBCS) for this issue is available at: