topic Error in SAS DI using Transpose and File Writer in SAS Studio

Error in SAS DI using Transpose and File Writer

nenita — Wed, 03 Aug 2016 07:53:48 GMT

Hi,

I am fairly new in SAS DI. I have created a new job which extracts from a flat file, transposes the rows into columns and writes them into a .CSV file. However, when I ran the job, I have this error:

ERROR: The following columns were not found in the contributing tables: mchn_nm.

Can someone help me resolve this issue, please? Thank you.

Re: Error in SAS DI using Transpose and File Writer

LinusH — Sat, 06 Aug 2016 21:37:12 GMT

Transpose is a "dangerous" transformation since it creates new columns dynamically based on row values. Carefully analyze your log and view the output data from the transformation to understand the miss match between meta data and physical data.
Sadly, there is no silver bullet here.
If you want to have fixed output layout you probably need somehow hard code the columns you like to keep.
There are ways to generete meta data on the fly - but that's usually complicating the overall solution.