Date:         Fri, 19 Jun 2009 11:02:35 -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: .sd2 extension

Interesting! So SAS 9.2 detects the type of any dataset! Does it mark the
SD2 datasets in DIR window? Must do something if there are 2 datasets XX
with V9 and V6 type.

Anyway I'd expect problems with that, also in 9.2. In 9.1.3 it sometimes
works, sometimes not. It seems also to try detecting the type, but not
always successful. But the better way is to convert all to a actual format
and delete the sd2 datasets.

Sometimes I've had even more problems with catalogs, also with V8->V9.
Especially with formats in there.
For that sometimes it was a good idea to write them out with

proc format cntlout=dummy;
run;

and create them new with

proc format cntlin=dummy;
run;

That worked always for me.

Gerhard




On Fri, 19 Jun 2009 10:49:50 -0400, Ya Huang <ya.huang@AMYLIN.COM> wrote:

>In v9.2, mix v6 datasets and post-v6 dataset is allowed.
>For example, xx.sd2 and xx.sas7bdat with different contents
>are in the same directory, SAS will see xx.sas7bdat if a libname
>without v6 options is used. With v6 option, SAS will pick
>xx.sd2. This is different from v8.2 at least (never used 9.13).
>
>On Fri, 19 Jun 2009 08:37:40 -0400, Gerhard Hellriegel
><gerhard.hellriegel@T-ONLINE.DE> wrote:
>
>>by the way: you should not continue using sd2 (V6) datasets. Simply
>>allocate a old_library (V6) and a new_library (V9, without any engine...)
>>and use
>>
>>proc copy in=old_library out=new_library;
>>run;
>>
>>to bring them all to the right format. There might be some trouble with
>>sd2 libraries in future.
>>
>>Gerhard
>>
>>
>>
>>
>>On Fri, 19 Jun 2009 08:18:04 -0400, Fatos Simsek <fatosus@GMAIL.COM>
wrote:
>>
>>>it worked!
>>>thank you all so much,
>>>
>>>good day
>>>fs
>>>
>>>On Fri, Jun 19, 2009 at 5:54 AM, Gerhard Hellriegel <
>>>gerhard.hellriegel@t-online.de> wrote:
>>>
>>>> you should try to separate all V6 from all V9 datasets in different
>>>> directories (in windows with explorer).
>>>> SAS sometimes is not able to handle both types in ONE directory,
>>because a
>>>> LIBNAME is always a thing for a whole directory... If you have
all .sd2
>>>> datasets in a separate directory, try a libname on that. Normally SAS
>>>> detects that there are only V6 datasets and uses the right engine, but
>>you
>>>> can (should) also add the V6 engine.
>>>> Then try to open a dir window on that V6-library - do you see the
>>dataset
>>>> list? Then you might open it successfully...
>>>> Gerhard
>>>>
>>>>
>>>>
>>>> On Tue, 16 Jun 2009 16:26:05 -0400, Ya Huang <ya.huang@AMYLIN.COM>
>>wrote:
>>>>
>>>> >I suspect state99.sd2 is not a real dataset. Can you open it
>>>> >with SAS Viewer?
>>>> >
>>>> >On Tue, 16 Jun 2009 15:51:23 -0400, Fatos Simsek <fatosus@GMAIL.COM>
>>>> wrote:
>>>> >
>>>> >>too bad! it is not working.. any other ideas?
>>>> >>thank  you so much
>>>> >>f
>>>> >>
>>>> >>On Tue, Jun 16, 2009 at 3:26 PM, Ya Huang <ya.huang@amylin.com>
wrote:
>>>> >>
>>>> >>> *.sd2 is pc sas v6 version, you need to add v6 option in the
libname
>>>> >>> statement, so that SAS can recognize it:
>>>> >>>
>>>> >>> libname birth v6 "c:\pr\bdata";
>>>> >>>
>>>> >>> On Tue, 16 Jun 2009 14:32:53 -0400, Fatos Simsek
<fatosus@GMAIL.COM>
>>>> >>> wrote:
>>>> >>>
>>>> >>> >My problem is with the sas data set extensions. The data sets I
>>have
>>>> >were
>>>> >>> >sas data sets until the 9.1.3 version upgrade was performed. I am
>>>> >guessing
>>>> >>> >that after the upgrade datasets have received .sd2 extension???
>>>> State99
>>>> >>> >data below, for example, was a sas data set but now it is
>>state99.sd2.
>>>> >>>  How
>>>> >>> >can I resolve a problem such as this:
>>>> >>> >
>>>> >>> >977  libname birth 'c:\pr\bdata';
>>>> >>> >
>>>> >>> >NOTE: Libname BIRTH refers to the same physical library as BDATA.
>>>> >>> >
>>>> >>> >NOTE: Libref BIRTH was successfully assigned as follows:
>>>> >>> >
>>>> >>> >      Engine:        V9
>>>> >>> >
>>>> >>> >      Physical Name: C:\PR\BData
>>>> >>> >
>>>> >>> >978
>>>> >>> >
>>>> >>> >979  options fmtsearch=(pr2.format99);
>>>> >>> >
>>>> >>> >980
>>>> >>> >
>>>> >>> >981  data pr99;
>>>> >>> >
>>>> >>> >982  set  pr99.state99;
>>>> >>> >
>>>> >>> >ERROR: File PR99.state99.DATA is not a SAS data set.
>>>> >>> >
>>>> >>> >.
>>>> >>> >
>>>> >>> >.
>>>> >>> >
>>>> >>> >.
>>>> >>> >
>>>> >>> >.
>>>> >>> >
>>>> >>> >NOTE: The SAS System stopped processing this step because of
>>errors.
>>>> >>> >WARNING: The data set WORK.PR99 may be incomplete.  When this
step
>>was
>>>> >>> >stopped there were 0 observations and 2 variables.
>>>> >>>
>>>> >>
>>>> >>
>>>> >>
>>>> >>--
>>>> >>               \\  - -  //
>>>> >>             (  @ @  )
>>>> >>+------oOOo-(_)-oOOo----------+---------------------------------+
>>>> >>
>>>> >>"Be who you are and say how you feel.
>>>> >>Because those who mind don't matter,
>>>> >>and those who matter don't mind."
>>>> >>--Dr. Seuss
>>>>
>>>
>>>
>>>
>>>--
>>>               \\  - -  //
>>>             (  @ @  )
>>>+------oOOo-(_)-oOOo----------+---------------------------------+
>>>
>>>"Be who you are and say how you feel.
>>>Because those who mind don't matter,
>>>and those who matter don't mind."
>>>--Dr. Seuss