Write and run SAS programs in your web browser

Error in SAS DI using Transpose and File Writer

Reply
User
Posts: 1

Error in SAS DI using Transpose and File Writer

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.

 

 


Capture.JPG
Super User
Posts: 5,437

Re: Error in SAS DI using Transpose and File Writer

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.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 147 views
  • 0 likes
  • 2 in conversation