About SASNE

SASNE · ‎03-28-2017

Hi Gurus Any suggestion to do the following : i am running the application in SAS and i want to save the result dataset(ods) to local, it come with error stating the physical driver doesn't present thanks in advance

SASNE · ‎03-05-2017

Hi Oscar, Thank you for your help. I have tried to open The VBS file either by Double click it in window environment and by CMD environment, it just run without prompting anything ( as below). CMD C:\Project> ITypeVBSName C:\Project Window it runs without opening EG P.S The vbs created by SAS EG I have either closed the program and left it on for testing ----------------------------------------------- I test it by exporting a dataset to local directory at the end of the process , but it never create the dataset neither overwrite it once. Do you have any idea ? Thanks

SASNE · ‎03-05-2017

Hi Gurus, When i select Schedule Program A and choose Repeat task every 1 hour and indefinitely. Then the Schedule creates the vbs (and the Run times tabs show the expected run time. But it haven't run at all. Any idea ? Thanks

SASNE · ‎02-26-2017

i See. thx you for your help

SASNE · ‎02-26-2017

Hi KSharp, Thank you for your help, do you know how to do that in proc sql? thanks

SASNE · ‎02-26-2017

Hi Gurus, I would like to ask if anyone know how to dynamically assign the output file name with current system datetime ? I have attached the sample. Thank you for your help

SASNE · ‎02-26-2017

Thx, KurtBremser. Yeah ,same as last time, would like to know how to do it in Sas EG

SASNE · ‎02-26-2017

Hi Gurus, let say If i have a Column 1 to Column 100 and want to group them by Col-Fruit, in order word i want to concat Col1 to Col100 in Query builder, I would select Col-Fruit under Select Data and Add computed column with " Catx(',', Col1,Col2,Col3........Col100) are there any smart to loop or something that i don't have to type from Col1 to Col100 ? Thank for your help in advance

SASNE · ‎02-19-2017

Hi Shmuel, Thank you for your help. So that if i pull the 2 tables from SQLserver on left pane, then use Query builder join them , does it run the queue on the DB Server side ? i know that if i let say filter the table first, then the new dataset will be save as Sas7dat format in Work folder, then any action later on will be on SAS server side. Am i right ? Thank you for your advice

SASNE · ‎02-19-2017

Hi Gurus, i have three tables with one common key, once i pull those tables from the left pane, i) is it better to join it through Query Builder and set filter (condition) at once (so that the DB server handle all queue ?) or ii) pull each table and filter fields (data -> filter, select necessary fields) first, then creates sas temp file and join them one by one Which one is more effective ? Thanks Joining at once in QueryBuilder at once with Filtering

SASNE · ‎02-19-2017

Hi Gurus, i have three tables with one common key, once i pull those tables from the left pane, i) is it better to join it through Query Builder and set filter (condition) at once (so that the DB server handle all queue ?) or ii) pull each table and filter fields (data -> filter, select necessary fields) first, then creates sas temp file and join them one by one Which one is more effective ? Thanks

SASNE · ‎02-19-2017

Hi LinusH, I want to include those Null value, but when i set select ColA ColB from table where ColA!=1, then the result exclude all null value, in case i want it

SASNE · ‎02-18-2017

Hi Gurus, When i connect to Database server like Oracle, i know that it treats Null value differently from SAS, Do you think it fixs the problem if i assign every variable (which is in where clause) is missing ? Thanks

SASNE · ‎02-18-2017

Thank you for your help , jklaverstijn

SASNE · ‎02-18-2017

Hi Gurus, I am not sure why the datatype is SAS data type in EG but in fact it i just pull it out from Oracle Server ? Does it mean that when i pull it out from Oracle to SAS , it has already save those record in temp folder ? The procedure i connect to Oracle server is I ) libname FILE Oracle ................; II) then expend the left down pane Servers-> Local -> Libraries -> FILE III) Pull one table to right (working flow area) IV) Right click and property, it shows SAS DataType Thanks in advance

Online Status	Offline
Date Last Visited	‎03-30-2017 10:08 PM

Save ODS result to local run on server

Re: Schedule

Schedule

Re: Looping and Concat col in QB

Re: Dynamic output name

Dynamic output name

Re: Looping and Concat col in QB

Looping and Concat col in QB

Re: Joining at once in QueryBuilder at once with Filtering

Joining at once in QueryBuilder at once with Filtering

Re: Schedule

Re: Joining at once in QueryBuilder at once with Filtering

Re: Server Work temp folder

Re: Top 100 row Not self Typing Sql

Re: Top 100 row Not self Typing Sql

Save ODS result to local run on server

Re: Schedule

Schedule

Re: Looping and Concat col in QB

Re: Dynamic output name

Dynamic output name

Re: Looping and Concat col in QB

Looping and Concat col in QB

Re: Joining at once in QueryBuilder at once with Filtering

Joining at once in QueryBuilder at once with Filtering

Joining at once in QueryBuilder at once with Filtering

Re: Missing Value

Missing Value

Re: DataType when import from server

DataType when import from server