Hi all. I would like to ask you about search patterns in text ? how to search for a particular keyword : left private home or left side private home 1) between keyword1 'title:' X and keyword2 'builder :' 1A) if found , assign a value home=left private 2) skip text in middle and search after the keyword more information: for left floor1 or left 1floor  ( sometimes written 1floor or floor1) 2A) if found , assign to the variable: SIDE the value left ( or right) and the value 1floor to the variable floor  ( the number of flours could vary from 0 to 10) here is the text for example: and  ( if possible).. 3) if in the first task home=left private and SIDE = right (missmatch of sides ..) add a mention to the variable missmatch=problem Hello this is some text title : great news here <-- first part of the exercise new beautiful left private home <-- this is the scope to start with builder: a new company constructed the home blablbablablbablablbablablbablablba some text ..... for more information: you can contact to acquire left floor1 Mr. smith, or Mr John I'm trying to figure out how to use RE and internal SAS F to search for text...that is in variables, I'll have to put all in a loop afterwards.. Thank your response   ... View more

Hi all, I would like to ask you how to classify *.txt files in Viya based on rules, ex classify them as OB1 if the text Right 1, OB2 if the text RIGHT 1 and UP 1 is found, NP2 if neither Right 1 and UP 1 were found...   Thank you for your support. Sincerely.  ... View more

Hi All, I have exported data from Oracle database into Sas table, after I've tried to lead the data into CAS in Viya , i got this error message   The exported table contains a column with rows of Blobs, representing PDF's intended to be analyzed in Viya:: ERROR: BASE Data Connector, Cross Environment Data Access (CEDA) translation failed. Some character data was lost during transcoding while loading the table. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. The charMultiplier= import option may prevent the error. ERROR: BASE Data Connector failed.     In other words how to load a sas table with blobs into CAS without getting this message ? another question is how to deal with blobs ( contained in columns ) with Viya if there is no solution to this ? Thank you for your response.     ... View more

Hi Dear All.    I would like to ask you if there is a command ( a loop ?)  to duplicate (with contents) an oracle database and put all created tables with same name in a library. the other question is how to save into a server and not local machine ( EG is installed in a local machine and database and the output should be on a server ) ? Thank you for your comments. ... View more