66229 - Two consecutive code steps in a data plan cause a "Transpose" transform issue and the error message "One or more required columns cannot be found"

Problem Note 66229: Two consecutive code steps in a data plan cause a "Transpose" transform issue and the error message "One or more required columns cannot be found"

In SAS^® Data Studio 2.5, after you set two consecutive code steps in a data plan, you might see the following error message:

One or more required columns cannot be found.

The following code example, which uses the SASHELP.CLASS data set, can demonstrate this issue.

Code node 1:

data {{_dp_outputTable}} (caslib={{_dp_outputCaslib}} promote="no");

   /* Set the input set */

   set {{_dp_inputTable}} (caslib={{_dp_inputCaslib}} );

   /* End the DATA step run */

   Height_metric = ROUND(Height*0.0254, 0.01);

   Weight_metric = ROUND(Weight*0.45359237, 0.1);

   drop Height Weight;

run;

Code node 2:

/* Begin the DATA step with the output table data */

data {{_dp_outputTable}} (caslib={{_dp_outputCaslib}} promote="no");

   /* Set the input set */

   set {{_dp_inputTable}} (caslib={{_dp_inputCaslib}} );

   /* End the DATA step run */

   bmi = Weight_metric/(Height_metric*Height_metric);

run;

Here are the selections for the Transpose node:

ID Columns: Name
Transpose Columns: bmi
Group By Columns: Sex

Although the data plan is saved and executes correctly, the error appears for the Transpose transform after you open the data plan again. This issue can also affect other non-code-based transformations that use the same consecutive code steps.

As a workaround, you can add a Rename transform node in between each of the steps of the plan. Here is an example of the revised steps:

Code node 1 ► Rename ► Code node 2 ► Rename ► Transpose

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Viya	Microsoft® Windows® for x64	3.5	3.5	Viya	Viya
		Microsoft Windows Server 2012 R2 Datacenter	3.5	3.5	Viya	Viya
		Microsoft Windows Server 2012 R2 Std	3.5	3.5	Viya	Viya
		Microsoft Windows Server 2016	3.5	3.5	Viya	Viya
		Linux for x64	3.5	3.5	Viya	Viya

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

Type:	Problem Note
Priority:	high

Date Modified:	2020-09-30 21:09:21
Date Created:	2020-07-01 08:11:40

Support

Problem Note 66229: Two consecutive code steps in a data plan cause a "Transpose" transform issue and the error message "One or more required columns cannot be found"

Operating System and Release Information