Why the errors were coming with data values?

[devarayalu]

Reference ID	Arm.ID	Character
2538	1	%ALK+
2538	1	%ALK-
2538	1	%ALK(Unknown)
2538	1	%T790M+
2538	1	%T790M-
2538	1	%T790M(unkown)
2538	1	%CMET+
2538	1	%CMET-
2538	1	%CMET(unknown)
2538	2	%ALK+
2538	2	%ALK-
2538	2	%ALK(Unknown)
2538	2	%T790M+
2538	2	%T790M-
2538	2	%T790M(unkown)
2538	2	%CMET+
2538	2	%CMET-
2538	2	%CMET(unknown)

proc transpose data=transpose_New out=one;

by Reference_ID Arm_id;

Id character;

var value;

run;

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

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

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

NOTE: The above message was for the following by-group:

      Reference ID=2538 Arm.ID=1

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

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

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

NOTE: The above message was for the following by-group:

      Reference ID=2538 Arm.ID=2

ERROR: All BY groups were bad.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 18 observations read from the data set WORK.TRANSPOSE_NEW.

WARNING: The data set WORK.ONE may be incomplete.  When this step was stopped there were 0

         observations and 0 variables.

WARNING: Data set WORK.ONE was not replaced because this step was stopped.

NOTE: PROCEDURE TRANSPOSE used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

[Fraktalnisse · Accepted solution]

In Proc Transpose, the values in the ID variable will be interpreted as variable names in the output data set. Invalid characters will be replaced with underscore. For example, the values %ALK+ and %ALK- will both be transformed into the valid variable name _ALK_. So, this value occurs twice in the same by group.