LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (August 2010, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 31 Aug 2010 20:48:05 -0400
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: Most recent input data set
Comments: To: Daniel Nordlund <NordlDJ@DSHS.WA.GOV>

Dan,

What do you get if, for the second put statement, you use: %put &_VTtableLabel.';

i.e., with a single quote between the period and semi-colon?

Art --------- On Tue, 31 Aug 2010 17:44:51 -0700, Nordlund, Dan (DSHS/RDA) <NordlDJ@DSHS.WA.GOV> wrote:

>> -----Original Message----- >> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of >> Arthur Tabachneck >> Sent: Tuesday, August 31, 2010 5:18 PM >> To: SAS-L@LISTSERV.UGA.EDU >> Subject: Re: Most recent input data set >> >> Paul, >> >> I accidentally made that find running 9.1.3 M3 on a Windows 2003 >> server. >> >> Art >> >> P.S. But, I'll agree, that it MAY not have existed (or at least I >> didn't >> know about it) on my first SAS system in 1974. :) >> --------On Tue, 31 Aug 2010 16:45:55 -0700, Choate, Paul@DDS >> <Paul.Choate@DDS.CA.GOV> wrote: >> >> >Nice Art. >> > >> >&_VTtableName and &_VTtableLabel must be SAS 9.2 feature - we did't >> have >> that back in 2004 when *my* SAS software was written. >> > >> >CrDate MoDate are available from dictionary.tables or sashelp.vtable - >> but no accessed datetime is made available (in 9.13), which could be >> used >> to select the post recently accessed dataset. >> > >> >Paul Choate >> >DDS Data Extraction >> >(916) 654-2160 >> > >> >-----Original Message----- >> >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of >> Arthur Tabachneck >> >Sent: Tuesday, August 31, 2010 4:14 PM >> >To: SAS-L@LISTSERV.UGA.EDU >> >Subject: Re: Most recent input data set >> > >> >Daniel, >> > >> >I MUST have misread your question, as it isn't often that I discover >> >something that datanull doesn't already know. >> > >> >And, to be honest, I'm not sure how to harvest the following, thus I >> will >> >simply post what I found and hope others can explain and show you how >> you >> >might be able to use it. It was the result of submitting some code >> with a >> >typo. >> > >> >If you run the following code: >> > >> >proc print data=sashelp.class; >> >run; >> >%put &_VTtableName.; >> >%put &_VTtableLabel.'; >> > >> >Your log will show something like the following: >> > >> >114 proc print data=sashelp.class; >> >115 run; >> >116 %put &_VTtableName.; >> >117 %put &_VTtableLabel.'; >> >';proc print data=sashelp.class;run;%put &_VTtableName.;%put >> >&_VTtableLabel.' >> > > >Art and Paul, > >I get the following warnings when I try to run that code (Windows 7 64- bit, SAS 9.2 32-bit or 64-bit and on Window Server 2003 with SAS 9.1.3 service pack 4): > > >WARNING: Apparent symbolic reference _VTTABLENAME not resolved. >290 %put &_VTtableName.; >&_VTtableName. >291 %put &_VTtableLabel.; >WARNING: Apparent symbolic reference _VTTABLELABEL not resolved. >&_VTtableLabel. > > >Dan > >Daniel J. Nordlund >Washington State Department of Social and Health Services >Planning, Performance, and Accountability >Research and Data Analysis Division >Olympia, WA 98504-5204


Back to: Top of message | Previous page | Main SAS-L page