SAS formats ???

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

SAS formats ???

Samuel Solomon
Hi list,

  I hope you would allow me to ask SAS related queries. Here is a SAS
code..

 

Proc format;

picture mf

     0             ='99999999999999'

     0 < -high     ='99999999999999';

picture nf

     0            = '        '

     0 < - high   = '009,99' (mult=100);

 

Does it ring any bells to you? What does it me? I wish to convert it to
a meaningful SPSS syntax.

 

Thanks,

Samuel.

 
Reply | Threaded
Open this post in threaded view
|

Re: SAS formats ???

Spousta Jan
Hi Samuel,

I am not an expert in SAS formats and it is hard to reproduce them
correctly in SPSS. I think that the first format is simply

FORMATS variable list (F14).

in the SPSS language. (Of course, in SPSS you cannot create formats in
advance, without applying them on variables.)

The second case is more difficult - it is something like

COMPUTE x = x * 100 /* the MULT option in SAS */ .
FORMATS x (COMMA6.2).

Moreover SAS replaces zero with blanks - hard to code in SPSS without
transforming the numbers into strings.

Hope this helps somehow,

Jan

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Samuel Solomon
Sent: Wednesday, September 13, 2006 10:58 AM
To: [hidden email]
Subject: SAS formats ???

Hi list,

  I hope you would allow me to ask SAS related queries. Here is a SAS
code..



Proc format;

picture mf

     0             ='99999999999999'

     0 < -high     ='99999999999999';

picture nf

     0            = '        '

     0 < - high   = '009,99' (mult=100);



Does it ring any bells to you? What does it me? I wish to convert it to
a meaningful SPSS syntax.



Thanks,

Samuel.
Reply | Threaded
Open this post in threaded view
|

Re: SAS formats ???

Swank, Paul R
In reply to this post by Samuel Solomon
The picture statement in SAS works like in COBOL. It merely provides a
format for printing. nf = to 0 is printed as blanks while nf>0 means
multiply by 100 and print with two decimals.


Paul R. Swank, Ph.D.
Professor, Developmental Pediatrics
Director of Research, Children's Learning Institute
Medical School
University of Texas Health Science Center at Houston

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Samuel Solomon
Sent: Wednesday, September 13, 2006 3:58 AM
To: [hidden email]
Subject: SAS formats ???

Hi list,

  I hope you would allow me to ask SAS related queries. Here is a SAS
code..



Proc format;

picture mf

     0             ='99999999999999'

     0 < -high     ='99999999999999';

picture nf

     0            = '        '

     0 < - high   = '009,99' (mult=100);



Does it ring any bells to you? What does it me? I wish to convert it to
a meaningful SPSS syntax.



Thanks,

Samuel.
Reply | Threaded
Open this post in threaded view
|

Re: SAS formats ???

Samuel Solomon
In reply to this post by Samuel Solomon
Thanks, now I understand it.



-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Swank, Paul R
Sent: Wednesday, September 13, 2006 6:05 PM
To: [hidden email]
Subject: Re: SAS formats ???

The picture statement in SAS works like in COBOL. It merely provides a
format for printing. nf = to 0 is printed as blanks while nf>0 means
multiply by 100 and print with two decimals.


Paul R. Swank, Ph.D.
Professor, Developmental Pediatrics
Director of Research, Children's Learning Institute
Medical School
University of Texas Health Science Center at Houston

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Samuel Solomon
Sent: Wednesday, September 13, 2006 3:58 AM
To: [hidden email]
Subject: SAS formats ???

Hi list,

  I hope you would allow me to ask SAS related queries. Here is a SAS
code..



Proc format;

picture mf

     0             ='99999999999999'

     0 < -high     ='99999999999999';

picture nf

     0            = '        '

     0 < - high   = '009,99' (mult=100);



Does it ring any bells to you? What does it me? I wish to convert it to
a meaningful SPSS syntax.



Thanks,

Samuel.