@shree wrote: I have a folde location where there are n numbers of datasets . 1)I want to get the list of all the datasets with common string as xx in one table and the datset with common string as yy in other table.   Is the string XX in a dataset name? A variable Name? A variable Label? The value of a variable? How about YY? What you are looking for depends on where you will have to look. @shree wrote:   2)I want to append the data of all the datasets of xx table to one oracle table and all the data of datasets of yy table in other oracle table.   In SAS dataset = table. A table does not have datasets. And now you bring in Oracle. Was that supposed to be in the first part of the question?   I think you need to rethink your requirements and then be more explicit about the 1) the environment you need to search (what I can find in SAS about SAS data sets may not be anywhere near as simple to find out about Oracle tables/variables/ metadata) 2) Exactly what you are searching - metadata, names (and of what) or values 3) Provide some examples of what you are searching for and what the results should actually look like. Example data should be in form of datastep code to complete describe any variables involved. ... View more