Date: Mon, 11 Jun 2007 08:26:29 -0400
Reply-To: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE>
Subject: Re: %DS2CSV killed my SASHELP
In versions pre-8 the example datasets where located in SASUSER, but only
if you created them either with ASSIST, or with a source, found in a MISC
or SAMPLES subdirectory. Have a look there, maybe that sources are still
there. If you find something like RETAIL.SAS, include that in your SAS
editor, have a look at the target dataset name = SASHELP.RETAIL and run it.
On Mon, 11 Jun 2007 08:19:45 -0400, Michael Raithel
>Ben Powell posted the following:
>> Is there a way to restore datasets to sashelp other than from
>> the source media?
>> I must confess to having not read the documentation on this
>> but was a little disturbed to find the following code from
>> the SAS base_lrdictionary_9200 pdf (page 1726) killed the
>> dataset referred to:
>> data sashelp.retail;
>> %ds2csv (data=sashelp.retail, runmode=b,
>> csvfile=c:\temp\retail.csv); run;
>> Any suggestions - how to restore the dataset more than what
>> happened with the code? (Although it seems with the latter
>> %ds2csv should not have been executed within a datastep! Is
>> that then an error in the example?)
>Ben, BUMMER! If you have a colleague that also has SAS installed,
>simply ask that person for a copy of the sashelp.retail SAS data set:
>retail.sas7bdat. Then, copy it into your sashelp SAS data library. It
>could be that simple.
>Ben, here's hoping that you don't get any other nasty surprises!
>I hope that this suggestion proves helpful now, and in the future!
>Of course, all of these opinions and insights are my own, and do not
>reflect those of my organization or my associates. All SAS code and/or
>methodologies specified in this posting are for illustrative purposes
>only and no warranty is stated or implied as to their accuracy or
>applicability. People deciding to use information in this posting do so
>at their own risk.
>Michael A. Raithel
>"The man who wrote the book on performance"
>Author: Tuning SAS Applications in the MVS Environment
>Author: Tuning SAS Applications in the OS/390 and z/OS Environments,
>Author: The Complete Guide to SAS Indexes
>Acting is all about honesty. If you can fake that, you've got it made.
>- George Burns