transport format catalog from sas v6 to v9
in [SAS]
|
From: Eversmann on 11 Dec 2009 11:25 hi all, i am trying to transport sas datasets/format catalogs from v6 to v9. i am defining a v6 library, a v9 library and using proc copy. this works perfect for datasets - however the format catelogs are not copied... and gives the error message catelog cannot be opened bacause files of type CATALOG are not supported in the OLD library (OLD is the libname) help? Thanks
From: Dianne Rhodes on 11 Dec 2009 15:02 On Fri, 11 Dec 2009 08:25:30 -0800, Eversmann <rifazrazeek(a)GMAIL.COM> wrote: >hi all, > >i am trying to transport sas datasets/format catalogs from v6 to v9. > >i am defining a v6 library, a v9 library and using proc copy. this >works perfect for datasets - however the format catelogs are not >copied... and gives the error message catelog cannot be opened bacause >files of type CATALOG are not supported in the OLD library (OLD is the >libname) > >help? > >Thanks I am migrating from 9.1.3 to 9.2, and my experience is that for catalogs (and therefore, formats) I have to create a transport file with CPORT in the old version of SAS, then use CIMPORT in 9.2 to bring them over. With datasets you can use proc migrate in 9.2. Dianne Rhodes @ census dot gov
From: Gerhard Hellriegel on 11 Dec 2009 16:44 I remember that we also had some problems with format catalogs. The problem is, that datasets are opened via the V6 engine. With catalogs that does not work. What might work is to create a transport file via CPORT and import that via CIMPORT. What I've found much better: use PROC FORMAT ... CNTLOUT=formats Bring the dataset FORMATS to V9 or simply use it in V9, SAS detects the engine to use and redefine the formats with: PROC FORMAT LIB=new.fmt_catalog CNTLIN=formats; RUN; under V9 If you have many format catalogs you can write a kind of utility macro. Gerhard On Fri, 11 Dec 2009 08:25:30 -0800, Eversmann <rifazrazeek(a)GMAIL.COM> wrote: >hi all, > >i am trying to transport sas datasets/format catalogs from v6 to v9. > >i am defining a v6 library, a v9 library and using proc copy. this >works perfect for datasets - however the format catelogs are not >copied... and gives the error message catelog cannot be opened bacause >files of type CATALOG are not supported in the OLD library (OLD is the >libname) > >help? > >Thanks
From: Eversmann on 14 Dec 2009 05:50 hi both, many thanks for the replies.. however, apprently i am not able to read the v6 catalog in the first place... i am getting this error message ERROR: OLD.FORMATS.CATALOG cannot be opened because files of type CATALOG are not supported in the OLD library. so, i can't do proc format/copy/cport or anything afterwards.. it always comes up with this error message.. do you think the files are corrupt or something (i tried different catalogs though).. or is there another engine i can use (after referencing many meterials.. they all refer to reading using v6 engine and then doing something.. i.e. proc cport / or output to dataset via proc formats) many thanks
From: rjf2 on 15 Dec 2009 10:42 use the libname engine: libname OLD v6 '<directory-specification>'; to ensure there is no confusion that SAS is reading only v6 data and catalogs make sure that there are only v6 files in your directory-specification. Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > -----Original Message----- > From: Eversmann > Sent: Monday, December 14, 2009 5:50 AM > Subject: Re: transport format catalog from sas v6 to v9 > > hi both, > > many thanks for the replies.. > > however, apprently i am not able to read the v6 catalog in the first > place... > i am getting this error message > ERROR: OLD.FORMATS.CATALOG cannot be opened because files of type > CATALOG are not supported in the OLD library. > > so, i can't do proc format/copy/cport or anything afterwards.. it > always comes up with this error message.. do you think the files are > corrupt or something (i tried different catalogs though).. or is there > another engine i can use (after referencing many meterials.. they all > refer to reading using v6 engine and then doing something.. i.e. proc > cport / or output to dataset via proc formats) > > many thanks > >
|
Next
|
Last
Pages: 1 2 Prev: SAS -> XML: v9.1 ne v9.2 Next: output regression coefficients from proc glm |