09-01-2015
mbenedet
Calcite | Level 5
Member since
07-31-2012
- 15 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by mbenedet
Subject Views Posted 1655 08-30-2013 09:34 AM 933 08-30-2013 09:30 AM 1655 08-29-2013 03:46 PM 1655 08-29-2013 03:23 PM 1804 08-29-2013 03:12 PM 1001 08-29-2013 02:51 PM 745 08-01-2012 08:54 AM 823 07-31-2012 04:49 PM -
Activity Feed for mbenedet
- Posted Re: ODBC connections are gone after upgrade to SAS EG 5.1 on SAS Enterprise Guide. 08-30-2013 09:34 AM
- Posted Re: ODBC connections after upgrade to SAS EG 5.1 are gone on SAS Programming. 08-30-2013 09:30 AM
- Posted Re: ODBC connections are gone after upgrade to SAS EG 5.1 on SAS Enterprise Guide. 08-29-2013 03:46 PM
- Posted Re: ODBC connections are gone after upgrade to SAS EG 5.1 on SAS Enterprise Guide. 08-29-2013 03:23 PM
- Posted ODBC connections are gone after upgrade to SAS EG 5.1 on SAS Enterprise Guide. 08-29-2013 03:12 PM
- Posted ODBC connections after upgrade to SAS EG 5.1 are gone on SAS Programming. 08-29-2013 02:51 PM
- Posted Re: Counting records in SAS on SAS Programming. 08-01-2012 08:54 AM
- Posted Counting records in SAS on SAS Programming. 07-31-2012 04:49 PM
08-30-2013
09:34 AM
Hi SASKiwi...what we are doing is creating the connections through the ODBC Admin 32-bit driver connection. We are using all of the instructions that they provided with regards to the ODBC setup and making sure we use our particular Libraries or Servers, but no luck. We are basically trying to access those ODBC connections through Microsoft Access to run some of our database queries. I know that they are working on a solution for us, but I am trying to get it resolved sooner. We have certain work to be processed and under some deadlines that are in jeopardy because of this issue.
... View more
08-30-2013
09:30 AM
Hi...yes, I used the same name as specified within the SAS program
... View more
08-29-2013
03:46 PM
Thanks Chris. I checked the configuration details and it says it is not running as a 64-bit process.
... View more
08-29-2013
03:23 PM
Hi Chris...no, we are using 32-bit.
... View more
08-29-2013
03:12 PM
Our company recently upgraded to SAS EG 5.1 and in the process, our ODBC connection that we used to utilize through Microsoft Access are now gone and we need to rebuild them. We have instructions on how to rebuild them, but is there something different after the upgrade as when we have tried, the connections are not working.
... View more
08-29-2013
02:51 PM
Our company recently upgraded to SAS EG 5.1 and in the process, our ODBC connection that we used to utilize through Microsoft Access are now gone and we need to rebuild them. We have instructions on how to rebuild them, but is there something different after the upgrade as when we have tried, the connections are not working.
... View more
08-01-2012
08:54 AM
Thank you for your reply. I copied the code and pasted below for what I have so far and all it does is group the data by Physician Association with their total member count. Are you saying I should add all of the code in your reply (starting with proc format library=work; to the end run; statement) to the bottom of my code to make it work? %_eg_conditional_dropds(WORK.QUERY950); PROC SQL; CREATE TABLE WORK.QUERY950 AS SELECT DISTINCT SF_PROF_MEMBERDATA_201206.activity_date, SF_PROF_MEMBERDATA_201206.master_ipa, SF_PROF_MEMBERDATA_201206.sf_lob FROM SERVFUND.SF_PROF_MEMBERDATA_201206 AS SF_PROF_MEMBERDATA_201206 GROUP BY SF_PROF_MEMBERDATA_201206.activity_date, SF_PROF_MEMBERDATA_201206.master_ipa, SF_PROF_MEMBERDATA_201206.sf_lob; QUIT;
... View more
07-31-2012
04:49 PM
Hi everyone...sorry for the simplistic question, but I am a brand new (and I do mean new!) user to SAS. Just trying to pull some data and create an output showing number of records in each category. Example of data to be pulled: Activity Date Line of Business Physician Association Member Count When I retrieve the data and sum by Member Count for each Physician Association, I then need to know how many of those Physician Associations fall under the following categories: 0 - 100 members 101 - 500 members 501 - 1000 members 1001 - 5000 members 5001 or greater Is there a simple way to modify the query to accomplish this task? Mike
... View more