SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Custom Transformation Challenge

Reply
Contributor
Posts: 42

Custom Transformation Challenge

Hi,

Trying to create a custom transformation having the using the following code.

%macro soverign ;

proc means data=&_input median stddev ;

by id Legal_Entity_L1 Legal_Entity_L2 Instrument_Type Country;

var Exposure;

output OUT= &_output  median = Median stddev=Stddev;

run;

%mend;

%soverign;

While testing, the transformation runs without an error, however when we try to see the worktable, it throws an error, saying that the metadata of the columns are not registered, 

Any idea what am I missing here.

Regards

Ronnie

Super User
Posts: 5,435

Re: Custom Transformation Challenge

Posted in reply to Ronny_Dsouza

The first clue is the message "columns are not registered". What are the column definitions of the work table? It should/must match the physical table structure created by the custom code.

Then it's a bit odd that you have hard coded variable names in the proc, that takes away a bit of the usefulness of a generated transformation.

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 240 views
  • 0 likes
  • 2 in conversation