Hi, @brianaullman,   Just to clarify, this is the same presentation as in https://communities.sas.com/t5/SAS-Community-Events/Chatbots-in-Microsoft-Teams-Real-time-Object-Detection-on-Docker/ev-p/759990, yes?   The above linked Event, for those who are interested, has a direct link to YouTube.   @brianaullman, a direct link to LinkedIn might be a nice value add on this post (hint, hint).  It's probably just as simple as going to LinkedIn and finding SAS, but a direct link is really helpful to lazy sloughs like me.  🙂   Jim ... View more

OK, I think I might have something for you.  Below is some SAS code.  Below the code are the results.  This code will parse out the values you're looking for no matter the word order and no matter placement.  In other words if the type of car (automatic vs. manual) comes before the model of the car (Prius, Camry, etc.), it would still be picked up.     This code requires that you define a table of the cars (or whatever it really is) that you're looking for as well as the possible types and then does a double array search of each line of data.  Note that if a definition is omitted, e.g. the Volt, "unknown" will be returned.   IMPORTANT: This code does not allow embedded blanks.  If you wanted, for example "Accord LX", you would need to code "Accord_LX"  (or "Accord-LX") in your both data and in your table definitions.   See what you think.     Jim   DATA Have; INFILE DATALINES TRUNCOVER; INPUT Data_To_Examine $CHAR128.; ; DATALINES; Camry red Manual Corolla Blue Automatic Yugo (Yugoslavia) Manual Tiguan Germany Automatic Camry Blue (Japan) - Manual Prius (America) Toyota Automatic Volt (US) Automatic Blue Automatic Honda Civic 4-Door Gray Manual Accord LX 2012 ; RUN; DATA Cars_Table; INFILE DATALINES TRUNCOVER; INPUT Car $CHAR32.; ; DATALINES; Camry Corolla Prius Accord Civic ; RUN; PROC SQL NOPRINT; SELECT COUNT(Car) INTO : Car_Count TRIMMED FROM Cars_Table; QUIT; %PUT NOTE: &=Car_Count; PROC TRANSPOSE DATA=Cars_Table OUT =Cars_Array (DROP=_:) Prefix=Car_ ; Var Car; RUN; DATA Types_Table; INFILE DATALINES TRUNCOVER; INPUT Type $CHAR32.; ; DATALINES; Automatic Manual ; RUN; PROC SQL NOPRINT; SELECT COUNT(Type) INTO : Type_Count TRIMMED FROM Types_Table; QUIT; %PUT NOTE: &=Type_Count; PROC TRANSPOSE DATA=Types_Table OUT =Types_Array (DROP=_:) Prefix=Type_ ; Var Type; RUN; DATA Want; DROP _:; DROP Car_1 - Car_&Car_Count; DROP Type_1 - Type_&Type_Count; IF _N_ = 1 THEN DO; SET Cars_Array; SET Types_Array; END; ARRAY Cars {&Car_Count} $32 Car_1 - Car_&Car_Count; ARRAY Types {&Type_Count} $32 Type_1 - Type_&Type_Count; SET Have; LENGTH Car_Var $32; LENGTH Type_Var $32; Car_Var = 'Unknown'; Type_Var = 'Unknown'; DO _i = 1 TO &Car_Count; IF INDEX(UPCASE(Data_To_Examine), UPCASE(STRIP(Cars{_i}))) THEN DO; Car_Var = Cars{_i}; DO _j = 1 TO &Type_Count; IF INDEX(UPCASE(Data_To_Examine), UPCASE(STRIP(Types{_j}))) THEN DO; Type_Var = Types{_j}; END; END; END; END; RUN; Results:   ... View more

Can you show us actual data?  If the data is confidential somehow, then you can substitute wombat, koala, kangaroo, eucalyptus, etc. for the parts that are confidential.  Otherwise, I don't think we have a clear idea of what it is that you're looking for, and it's going to be really difficult for us to help.   Jim ... View more

Have you tried creating a SAS view of AKAIKE.TEST_DOWNLAOD?  Maybe if you used a view as an intermediary, it would iron out the odd problem.  I don't know that this will work, but it's worth a shot.   When you run, would you try turning on the following options?  These are 9.4 options; I'm not sure they'll all work with Viya, but let's give it a shot.  This will add additional messages to the log which may give us a clue as to what's going on.  If one option or another doesn't work, comment it out and use the rest. OPTIONS SASTRACE = ",,,ds"; OPTIONS SASTRACELOC = SASLOG; OPTIONS NOSTSUFFIX; OPTIONS MsgLevel = I; OPTIONS DEBUG = DBMS_SELECT;   Jim ... View more

@RandoDando wrote: I have another idea. From my prior post above showing the available add-ins and drivers for my SAS server, would I be able to connect to MS Access? I don't see "Access" in the list specifically, but does having other Office products there include that? Yes, you should be able to connect to Access.  If nothing else, you can do a Proc Import.   So, export from SF to Access and then read Access from SAS?   Jim ... View more

Well, you have to understand that you're asking on a SAS focused forum.  We're all SAS guys, so we may be a bit biased.    I have read that R is quite popular in academia, but that's about all I know.    I've worked with other languages that take a lot more programming to get things done like Assembler, C, Java, etc.  Even though Java is more modern, I stuck with SAS because SAS does so much work for me.  It's much faster at least for me to write in SAS.     Now, that's the reason I've stuck with SAS, but that doesn't tell you much about R unfortunately.  I just don't have much depth with R other than a few elementary programs.   That said, I do look at the Tiobe and Red Monk indices regarding the popularity of programming languages.    On the Tiobe Index, R is 14, and SAS is 21.  A language that you didn't mention that has shown tremendous growth in recent years is Python, which is currently #2 on the Tiobe index.  Python has a number of statistical packages and now rivals R and SAS in functionality from what I've read.  The CEO of Tiobe has some interesting things to say about the popularity of R; see the preceding link.  Another up and coming statistical language is Julia, currently at #26.  Julia is a project out of MIT whose goal is to be a language that can do statistical processing, machine learning, etc. but be very fast and efficient.  In other words, Julia strives for all of the features of Python, R, and SAS while having the performance of something like C or C++.  I'd say Julia is one to watch, but who am I?   The Red Monk index lists Python at #2 and R at #13.  Red Monk only lists the top 20; SAS isn't mentioned.   Popularity isn't everything, and how popularity is determined is the subject of no small amount of debate, but these indices are none-the-less interesting.  They're at least something to throw in the mix.     Sorry I can't be more definitive,   Jim ... View more