Interesting finding: Proc SQL create quoted name dataset!
in [SAS]
|
Prev: problems selecting subst
Next: problems selecting subst
From: "Huang, Ya" on 26 Jan 2010 19:45 Thanks Art, You are right, I was aware of the full path for dataset, just failed to link my "finding" with to it, since there is no "path" in my quote. Like you said, it is indeed created in my default folder when the "path" is omitted. Ya -----Original Message----- From: Arthur Tabachneck [mailto:art297(a)NETSCAPE.NET] Sent: Tuesday, January 26, 2010 4:21 PM To: SAS-L(a)LISTSERV.UGA.EDU; Huang, Ya Subject: Re: Interesting finding: Proc SQL create quoted name dataset! Ya, We've always been able to create SAS datasets by specifying the full path in quotes (rather than specifying a libname). I think, in the present case, you are just creating a file called quotednm in your default directory (probably c:\Documents and Settings\yhuang or something quite similar). Art --------- On Tue, 26 Jan 2010 18:47:24 -0500, Ya Huang <ya.huang(a)AMYLIN.COM> wrote: >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
From: Arthur Tabachneck on 26 Jan 2010 19:21 Ya, We've always been able to create SAS datasets by specifying the full path in quotes (rather than specifying a libname). I think, in the present case, you are just creating a file called quotednm in your default directory (probably c:\Documents and Settings\yhuang or something quite similar). Art --------- On Tue, 26 Jan 2010 18:47:24 -0500, Ya Huang <ya.huang(a)AMYLIN.COM> wrote: >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
From: Tom Abernathy on 26 Jan 2010 20:59 On Jan 26, 7:21 pm, art...(a)NETSCAPE.NET (Arthur Tabachneck) wrote: > We've always been able to create SAS datasets by specifying the full path > in quotes (rather than specifying a libname). > > Art We haven't ALWAYS been able to use quoted names. It still doesn't work in SAS 6.12. - Tom 1 data 'test612'; --------- 200 2 do i=1 to 10; output; end; 3 run; ERROR 200-322: The symbol is not recognized. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DATA1 may be incomplete. When this step was stopped there were 0 observations and 1 variables.
From: Arthur Tabachneck on 26 Jan 2010 23:36 Tom, Always (as far as I can remember)!. Limited recollection is one of the benefits of getting older. Someday you'll understand. Art ----------- On Jan 26, 8:59 pm, Tom Abernathy <tom.aberna...(a)gmail.com> wrote: > On Jan 26, 7:21 pm, art...(a)NETSCAPE.NET (Arthur Tabachneck) wrote: > > > We've always been able to create SAS datasets by specifying the full path > > in quotes (rather than specifying a libname). > > > Art > > We haven't ALWAYS been able to use quoted names. It still doesn't work > in SAS 6.12. > > - Tom > > 1 data 'test612'; > --------- > 200 > 2 do i=1 to 10; output; end; > 3 run; > > ERROR 200-322: The symbol is not recognized. > > NOTE: The SAS System stopped processing this step because of errors. > WARNING: The data set WORK.DATA1 may be incomplete. When this step > was stopped > there were 0 observations and 1 variables.
From: montura on 27 Jan 2010 07:20
The best impliction woul be unreadable code - great for job security, providing you never want a promotion. |