Hi,   So the PUT can print a data variable and its value to the log and the %PUT can do the same for Macro variables. Is there a way to do this for libname vars?   For example, if I have a libname defined as the following: libname x "%SYSGET(dir)"; If the above code is written as: %let x = %sysget(dir); I can get the value of x by using %PUT x; What can I do if %LET is replaced with LIBNAME? I know in a SAS log, it'll print out the definition of a libname defined in the program. I guess my question is, if you can print a Macro variable or a SAS data step variable, can you do something similar for a libname var?   Thanks ... View more

Hi,   If I have two datasets: dataset ONE: ID fruits 1    apple 1    peach 2   orange 3   pineapple   dataset TWO: ID a b c d e   dataset WANT: ID fruits a    apple a   peach b   orange c   pineapple   So, I am trying to replace all the values in dataset ONE for column ID from the column ID in dataset TWO. However, the difficult part for me is that there are multiple rows with the same ID in dataset ONE. For those repeating IDs, they need to be replaced with the same ID from dataset TWO. Like the example shown above, in dataset WANT, there should be two a's since there are two 1's. How do I do that?   Thanks! ... View more

Hi,   The following example is from the SAS Help Center:   %let x=1; %let items=2; %macro test(val); data _null_; call symputx('items', ' leading and trailing blanks removed ', 'L'); call symputx(' x ', 123.456); run; %put local items &items; %mend test; %test(100) %put items=!&items!; %put x=!&x!; Question: Why is there a parameter val used for the macro test? What does that 100 do when used for val? I couldn't tell from the log.    Thanks!   ... View more

Hi,   Here are two examples from the SAS Help Center:   data u1(keep=x); seed=104; do i=1 to 5; call ranuni(seed, x); output; end; call symputx('seed', seed); run; data u2(keep=x); seed=&seed; do i=1 to 5; call ranuni(seed, x); output; end; run; Question 1: The call symputx in the u1, is used for the data step in u2?   If I modify the code from u1 to the one below: data u1(keep=x); do seed=1 to 5; call ranuni(seed, x); output; end; run; Question 2: Why doesn't the modified code provide 5 different numbers? Each time the seed has a new value, which is like the seed in dataset u2, except it's not a macro variable.   Thanks!   ... View more

Hi,   If I have 50 datasets in a directory, all with the same format, for example,  dataset1: ID x y 1    a  apple 2   b  banana 3   c  orange   dataset2-dataset50 all have the same variables, ID, x, and y. How do I find datasets that have x = c? Let's assume out of all 50 datasets, only dataset1 and dataset 15 have records with x = c. Is there a way to look through all datasets and check for a value of particular variable and return the name of the datasets?   Thanks! ... View more

Hi,   Here is the layout for the first dataset with the ID column that I want to replace: ID      value 123     01 123     02 123     03 130     01 131      01 131      02 133      01 136      01 136      02 136      03 Please note that the ID will change once the Value column starts at 01 again     Here is the second dataset with the ID column that I want: ID 1 3 5 9 15     The updated dataset should be the following: ID      value 1        01 1        02 1        03 3       01 5       01 5       02 9       01 15      01 15      02 15      03     Thanks ... View more