I used below code to pull the data in SAS (which is installed on Citrix) , it took me 2 minutes to get the result back. When I tested this query in MS SQL manager, it only used one sec. If I write a more complex query, it will take forever to run. Can anyone let me know how to fix this? Proc sql; connect to oledb as test ( datasource=XXXX provider=MSDASQL.1); CREATE TABLE TEMP AS select * from connection to test (select ID_Number Start_Date from Daily_Table where Start_Date between '2019-02-01' and '2019-02-28') ; quit;   Log:  NOTE: Table WORK.TEMP created, with 3547 rows and 2 columns. 21 quit; NOTE: PROCEDURE SQL used (Total process time): real time 2:19.78 cpu time 0.40 seconds ... View more

Currently, I am using SAS E guide locally and trying to set up the connection between SAS and a database. The one I wanted to use is called XXX, i can find it through ODBC data source administrator->system DSN->System Data Sources: Name XXX, Driver SQL server. Could you please let me know if I have what I need to set up the connection? So that I can access tables on this XXX database in SAS. If so, how do I do it? Sorry if this question seems dumb to you. I really cannot find anyone to help me with this issue.  ... View more

I am trying to generate a decision tree by using PROC HPSPLIT on E guide at work.  After I ran the following code, the only thing generated in results was performance information. execution mode: single mode, number of threads:2. There were no graphs at all.  (I masked the sensitive data and tried this code in SAS ondemand, it worked just fine.) ODS GRAPHICS ON; PROC HPSPLIT data=COMBINE_Data maxdepth=7 maxbranch=2; Target FLAG; input VAR1 VAR2 VAR3 VAR4/level=nom ; input VAR5 VAR6 VAR7/level=int; criterion entropy; prune misc / N <= 6; partition fraction(validate=0.5); run;   A few more things I checked:  1. Option->Results General: SAS Report was selected. 2. proc setinit;run; Product expiration dates: ---Base SAS Software 14APR2019 ---SAS/STAT 14APR2019 ---SAS/GRAPH 14APR2019 ---SAS/ETS 14APR2019 ---SAS/Secure 168-bit 14APR2019 ---SAS/Secure Windows 14APR2019 ---SAS Enterprise Guide 14APR2019 ---SAS/ACCESS Interface to OLE DB 14APR2019 ---SAS Workspace Server for Local Access 14APR2019 ---High Performance Suite 14APR2019   3. proc product_status ; run;   For Base SAS Software ... Custom version information: 9.4_M1 Image version information: 9.04.01M1P120413 For SAS/STAT ... Custom version information: 13.1 For SAS/GRAPH ... 2 The SAS System 08:30 Monday, February 4, 2019 Custom version information: 9.4_M1 For SAS/ETS ... Custom version information: 13.1 For High Performance Suite ... Custom version information: 2.2   Can someone please let me know what the issue is?   Thank you,   ... View more