When you reference an SQL view in the DATA= option of a PROC APPEND statement instead of referencing the actual table, a note showing incorrect results is written to the SAS log.

The code found in the Full Code tab in this Problme Note demonstrates the incorrect results and produces the following message in the SAS log file:

NOTE: The data set TMP.BASETABLE has 20 observations and 1 variables.

Select the Hot Fix tab in this Note to access the hot fix for this problem.

Operating System and Release Information

%let libdom=tmp ;
%let hostname=localhost ;
%let portno=5400 ;

libname &libdom sasspds "&libdom" host="&hostname" serv="&portno"
user='anonymous' ;

data &libdom..basetable appendthis ;

   do i = 1 to 10 ;
      output ;
   end ;
run ;

proc datasets library=&libdom nolist ;
   modify basetable ;
   index create i / unique ;
quit ;

/* create a view */
proc sql ;
  create view work.testview as
  select *
    from work.appendthis ;
quit ;


proc append base=&libdom..basetable (uniquesave=rep) data=testview ;
run ;

A fix for this issue for Scalable Performance Data Server 4.52 is available at: