here is what I want to do: I have a list of numbers stored in a macro variable, I want to find out if this list of numbers in the macro variables are all the ids or a subset of ids in a dataset. I saw there is a vinarray function in sas help but the example is not well documented, I do not understand how it would work. of course, I could use scan to get a id at a time and then to look it up in the dataset but I think there got be a easier way. any suggestion? thank you very much in advance. ... View more

I am trying to append dataset ds1 to base. And, base has one extra variable v1 than ds1. If I just call proc append, then all obs appended to base will have a null v1. Here, I need to put a default value for v1 when appending ds1 to base. is there a way to set a default value for v1 while appending the observations in ds1 to base rather than append to base, and then update the base for those null values of v1? ... View more

I am on windows. When I create a library (e.g. testlib) and map it to a file directory on the file system (e.g. c:\dir ), the sub directory of c:\dir\subdir does not show up in the sas exploer as the sub lib of testlib. I wonder if there is a way so that I can have the sas explorer shows the same directory structure as the file system? I only need one level of nesting, at least be able to create a sub lib in a lib. I tried to libname testlib.subdir "c:\dir\subdir"; it doesn't work. Any suggestion or work around? thank you in advance. ... View more

I am trying to partition a input table and only want to go through the input table only once and based on the partition key to output to the table. I wonder if it is possible to output obs to a dynamic dataset name. what I plan to do is to sort the input dataset by the partition key variable, then output to a new dataset when a new partitionkey is detected. however, I could not find a way to specify a output dataset name dynamically. any suggestion would be appreciated. ... View more