When using a CALL DEFINE with PROC REPORT to apply a URL to a GROUP or ORDER variable, the URL link is applied to every row in the column in SAS® 9.2. In SAS® 9.1, the URL only applied to the GROUP or ORDER variable value. This applies only to ODS destinations.

To apply the link only to the GROUP or ORDER variable value, do one of the following:

• Add the SPANROWS option to the PROC REPORT statement.

• Use a subsetting IF statement to determine if the cell for the row contains a value and then apply the link with a CALL DEFINE and the URL attribute.

Please see the code in the Full Code tab for an example.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	Base SAS	z/OS	9.2 TS1M0	9.3 TS1M0
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows XP 64-bit Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft® Windows® for x64	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Datacenter Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Enterprise Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows Server 2003 Standard Edition	9.2 TS1M0	9.3 TS1M0
		Microsoft Windows XP Professional	9.2 TS1M0	9.3 TS1M0
		Windows Vista	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled AIX	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled HP-UX	9.2 TS1M0	9.3 TS1M0
		64-bit Enabled Solaris	9.2 TS1M0	9.3 TS1M0
		HP-UX IPF	9.2 TS1M0	9.3 TS1M0
		Linux	9.2 TS1M0	9.3 TS1M0
		Linux for x64	9.2 TS1M0	9.3 TS1M0
		OpenVMS on HP Integrity	9.2 TS1M0	9.3 TS1M0
		Solaris for x64	9.2 TS1M0	9.3 TS1M0

* 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.

Below is code that will produce the problem and illustrate both of the suggested circumventions.

In SAS 9.1, a link is created to the cell with a value within the column. In SAS 9.2, a link is created for every cell in the column.

---

ods html;

proc report data=sashelp.class nowd split='*';
   columns sex name age;
   define sex /group;
   define name /display;
   define age /display;
   compute sex /char length=55;
      href=sex||'.html';
      call define(_col_,"URL",href);
   endcomp;
run;

ods html close;

/*** SPANROWS workaround ***/ 

/* Modify the C:\ path to a directory that you have write access to. */                                                      
ods pdf file='c:\myfile.pdf' ;

proc report data=sashelp.class nowd split='*' spanrows;
   columns sex name age;
   define sex /group;
   define name /display;
   define age /display;
   compute sex /char length=55;
      href=sex||'.pdf';
      call define(_col_,"URL",href);
   endcomp;
run;

ods pdf close;

/*** Subsetting IF statement workaround ***/ 

ods html;

proc report data=sashelp.class nowd split='*';
   columns sex name age;
   define sex /group;
   define name /display;
   define age /display;
   compute sex;
      if sex ne ' ' then do;
         href=sex||'.html';
         call define(_col_,"URL",href);
      end;
   endcomp;
run;

ods html close;

Blank GROUP or ORDER rows might contain links created from a CALL DEFINE with the URL attribute. This applies only to ODS destinations.

Type:	Problem Note
Priority:	medium
Topic:	SAS Reference ==> Procedures ==> REPORT

Date Modified:	2010-05-05 08:40:20
Date Created:	2010-04-22 17:10:22