Date:         Sat, 20 Apr 2002 20:37:00 +0100
Reply-To:     Joćo Duarte <adey@net.sapo.pt>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Joćo Duarte <adey@net.sapo.pt>
Subject:      Re: importing excel
Comments: To: "Jaffee, Marianne" <mjaffee@unf.edu>
In-Reply-To:  <CFB7B892437FD21183DC0020484017EB1068BB6F@lynx.unf.edu>
Content-Type: text/plain; charset=ISO-8859-1

Marianne,

I suppose this syntax will help you.

*******  begin syntax    ***************.

compute ss=(ee+115859)*24*60*60.

format ss(date11).
exe.

*******  end syntax     ***************.

ee=date variable imported from excel
ss=new date variable created by spsss.

the format is optional. you can choose another manually or by
syntax.

Joćo Duarte


Citando "Jaffee, Marianne" <mjaffee@unf.edu>:

} Hi,
} I've been reading your posts and I am truly humbled
} by the level of work you
} all do in SPSS.  I on the other hand, remain in the
} bottom half of the stat
} pool with my questions:  today this is my problem:
}
} I am trying to import raw data from an excel
} spreadsheet and everything is
} fine except for the variable that is a date....it
} converts it to a number
} and does not hold the "date" format given in Excel.
} When I try to read the
} data as a text file, again, most comes in fine except
} for several cases
} where the data columns are off by one or two.
}
} When you all bring data in from excel, is there a way
} to define one of your
} data elements as a date?  I know there are other
} options but it seems SPSS
} should be able to handle this.
}
} Thanks in advance!
} Marianne Jaffee
} UNF
}


--------------------------------------------
Webmail da rede SAPO - http://webmail.sapo.pt/