About tampham92

tampham92 · ‎08-04-2021

It said the ODBC engine cannot be found ERROR: The ODBC engine cannot be found.

tampham92 · ‎08-04-2021

QUESTIONS: 1. Could it be a timing issue? When did you set up the ODBC DSN? Have you tried opening a fresh SAS session and trying your code there? I doubt that's the issue, but maybe. - I set it up yesterday and I expect it should work right away 2. What are your driver options? I see "SQL Server" in your ODBC set up. I have "SQL Server Native Client 11.0" in mine. Are there any other driver options available to you? - I have ODBC, SQL Server and SQL Server Native Client 11.0. Which one should I use preferably? 3. Is there anyone else in your shop that has the connection working? Perhaps you could ask them about what their settings are for the DSN that they set up in the ODBC Data Source Administrator - Not at the moment

tampham92 · ‎08-04-2021

what do I need to put for server?

tampham92 · ‎08-04-2021

tampham92 · ‎08-04-2021

I running it on a SAS server. I got this error when I used "connect to ODBC"

tampham92 · ‎08-03-2021

Hello, I am trying to connect to MS SQL Server data table through SAS and I ran into this issue and not sure what it means. I ran the following code and got issue proc sql; connect to SQLSVR as mydb (datasrc="SQL_SAS" user="XXX" password="XXX"); select * from connection to mydb (select * from DATA_TABLE); quit; run; 23 GOPTIONS ACCESSIBLE; 24 proc sql; 25 connect to SQLSVR as mydb (datasrc="SQL_SAS" user="XXXXXX" password=XXXXXXXXXX); ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 26 select * from connection to mydb 27 (select * from DATA_TABLE); ERROR: The MYDB engine cannot be found. ERROR: A Connection to the mydb DBMS is not currently supported, or is not installed at your site. 28 quit; I already added that SQL_SAS datasource into the ODBC Datasouce Administrator but it still did not work. Thank you so much for any help.

tampham92 · ‎08-02-2021

Hello, I am trying to connect to MS SQL Server data table through SAS and I ran into this issue and not sure what it means. I ran the following code and got issue proc sql; connect to SQLSVR as mydb (datasrc="SQL_SAS" user="XXX" password="XXX"); select * from connection to mydb (select * from DATA_TABLE); quit; run; 23 GOPTIONS ACCESSIBLE; 24 proc sql; 25 connect to SQLSVR as mydb (datasrc="SQL_SAS" user="D113338" password=XXXXXXXXXX); ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Data source name not found and no default driver specified NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 26 select * from connection to mydb 27 (select * from DATA_TABLE); ERROR: The MYDB engine cannot be found. ERROR: A Connection to the mydb DBMS is not currently supported, or is not installed at your site. 28 quit; I already added that SQL_SAS datasource into the ODBC Datasouce Administrator but it still did not work. Thank you so much for any help.

tampham92 · ‎03-09-2021

My Input dataset is relative large to attached here. Below is my proc univariate. The data is organized like an example below ods graphics / height=1000px width=700px; GOPTIONS htext=1 cells; SYMBOL v=SQUARE c=BLUE h=1 cells; PATTERN v=SOLID; TITLE; TITLE1 "Distribution analysis of: Rate"; proc univariate data=test; where type in ('Fed_Funds'); class scenario; var Rate; /* computes descriptive statisitcs */ histogram Rate / endpoints= -6 to 15 by 0.5 nrows=5 normal (color=red) CFRAME=CXEAEAEA CAXES=BLACK WAXIS=1 CBARLINE=BLACK CFILL=BLUE PFILL=SOLID ; INSET MEAN STD SKEWNESS KURTOSIS MAX MIN Q1 MEDIAN Q3 / POSITION=NE CTEXT=BLUE CFILL=CXD3D3D3 CFRAME=BLACK CHEADER=BLACK HEIGHT=1.5 format=10.2 ; ods select histogram; /* display on the histograms */ run; scenario type path Date Rate LB_-200bps Fed_Funds 1 2/28/2021 0.26 LB_-200bps Fed_Funds 2 3/31/2021 0.23 LB_-200bps Fed_Funds 3 4/30/2021 0.5 LB_-50bps Fed_Funds 1 2/28/2021 0.6 LB_-50bps Fed_Funds 2 3/31/2021 0.75 LB_-50bps Fed_Funds 3 4/30/2021 0.8

tampham92 · ‎03-08-2021

I am using proc univariate to produce the histogram plot and I am trying to reduce the size for both horizontal and vertical axis values and the size for the tile for each class (highlight in yellow) I try to define htext in goptions statement but looks like it does not work Thanks.

tampham92 · ‎09-16-2019

I use the same proc surveyselect here as you have. I even tried proc sql combining with "having ranuni(xxx) between 0.45 and 0.55" and the amount of time it takes too run is too long

tampham92 · ‎09-16-2019

Hi, I have a very large data set (up to 5M observations) ranging from 2004 through 2019 by month. I would like to randomly select 10% of my data to generate a insample data for modeling. Since the dataset is very large, a normal proc survey select takes forever. I am wondering whether I can use ds2 to perform random sample selection. Thanks.

tampham92 · ‎03-14-2019

Hello, I am wondering whether I can change the background color of the SAS EG Program window.

tampham92 · ‎03-12-2019

So if I am using EG at work, I just need to download R on my laptop and follows the steps described above; I would be able to use enable R language correct? Or I need to reach out to SAS Admin. If I reach out to them, what should I say to have this setup? Thanks.

tampham92 · ‎03-12-2019

I like Seleção Brasileira and FC Barcelona as well. My all time favorite is Ronaldo Luís Nazário de Lima

tampham92 · ‎02-22-2019

I moved the Global statement into the loop and it ran. However, when I tried to test where the value is store using %put statement (%put &beta_up&v1) it just returned beta_up&v1. Do you know why?;

Online Status	Offline
Date Last Visited	‎01-09-2024 01:08 AM

Re: Finding Physical Location of a File under Users Folder

Re: How does retain work in sas?

Re: How does retain work in sas?

Re: How does retain work in sas?

How does retain work in sas?

How can I create a variable that enumerates after the criteria is met?

Make PROC SQL display rows with missing values

Re: Connect to MS SQL Server through SAS

Re: Connect to MS SQL Server through SAS

Re: Connect to MS SQL Server through SAS

SGF getaway day

Re: Connect to MS SQL Server through SAS

Re: Connect to MS SQL Server through SAS

Re: 10 Things You Don't Know About Me: Thiago De Souza

Re: Connect to MS SQL Server through SAS

Re: Connect to MS SQL Server through SAS

Re: Connect to MS SQL Server through SAS

Re: Connect to MS SQL Server through SAS

Re: Connect to MS SQL Server through SAS

Connect to MS SQL Server through SAS

Re: Connecting to MS SQL Server

Re: Change the font size for vertical axis

Change the font size for vertical axis

Re: Random Variable selection with DS2

Random Variable selection with DS2

How to change the color of Program windows in SAS Enterprise Guide

Re: Run R code inside SAS easily

Re: 10 Things You Don't Know About Me: Thiago De Souza

Re: SELECT INTO WITHIN DO LOOP AND MACRO VARIABLE

SAS Global Forum 2019