I now have SAS 9.2 64-bit running under Windows XP-64.

In going back to read a SAS data set that I created in SAS92 32-bit I find that
I can read the data set if I have not attached formats, but cannot if I created
user-provided formats.

I usually have a separate program that creates the format library.  Thus, if
I could strip out the user provided formats from the permanent SAS data set
I could run the format program to create 64-bit compatible formats and then
re-run the program that I used to attach the labels and formats to
the variables.

Now... How to strip the user provided formats out of a sas 9.2 32-bit
permanent data set
using SAS 9.2 64-bit?

As always, any help appreciated.






______________________________________________________________________

Kevin F. Spratt, Ph.D.
Department of Orthopaedic Surgery
Dartmouth Medical School
One Medical Center Drive
DHMC
Lebanon, NH   USA  03756
(603) 653-6012                          (voice)
(603) 653-6013                          (fax)
Kevin.F.Spratt@Dartmouth.Edu            (e-mail)
_______________________________________________________________________

> From: Kevin F. Spratt
> Subject: SAS92 32-BIT TO SAS92 64-BIT problem
>
> I now have SAS 9.2 64-bit running under Windows XP-64.
>
> In going back to read a SAS data set that I created in SAS92
> 32-bit I find that
> I can read the data set if I have not attached formats, but
> cannot if I created
> user-provided formats.
>
> I usually have a separate program that creates the format
> library.  Thus, if
> I could strip out the user provided formats from the
> permanent SAS data set
> I could run the format program to create 64-bit compatible
> formats and then
> re-run the program that I used to attach the labels and formats to
> the variables.
>
> Now... How to strip the user provided formats out of a sas 9.2 32-bit
> permanent data set
> using SAS 9.2 64-bit?
>
> As always, any help appreciated.

SmryEachVar: A Data Review Suite For Each Variable in All Data Sets in a
Libref
paper http://www2.sas.com/proceedings/forum2008/003-2008.pdf
TinyUrl for this page: http://tinyurl.com/5682j8

the zip for this suite has a program
WritDset

which writes proc datasets code for each var in a data set

- - - begin{documentation} - - - -
Usage . . . . : see Example below
%Let Out_Txt = zq;
%Let Libname     = SAShelp;
%Let Memname     = Class;
%Include 'WritDset.sas';

example output:
*datasets statements for sashelp.class;
PROC Datasets library = Work memtype = data;
              modify    class;

              *format Name $Name.;
              *label  Name = '                          ';
              *rename Name = Name;

usage: remove comments, modify
              format Sex $gender.;
              label  Sex = 'Gender';
              rename Sex = Gender;
- - - end{documentation} - - - - - -

iirc, datasets is one of the procs that supports run-group processing

surely you will have to drop the association
and reapply it:

PROC Datasets library = Work
              memtype = data;
              modify    MyData;
              format    MyVar;*remove;
              run;
              modify    MyData;
              format    MyVar SameFmt.;*reapply;

caveat: untested code!

Ron Fehd  the module/routine/subroutine maven  CDC Atlanta GA USA RJF2
at cdc dot gov

No need to strip the formats out necessarily.  You can use the option
NOFMTERR which simply gives a warning when it encounters a format that
it cannot find.  Simply type

OPTIONS NOFMTERR;

If you really want to strip the formats, you can do the following:

Data mydata64 ;
set mydata32 ;
format _all_ ;
run ;


Steve


On Jan 6, 4:57=A0pm, Kevin.F.Spr...@DARTMOUTH.EDU ("Kevin F. Spratt")
wrote:
> I now have SAS 9.2 64-bit running under Windows XP-64.
>
> In going back to read a SAS data set that I created in SAS92 32-bit I fin=
d that
> I can read the data set if I have not attached formats, but cannot if I c=
reated
> user-provided formats.
>
> I usually have a separate program that creates the format library. =A0Thu=
s, if
> I could strip out the user provided formats from the permanent SAS data s=
et
> I could run the format program to create 64-bit compatible formats and th=
en
> re-run the program that I used to attach the labels and formats to
> the variables.
>
> Now... How to strip the user provided formats out of a sas 9.2 32-bit
> permanent data set
> using SAS 9.2 64-bit?
>
> As always, any help appreciated.
>
> ______________________________________________________________________
>
> Kevin F. Spratt, Ph.D.
> Department of Orthopaedic Surgery
> Dartmouth Medical School
> One Medical Center Drive
> DHMC
> Lebanon, NH =A0 USA =A003756
> (603) 653-6012 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0(voice)
> (603) 653-6013 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0(fax)
> Kevin.F.Spr...@Dartmouth.Edu =A0 =A0 =A0 =A0 =A0 =A0(e-mail)
> _______________________________________________________________________

Kevin -
  I am not sure what error you are talking about. All that is stored
in the dataset is the name of the format to attach to the variable.
The actual formats are stored in a SAS catalog.  The compatibility
issue as I understand it is with these format catalogs and not with
the SAS datasets. If you already have the code to create the formats
then you can run it under 64 bit SAS and make a new format catalog.
  Or are you saying that you have done that and you still get error
messages when using the 32 bit datasets?
- Tom

On Jan 6, 4:57=A0pm, Kevin.F.Spr...@DARTMOUTH.EDU ("Kevin F. Spratt")
wrote:
> I now have SAS 9.2 64-bit running under Windows XP-64.
>
> In going back to read a SAS data set that I created in SAS92 32-bit I fin=
d that
> I can read the data set if I have not attached formats, but cannot if I c=
reated
> user-provided formats.
>
> I usually have a separate program that creates the format library. =A0Thu=
s, if
> I could strip out the user provided formats from the permanent SAS data s=
et
> I could run the format program to create 64-bit compatible formats and th=
en
> re-run the program that I used to attach the labels and formats to
> the variables.
>
> Now... How to strip the user provided formats out of a sas 9.2 32-bit
> permanent data set
> using SAS 9.2 64-bit?
>
> As always, any help appreciated.
>
> ______________________________________________________________________
>
> Kevin F. Spratt, Ph.D.
> Department of Orthopaedic Surgery
> Dartmouth Medical School
> One Medical Center Drive
> DHMC
> Lebanon, NH =A0 USA =A003756
> (603) 653-6012 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0(voice)
> (603) 653-6013 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0(fax)
> Kevin.F.Spr...@Dartmouth.Edu =A0 =A0 =A0 =A0 =A0 =A0(e-mail)
> _______________________________________________________________________

Formats are stored in SAS catalogs and 32bits catalogs are not compatibles with 64bit SAS.

I think it suffices to discard your 32bit catalog and recreate a 64bit version by re-running the same the same formats programs in the 64bits session.

(Hope this works, I've never used 64bit SAS on windows.)
Rivo.

-----Message d'origine-----
De : SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] De la part de Kevin F. Spratt
Envoy� : mercredi 6 janvier 2010 22:58
� : SAS-L@LISTSERV.UGA.EDU
Objet : SAS92 32-BIT TO SAS92 64-BIT problem

I now have SAS 9.2 64-bit running under Windows XP-64.

In going back to read a SAS data set that I created in SAS92 32-bit I find that
I can read the data set if I have not attached formats, but cannot if I created
user-provided formats.

I usually have a separate program that creates the format library.  Thus, if
I could strip out the user provided formats from the permanent SAS data set
I could run the format program to create 64-bit compatible formats and then
re-run the program that I used to attach the labels and formats to
the variables.

Now... How to strip the user provided formats out of a sas 9.2 32-bit
permanent data set
using SAS 9.2 64-bit?

As always, any help appreciated.






______________________________________________________________________

Kevin F. Spratt, Ph.D.
Department of Orthopaedic Surgery
Dartmouth Medical School
One Medical Center Drive
DHMC
Lebanon, NH   USA  03756
(603) 653-6012                          (voice)
(603) 653-6013                          (fax)
Kevin.F.Spratt@Dartmouth.Edu            (e-mail)
_______________________________________________________________________