topic Custome code in VDB in SAS Visual Analytics

Custome code in VDB

arpan_ghosh — Wed, 25 Mar 2015 17:38:28 GMT

Hi,

After unlocking the code and saving it, the columns in the output table are removed from metadata.

After saving the data query containing the custom code, the columns of the output table present in the query is removed.

But in need to run this data query on periodic basis

Let me know if I am missing something? Any suggestions

Cheers

Arpan

Re: Custome code in VDB

Madelyn_SAS — Wed, 25 Mar 2015 20:28:29 GMT

When you unlock the code, the Design and Results tabs are removed from the interface, and you must continue to maintain the query via code. Is this the behavior that you are referring to?

Re: Custome code in VDB

arpan_ghosh — Fri, 27 Mar 2015 01:30:15 GMT

Hi,

After unlocking the code the design and Results tab are removed but when I save the query after editing the manual code the columns in the output table are removed from metadata.

But in need to run this data query on periodic basis and need to have the results in an output table.

How do I achieve that as my output table does not have any columns once I save the custom data query.

can we not save the output of custom code results (done in the code tab) in the output table?

Regards

Arpan

Re: Custome code in VDB

Lorrie_SAS — Thu, 09 Apr 2015 21:07:34 GMT

Hi Arpan,

From your problem description, it sounds like you might have saved the query after unlocking editing on the Code tab. Try saving the data query before you unlock manual editing.

There are several steps to take before unlocking manual editing. You can find more information about them in the User's Guide here:

http://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#n0xlm7xwg2dyern1ph1mhpeqnrtn.htm

Please let me know if this helps.

Best regards,

Lorrie