03-06-2015 02:42 AM
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;
output OUT= &_output median = Median stddev=Stddev;
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.
03-06-2015 05:04 AM
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.