Custom Transformation Challenge

[Ronny_Dsouza]

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

[LinusH]

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.