cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Jim_Ogilvie
‎09-27-2021
  • 39 Posts
  • 4 Likes Given
  • 2 Solutions
  • 3 Likes Received

Re: Oracle Library Issues

by Obsidian | Level 7 in Administration and Deployment
‎03-19-2020 12:33 PM
‎03-19-2020 12:33 PM
The libname including "username" threw an error.   However.....   Genius!   That proc sql worked, but only when I substituted "SAS_Service" for the name of the "Table Owner" (this was also provided by the Oracle DBA earlier).   I have never seen a library work in this way before, how would you us it in a SAS data step?   Also, do you have any idea how do set the libname up so I can browse the tables in the library tree?       ... View more

Re: Oracle Library Issues

by Obsidian | Level 7 in Administration and Deployment
‎03-19-2020 11:59 AM
‎03-19-2020 11:59 AM
Thanks Tom.   Yes these were my initial thoughts...   The Oracle DBA tells me that the schema has been set to the same value as the username.   I also understand that our system admin set up the System DSN, using the Oracle Client, at which point he needed to provide the credentials.   Thanks   Jim   ... View more

Oracle Library Issues

by Obsidian | Level 7 in Administration and Deployment
‎03-19-2020 11:28 AM
‎03-19-2020 11:28 AM
Hi all,   I am trying to complete set up of an ODBC library to an Oracle database.   My system admin has set up a System DSN (64-bit Oracle driver), which has been tested and returns the expected connection success message.   I have set up a libname statement that uses the System DSN, and the SAS log reports that it has been successfully assigned, but I can't see any tables/views...   libname ORADEV odbc dsn=Ora_Dev_DB password=XXXXXXXXXXX schema=SAS_SERVICE preserve_tab_names=yes;     "SAS_SERVICE" is the username set up for the connection by our Oracle DBA (I'm not 100% if schema should = this or something else).     Note: My two SAS Connect licences have been used on ODBC and PCFILES, I don't have a spare. ... View more

Re: list all the tables in the library

by Obsidian | Level 7 in SAS Programming
‎03-18-2020 11:59 AM
‎03-18-2020 11:59 AM
Hi,   Just saw this, whilst search for something related.   The most common reason for a library to be showing as empty in the explorer, even though you can query the tables in code, is that the "schema" option in the libname statement has not been set correctly of has been ommitted.   schema='dbo' worked for the MS SQL Server libraries I worked with previously.   Oracle is tricky, so you'll need to talk to you DBA's. ... View more

Re: Multiple search terms in SAS VA 8.3

by Obsidian | Level 7 in SAS Visual Analytics
‎03-13-2020 11:31 AM
‎03-13-2020 11:31 AM
You might be able to code up something that searched for multiple case_id's using "IN"...   But then you would use the other functionality we discussed above.     You could use as many search boxes as necessary...  ... View more

Re: Multiple search terms in SAS VA 8.3

by Obsidian | Level 7 in SAS Visual Analytics
‎03-13-2020 11:13 AM
‎03-13-2020 11:13 AM
Hi Matt,   If you implement as per the link, but use "Begin" in stead of "Contains",  I would then advise users to search by typing, 20200, for example.   This should then filter for 202001, 202002, 202003... 202009      If you had another search box implemented in the same way, you could do "searchbox1" or "searchbox2", allowing them to get two exact case_id, or one or two case_id ranges. ... View more

Re: Multiple search terms in SAS VA 8.3

by Obsidian | Level 7 in SAS Visual Analytics
‎03-13-2020 10:45 AM
‎03-13-2020 10:45 AM
Yes Matt, simply change the variable type of case_id from numeric to character.   If it is vital that case_id stays numeric (for other parts of the report), then just take a copy of it instead and change the copied variable's type to character, for use just on the pages where you want to search.     Once you have a character variable, this will work perfectly for you, I had the same thing running at my previous job. ... View more

Re: Multiple search terms in SAS VA 8.3

by Obsidian | Level 7 in SAS Visual Analytics
‎03-13-2020 08:15 AM
‎03-13-2020 08:15 AM
Hi Matt,   Sounds like a wildcard approach would give you the greatest flexibility.   You could use one search box and have your users either type the entire string, or if they want to see a range of cases, then use wildcards.   Have a read here for how to implement:   https://communities.sas.com/t5/SAS-Visual-Analytics/VA-quot-contains-quot-search-in-input-text-box/td-p/361956    Doing this with 2 search boxes would provide even greater flexibility (but with the cost of increased logic). ... View more

Re: Lat/Long stored as hex

by Obsidian | Level 7 in SAS Programming
‎03-12-2020 11:51 AM
‎03-12-2020 11:51 AM
Also work brilliantly - thanks Tom. ... View more

Re: Lat/Long stored as hex

by Obsidian | Level 7 in SAS Programming
‎03-12-2020 07:48 AM
‎03-12-2020 07:48 AM
Chris - that's perfection.   Many thanks,   Jim ... View more

Re: Lat/Long stored as hex

by Obsidian | Level 7 in SAS Programming
‎03-12-2020 05:40 AM
‎03-12-2020 05:40 AM
I have heard back from the vendor (colleague of the original tech support guy) - who passed me some Oracle SQL, that they use to carry out the conversion.   I have built the following SAS function, which carries out the same work:   proc fcmp outlib=work.funcs.utils; function decode_hex_coord(coord $); num = input(coord,hex16.); if num >= 2**32 / 2 then return(num - (2**32)/1000000); else return(num/1000000); endsub; options cmplib=work.funcs; data _null_; test_lat = decode_hex_coord('030ED8FC'); test_lon = decode_hex_coord('0007A4A4'); put test_lat ", " test_lon; run; Output: 51.3047 , 0.5009   Confirmed as correct in googlemaps.     I have also found that that one of those original hex codes was a user entry error!!! Really unhelpful - sorry.     Thanks for you help all. ... View more

Re: Lat/Long stored as hex

by Obsidian | Level 7 in SAS Programming
‎03-11-2020 04:45 AM
‎03-11-2020 04:45 AM
Thank for your input guys.   Unfortunately, the vendors' technical support person wasn't able to shed any light on this, said he needed to discuss it with a colleague's and has now gone on holiday for 2 weeks!     Chris,   This calculation works great for that particular one, but when I run the other hex value through the same processing, I get:   =-4243.581795     I presume that a little "if-then" logic would fix this, but I do not know what condition to check for.     ... View more

Re: Lat/Long stored as hex

by Obsidian | Level 7 in SAS Programming
‎03-10-2020 12:19 PM
1 Like
‎03-10-2020 12:19 PM
1 Like
Hi,   Because lat/long is always relative to either the Greenwich Meridian or the Equator, you would never have 360 degrees, rather, you would have -180 or 180 as the farthest point from these reference lines...     ... View more

Lat/Long stored as hex

by Obsidian | Level 7 in SAS Programming
‎03-10-2020 10:41 AM
‎03-10-2020 10:41 AM
  Hi all,   I need to convert a series of latitudes and longitudes, which are stored as hex, into standard lat/long notation, for example:   Long: 0310149C Lat:    FFFDFD28   Should convert to something like this:   51.386396 -0.131605   I've tried:   data _null_; lat = input('0310149C',hex16.); long = input('FFFDFD28',hex16.); put lat; put long; run; Which gives:   51385500 4294835496   As you can see, the first is correct, but the second conversion is not. I'm sure this has to do with decoding the signed part of these numbers, but can't find a work around.   Thanks in advance   Jim ... View more

Re: PROC GMAP - Is a network type map possible?

by Obsidian | Level 7 in Graphics Programming
‎02-07-2020 10:35 AM
‎02-07-2020 10:35 AM
Many thanks Chris.     Awaiting input from others in anticipation...... ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-27-2021 02:34 PM
Likes given to
View All
Likes from
Quick links