Thanks Scott for your reply.
I didn't quite understand the suggestions..I will ry to read up the documentation little bit and see if I can get..
Meanwhile I tried a simple SAS program which has a PROC SQL which references a
data set directly by specifying its location...
--------------------------------------------------------------------------------
ODS CSV FILE = 'C:\DAG\SAS\Tests\CSV Files\TestDirRef2.csv';
proc sql DATA = 'C:\DAG\SAS\Tests\state_extract';
select * from dictionary.tables where memname='STATE_EXTRACT';
run;
ODS CSV CLOSE;
-------------------------------------------------------------------------------------------
I am getting the following error..
5 proc sql DATA = 'C:\DAG\SAS\Tests\state_extract';
----
22
202
ERROR 22-322: Syntax error, expecting one of the following: ;, BUFFERSIZE, CHECK, CODEGEN, CONSTDATETIME, DOUBLE, DQUOTE, ERRORSTOP, EXEC, EXITCODE, FEEDBACK, FLOW, INOBS, IPASSTHRU, LOOPS, NOCHECK, ODEGEN, NOCONSTDATETIME, NODOUBLE, NOERRORSTOP, NOEXEC, NOFEEDBACK, NOFLOW, NOIPASSTHRU, NONUMBER, NOPRINT, NOPROMPT, NOREMERGE, NOSORTMSG, NOSTIMER, NOTHREADS, NUMBER, OUTOBS, PRINT, PROMPT, REDUCEPUT, REDUCEPUTOBS, REDUCEPUTVALUES, REMERGE, SORTMSG, SORTSEQ, STIMER, THREADS, UNDO_POLICY.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
Any ideas??
Similar program with libname and data step works
Here is the working program
-----------------------------------------------------------------------------------------------------
libname sasdata2 'C:\DAG\SAS\Tests\';
data work;
set sasdata2.STATE_EXTRACT;
run;
ODS CSV FILE = 'C:\DAG\SAS\Tests\CSV Files\Test1.csv';
proc sql;
select * from dictionary.tables where memname='STATE_EXTRACT';
run;
ODS CSV CLOSE;
------------------------------------------------------------------------------------------------------