Date:         Tue, 28 Sep 2010 13:47:36 -0400
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: dataset description not displayed in SAS Explorer
Comments: To: Svend White <SvendW@HEALTH.OK.GOV>

How did you check the description? Did you right click and
check the "properties"?

The following works fine for me:

* run this piece, and check xx properties, I see description is blank;
data xx;
 set sashelp.class;
run;

* after proc datasets, I check xx properties again, I can see the newly
added label;
proc datasets library=work;
modify xx (label="asdf asdg asg st");
run;
quit;



On Tue, 28 Sep 2010 11:29:22 -0500, White, Svend A. <SvendW@HEALTH.OK.GOV>
wrote:

>Thanks for that catch, Ya
>
>I must've introduced typos when I copied it into the email and made some
>tweaks, since the actual code's running fine. Sorry about that.
>
>The only problem I'm having at with this macro is that I'm not seeing
>the description in SAS Explorer main window.
>
>Thanks.
>
>
>Svend
>
>
>> -----Original Message-----
>> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
>Ya
>> Huang
>> Sent: Tuesday, September 28, 2010 11:18 AM
>> To: SAS-L@LISTSERV.UGA.EDU
>> Subject: Re: dataset description not displayed in SAS Explorer
>>
>> Your macro resolved in this:
>>
>> Ipfmt.28SEP10(label="Inpatien format on 28SEP10")
>>
>> It seems to me that modify statment need a dataset name,
>> not a 2-level dataset name with libname. If lpfmt is libname,
>> then 28SEP10 is not a valid dataset name. If you meant to have
>> the macro resolve to Ipfmt28SEP10, then you need to get rid of
>> the '.' bewteen fmt and &timestampdate:
>>
>> fmt&timestampdate
>>
>> HTH
>>
>> Ya
>>
>> On Tue, 28 Sep 2010 10:34:57 -0500, White, Svend A.
>> <SvendW@HEALTH.OK.GOV>
>> wrote:
>>
>> >I ran this in SAS 9.2 for Windows:
>> >
>> >
>> >
>> >%global timestampdate;
>> >
>> >%global libinvolved;
>> >
>> >%global libabbrev;
>> >
>> >%let timestampdate=&sysdate;
>> >
>> >%let libinvolved=Inpatien;
>> >
>> >%let libabbrev=Ip;
>> >
>> >[...]
>> >
>> >proc datasets ddname= &libinvolved nolist;
>> >
>> >modify &libabbrev.fmt.&timestampdate(label="&libinvolved format on
>> >&timestampdate");
>> >
>> >run;
>> >
>> >
>> >
>> >and it seems to have successfully added a description to a dataset.
>> But
>> >the description doesn't show up in SAS Explorer, even though it does
>> >appear in the dataset's properties. Have tried refreshing and
>> restarting
>> >SAS.
>> >
>> >
>> >
>> >The other columns (Name, Size, Type & Modified) are populated
>> normally.
>> >
>> >
>> >
>> >A bug?
>> >
>> >
>> >
>> >Thanks.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >Svend
>> >
>> >
>> >
>> >> -----Original Message-----
>> >
>> >> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf
>Of
>> >
>> >> bbser2009
>> >
>> >> Sent: Monday, September 27, 2010 10:53 PM
>> >
>> >> To: SAS-L@LISTSERV.UGA.EDU
>> >
>> >> Subject: Re: proc append with force option
>> >
>> >> Importance: Low
>> >
>> >>
>> >
>> >> Hi Art,
>> >
>> >>
>> >
>> >> Thanks for your reply.
>> >
>> >>
>> >
>> >> After click that link, please find a link named "contents" and then
>> >
>> >> choose
>> >
>> >> page 383. You will see the example.
>> >
>> >>
>> >
>> >> Anyway, this is about appending two SAS data sets, the descriptor
>> >
>> >> portion
>> >
>> >> (the set of variables) of the BASE data set should not be changed
>> >
>> >> according
>> >
>> >> to the book.
>> >
>> >>
>> >
>> >> I experimented a similar situation, which seemly agreed with my
>> >
>> >> expectation.
>> >
>> >> But I would like to get confirmation from an experienced person,
>> since
>> >
>> >> I am
>> >
>> >> at the entrance level of SAS.
>> >
>> >>
>> >
>> >> Regards, Max
>> >
>> >>
>> >
>> >>
>> >
>> >> -----Original Message-----
>> >
>> >> From: Arthur Tabachneck [mailto:art297@NETSCAPE.NET]
>> >
>> >> Sent: September-27-10 11:17 PM
>> >
>> >> To: SAS-L@LISTSERV.UGA.EDU; Bbser 2009
>> >
>> >> Subject: Re: proc append with force option
>> >
>> >>
>> >
>> >> Max,
>> >
>> >>
>> >
>> >> The link you provided doesn't bring up a specific page, thus I'm
>not
>> >
>> >> sure
>> >
>> >> what the example is.  If it is a set, followed by two filenames, I
>> >
>> >> would
>> >
>> >> expect the resulting file to include all of the variables
>identified
>> >in
>> >
>> >> either file, with those not existing on one of the files to be set
>> to
>> >
>> >> missing.
>> >
>> >>
>> >
>> >> Art
>> >
>> >> ---------
>> >
>> >> On Mon, 27 Sep 2010 23:03:30 -0400, bbser2009 <bbser2009@GMAIL.COM>
>> >
>> >> wrote:
>> >
>> >>
>> >
>> >> >I do not understand the example on Page 383, SAS base programing,
>> 2nd
>> >
>> >> Ed.
>> >
>> >> >This is about appending two SAS data sets.
>> >
>> >> >
>> >
>> >> >In this example, the BASE= data set has two variables Num and Sex,
>> >the
>> >
>> >> DATA=
>> >
>> >> >data set has three varaibles Num, Sex, and State.
>> >
>> >> >I would expect in this case, the resulting data set only has two
>> >
>> >> variables
>> >
>> >> >Num and Sex, instead of three as given in the example.
>> >
>> >> >
>> >
>> >> >Can anyone help me check this out? You may see this example by
>copy
>> >
>> >> and
>> >
>> >> >paste this link below and then find the link named contents and
>> then
>> >
>> >> choose
>> >
>> >> >the page number 383.
>> >
>> >> >
>> >
>> >> >http://books.google.ca/books?
>> >
>> >> id=QrAIWGwF0sYC&printsec=frontcover&dq=base+pro
>> >
>> >>
>>
>>>graming,+sas,+2nd&source=bl&ots=Z2vyv9_lZ8&sig=AvoUUIOENKJMnkB9kcaVsN
>> l
>> >
>> >> VP78
>> >
>> >> &h
>> >
>> >> >l=en&ei=DVihTMmuA5KonQf-y8W-
>> >
>> >> Aw&sa=X&oi=book_result&ct=result&resnum=3&ved=0C
>> >
>> >> >BsQ6AEwAg#v=onepage&q&f=false
>> >
>> >> >
>> >
>> >> >
>> >
>> >> >
>> >
>> >> >Thanks a lot in advance, Max