How do I see the SAS code generated by a Workbench for an individual node?
How do I see the SAS code generated by a Workbench for an individual node? You can see the log, but I can't see how to access the code for a single node.
Best Answer
-
Hi all,
When viewing the log for a specific block, there is an option to export the code.
Hence, if you right-click on a block and select "Open Log", this will open a window presenting the log for the specific block. Then, if you right-click on the log, there is an option to "Copy Code" which copies only the code, and not any execution messages, to the clipboard.
BR,
George
1
Answers
-
Hi Howard,
If you right click on the Workflow canvas, there is an option to "Export To SAS Language Program", you can specify the directory for the temp datasets and when you click "Next", you should be able to see the .sas program generated by the workflow.
Let me know if this is what you are looking for.
Thanks & Regards,
Surabhi
0 -
Thanks. Yes, I'm aware of that. Some nodes (e.g. sql join) have a tab to let you see the generated sql, but others don't. I was hoping for a way to see the code for a single node, without having to export for the whole workflow, especially if it's a complicated workflow and would be hard to identify that node's code.
0 -
Hi all,
When viewing the log for a specific block, there is an option to export the code.
Hence, if you right-click on a block and select "Open Log", this will open a window presenting the log for the specific block. Then, if you right-click on the log, there is an option to "Copy Code" which copies only the code, and not any execution messages, to the clipboard.
BR,
George
1 -
Indeed, that works! It looks like it just strips the line numbers and notes, etc. off the log, and it's a bit cumbersome as really you'd like to just right-click on the node and click Show Code. But I guess that will do for now, so thank you
0