NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M4)
      Licensed to YALE UNIVERSITY - SFA - T&R, Site 70083298.
NOTE: This session is executing on the X64_10PRO  platform.



NOTE: Updated analytical products:

      SAS/STAT 14.2
      SAS/ETS 14.2
      SAS/OR 14.2
      SAS/IML 14.2
      SAS/QC 14.2

NOTE: Additional host information:

 X64_10PRO WIN 10.0.17134  Workstation

NOTE: SAS initialization used:
      real time           1.74 seconds
      cpu time            0.64 seconds

NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
WARNING: SASUSER.TEMPLAT is not a template store! It will be ignored.
1    libname a access '\\Mac\Dropbox\CDC\Kenya\Validation files cleaned\SAS Datasets\CRF
1  ! datasets\validation_access.accdb';
NOTE: Libref A was successfully assigned as follows:
      Engine:        ACCESS
      Physical Name: \\Mac\Dropbox\CDC\Kenya\Validation files cleaned\SAS Datasets\CRF
      datasets\validation_access.accdb

2
3    proc transpose data=a.hivtest out=want;
4    var database_value;
5    id variable;
6    by StudyId;
7    run;

ERROR: The ID value "TestResultMom" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6002
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6003
ERROR: The ID value "ReasonNotDone" occurs twice in the same BY group.
ERROR: The ID value "ReasonNDMom" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6007
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6008
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6009
ERROR: The ID value "TestResult" occurs twice in the same BY group.
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
ERROR: The ID value "DateDone" occurs twice in the same BY group.
ERROR: The ID value "ReasonNDMom" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6010
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6011
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
ERROR: The ID value "DateDone" occurs twice in the same BY group.
ERROR: The ID value "TestResultMom" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6014
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6042
ERROR: The ID value "RapidKitUsed" occurs twice in the same BY group.
NOTE: The above message was for the following BY group:
      StudyID=K6044
ERROR: The ID value "OtherReasonND" occurs twice in the same BY group.
ERROR: Too many bad BY groups.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.WANT may be incomplete.  When this step was stopped there were 0
         observations and 0 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
      real time           0.14 seconds
      cpu time            0.06 seconds