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:
The following code example, which uses the SASHELP.CLASS data set, can demonstrate this issue.
Code node 1:
/* 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:
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 | ||
| 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 | ||