Problem Note 65719: Jobs that contain Conditional Start and Conditional End transformations can fail with the message "Libref libref-name is not assigned"
 |  |  |  |
You can see the following error message after running a SAS® Data Integration Studio job:
ERROR: Libref libref-name is not assigned.
The message appears when these conditions are true:
- The SAS Data Integration Studio job contains at least one section within the Conditional Start and Conditional End transformations, which run only if the execution criteria are met.
- SAS Data Integration Studio generates the LIBNAME statement for a library within the conditional section of the job.
- Tables from that library are referenced both inside and outside the conditional section of the job.
- At job execution time, the conditional section of the job is not run because the criteria for the execution of that section are not met.
This problem occurs because the portion of the job code that contains the library is not executed, but subsequent code within the job contains references to tables within that library.
To work around this issue, you can make the following change to the job definition:
- Open Properties for the SAS Data Integration Studio job and go to the Parameters tab.
- Select New Prompt.
- Provide a value for the Name field (DefineLib, for example).
- Specify a value for the Displayed Text field (Assign Needed Library, for example).
- Select the Read-only values and Requires a non-blank value check boxes.
- Select the Prompt Type and Values tab.
- Choose Data Source for the Prompt type field.
- Select Browse and navigate to the location that contains one of the tables that are associated with the library that you need allocated outside the Conditional code block. Select the table.
- Select OK.
- Select OK again to save the changes.
This new Prompt definition within the Parameters tab causes that library to be defined at the top of the generated code so that it is no longer within a Conditional code block and is available for use throughout the entire job code.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft Windows Server 2012 Datacenter | 4.8 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2008 R2 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2008 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 10 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Pro x64 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Pro x64 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Pro 32-bit | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Enterprise x64 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows 8 Enterprise 32-bit | 4.8 | 9.4 TS1M1 | ||||
| Microsoft® Windows® for x64 | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 R2 Std | 4.8 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 Std | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Enterprise 32 bit | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Enterprise x64 | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Home Premium 32 bit | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Home Premium x64 | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Professional 32 bit | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Professional x64 | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Ultimate 32 bit | 4.8 | 9.4 TS1M1 | ||||
| Windows 7 Ultimate x64 | 4.8 | 9.4 TS1M1 | ||||
| 64-bit Enabled AIX | 4.8 | 9.4 TS1M1 | ||||
| Linux for x64 | 4.8 | 9.4 TS1M1 | ||||
SAS® Data Integration Studio jobs that contain Conditional Start and Conditional End transformations fail when the library allocation for tables that are referenced within the job cannot run, because the criteria for the execution of the conditional section are not met.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-09-04 09:31:59 |
| Date Created: | 2020-03-20 12:37:45 |