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

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SPDS	Scalable Performance Data Client	Solaris for x64	4.5	4.52 HF4
		Linux for x64	4.5	4.52 HF4
		HP-UX IPF	4.5	4.52 HF4
		64-bit Enabled Solaris	4.5	4.52 HF4
		64-bit Enabled HP-UX	4.5	4.52 HF4
		64-bit Enabled AIX	4.5	4.52 HF4
		Microsoft Windows Server 2008 for x64	4.5	4.52 HF4
		Microsoft Windows Server 2008	4.5	4.52 HF4
		Microsoft Windows Server 2003 for x64	4.5	4.52 HF4
		Microsoft Windows Server 2003 Enterprise Edition	4.5	4.52 HF4
		Microsoft Windows Server 2003 Standard Edition	4.5	4.52 HF4
		Microsoft Windows 2000 Professional	4.5	4.52 HF4
		Microsoft Windows Server 2003 Datacenter Edition	4.5	4.52 HF4
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	4.5	4.52 HF4
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	4.5	4.52 HF4

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Modify the macro variables to match your environment setting before submitting the code.

---

%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:

http://ftp.sas.com/techsup/download/hotfix/HF2/B57.html#42483

---

Type:	Problem Note
Priority:	alert

Date Modified:	2011-04-23 17:58:34
Date Created:	2011-02-23 07:06:04