Yes, that's correct. I currently have a variable which holds a number between 1 and 61, and i have a list of date/times corresponding to them and want to recode.
We have tried to compute a new variable that would include a series of numbers corresponding to a date and time (e.g., 010000 should be midnight day 1). This did not work, the format didn’t “stick” - even though the variable type was set to date, this number sequence wasn’t interpreted by spss as a date/time. For example, I've tried recoding where old variable is srm.mo_1 and new variable is nsrm.mo_1 like this, where 1 is date and 003000 corresponds to 12:30 am, like this: "if srm.mo_1=3 nsrm.mo_1=1003000." This was not interpreted by spss as a date/time.
We also tried converting a string variable of a similar form to the one above into a date, using the “date and time wizard” and this did not provide the result we wanted.
Hope this helps. Thanks.
GerineL wrote:I am not entirely sure what it is you want to achieve. do I understand correctly that you have currently a variable which holds a number between 1 and 61, and you have a list of date/times coresponding to those numbers, and you want to recode them?
If not, please tell us what it is you want to achieve.
If so, can you indicate what you've tried and didn't work out?