Prev: SASUSER.TEMPLAT
Next: problems selecting subst
From: Ya Huang on 26 Jan 2010 18:47
Hi there,

I'm quite surprised so see that proc sql accepts quoted name as
table name, we can even reference the quoted named dataset in
other proc:

1 proc sql;
2 create table "quotednm" as
3 select *
4 from sashelp.class
5 ;
NOTE: Table quotednm created, with 19 rows and 5 columns.

6
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds


7 proc print data=quotednm;
ERROR: File WORK.QUOTEDNM.DATA does not exist.
8 run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

9


10 proc print data="quotednm";
11 run;


The difference is that quoted dataset in the a libname called
wc000001.

This might have some good implication.

Ya
 | 
Pages: 1
Prev: SASUSER.TEMPLAT
Next: problems selecting subst