Hi:
The LIBNAME and MEMNAME should always be in caps...when you're querying any of the dictionary tables (dictionary.columns, etc). So your memname should be CLEAN8. The libname is not C:\ ... remember that a libname is just a nickname for a directory/folder location on your disk. So in this case:
[pre]
libname wombat 'c:\temp\mydata';
[/pre]
WOMBAT is the nickname given to the directory path c:\temp\mydata. The 2 level name of a SAS dataset in this location will be WOMBAT.xxxxxxxx where the first level of the name is the nickname that is in the LIBNAME statement. The second level of the name (xxxxxxxx) will be the SAS dataset name.
Let's say that I go out to the directory and look in c:\temp\mydata folder and I find 3 SAS datasets -- I can tell they're SAS datasets (in version 8 and 9) because they will have a file extension of SAS7BDAT...so I have these files:
c:\temp\mydata\account.sas7bdat
c:\temp\mydata\members.sas7bdat
c:\temp\mydata\updates.sas7bdat
The 2 level name of each of these files would be:
WOMBAT.ACCOUNT
WOMBAT.MEMBERS
WOMBAT.UPDATES
Notice how the libname/nickname 'WOMBAT' takes the place of the high level directory path and the data set name, ACCOUNT or MEMBERS or UPDATES becomes the second level of the 2-level name.
If you are creating a temporary data set, and you refer to it in your program by a ONE level name...something like this:
[pre]
proc print data=clean8;
[/pre]
then the "official" LIBNAME of your data set is 'WORK' and the 'official" 2-level name of your file is WORK.CLEAN8. So in your case, you might have a query with:
where libname = 'WORK' and memname='CLEAN8';
You say that your test sas data set is in c:\ -- look in your program for a LIBNAME statement, or if you don't have one, try this:
[pre]
libname mydata 'c:\';
proc contents data=mydata._all_;
title 'What SAS datasets are in C:\';
run;
[/pre]
Now, look in the output from the PROC CONTENTS to make sure that your file, CLEAN8 is in that directory location. If it IS in the list, then your query would be:
[pre]
where libname = 'MYDATA' and memname='CLEAN8';
[/pre]
If your CLEAN8 file is not in the root directory, then you might try using Windows Explorer to search for it on your C: drive until you find it. The Windows name of your file would be: clean8.sas7bdat -- and, the directory location where you find it is the location you'd use in your LIBNAME statement.
For more help with this question, you might consider contacting Tech Support or posting to the non-ODS forum since you're now venturing into the world of more general SAS questions like using LIBNAME statements, using macro variables and/or using SQL.
cynthia