Hi I have a small problem, I have a large data set and I want to take these values that have certain characters (in my case - prefixes). There are dozens of these prefixes so doing LIKE/CONTAINS each time does not only take space but is inefficient.. Prefixes usually look like that - NLLL - so 1 number and 3 letters. Is there a way to check for that pattern in like/contains coditions or just a way to have these conditions contain multiple values i.e. IN option with prefixes or a list of prefixes that could be checked instead of only one? Thanks in advance ... View more

Hi Is there a way to extract a name of a library label/catalog name? I don't want librefs but the name of each of the assigned libraries that show up after entering "Libraries" catalog. I basically what this: Also, is it possible to assign multiple libraries? Usually assigning works like that - %libname (libref=name); but that allows assigning only one at a time. Is it possible to do some kind of a list? Thanks in advance! ... View more

Hello I have a question. In my code I had a WHERE clause with IN operator and dozens of string values written inside the brackets. It wasn't very pleasant to look at, so I thought that it would be better to put these values inside a single variable and make the IN operator read them. My mainly idea was to use proc sql: Proc sql; select DISTINCT 'TABLE'n into :varlist separated by '", "' from USERSPDS.TABLE1; quit; %let varlist = &varlist; Proc sql; select DISTINCT 'LIBREF'n into :var2list separated by '", "' from USERSPDS.TABLE1; quit; %let var2list = &var2list; It seemed to work fine and values I wanted to put inside these two variables are actually inside but I have problem: where n1.name IN ("&varlist") and n1.libname IN ("&var2list");  <----  I thought that would work but I get an "error": Val1", "Val2", "Val3", "Val4", "Val5", "Val6", "Val7", "Val8", "Val9", "Val10                       ____    ____     ____    ____     ____    ____    ____    ____    ____                        49        49         49       49        49       49         49        49       49 NOTE 49-169: The meaning of an identifier after a quoted string may change in a future SAS release.  Inserting white space between              a quoted string and the succeeding identifier is recommended. That error is actually a NOTE but it stops my process.. Any idea how should I insert that white space? Thanks in advance! ... View more

So, I have a significant problem with proc compare. I have two datasets with the two columns. One column lists table names and the other one - names of variables which correspond to table names from the first column. I want compare values of one of them based on the values of first column. I somewhat made it work but the thing is that these datasets have different sizes due to additional values in one of them. Which means that some new variable was added in the middle of a dataset (new variable was added to a table). Unfortunately, proc compare compares values from two datasets horizontally and checks them against each other for values, so in my case it looks like this:     ds 1 | ds 2     cost | box_nr     other | cost_total As you can see, a new value `box_nr` was added to the second dataset that appears above the value  that I want it to compare variable `cost` to (`cost_total`). So I would like to know if it's possible to compare values (check for differences in character sequence) that have at least minimal similarity - for example 3 letters (cos) or if it's possible to just put values like `box_nr` at the end suggesting that they don't appear in a certain dataset. My code:     PROC Compare base=USERSPDS.MIzew compare=USERSPDS.MIwew         out=USERSPDS.result outbase outcomp outdif noprint;         id 'TABLE  HD'n;         where ;     run;     proc print data=USERSPDS.result noobs;        by 'TABLE  HD'n;        id 'TTABLE  HD'n;        title 'COMPARISON:';     run; ... View more