Hi,   So I looked up Teradata's documentary. Substring and Substr are slightly different although they are all doing substring work.   SAS Substr is equal to Substring in Teradata.    My confusion is that when I code in sas, I ask sas to connect to Tera and perform query in tera, and then, create table in sas. So how did Teradata understand SAS substr and perform the query?    Thanks,   Vi ... View more

Hi Rafael, In EG 7.1, a context menu item (when you right-click a range of cells) called "Copy with headers" was added to the data grid, which will allow you to copy/paste the column headers in addition to the values. Casey ... View more

I assume you're using SAS EG or SAS Studio. These are the clients. You then connect to a SAS Server. It's on the server where your SAS program gets executed and it's also on the server where SAS WORK lives (not on your local machine). If done manually then SAS EG allows you to import/export a file and then execute the data on the server. But this works in a way that SAS EG as a very powerful client (installed on your local machine) accesses the data, imports it and then sends the data together with the SAS code to the Server for processing - so the resulting data still lives on the server. SAS EG also gives you the ability to store (export) a SAS table as an Excel - but this is again the EG client communicating with the SAS Server, downloading the data to the client and then using .net to generate an Excel. This is nothing you can do programatically (except via EG "scheduling" - but this is just "automating" the client). Soooo... The only real solution is to write server output to a file system which can also be accessed by the local computer. ...just thinking: Another option would be to create the desired output on the server and then send this output via email attachment to yourself (if the server can access an email server - which is very often possible). ... View more

Thank you very much - i didn't know that. Rafael ... View more