Link files and add variables

[spssdummy]

I really would like to share the data but I''m not allowed to bc it's data
from a specific study that is not mine. But if they cannot find out, maybe I
can just share.



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[bdates]

Could you create 'dummy' files of 10 or so cases so we could see what the data look like. Make sure that it's like your data with, as you say, dates that don't seem to match up. I've been following this thread, and there are simply times when we get data that hasn't been carefully produced or kept and our client wants us to perform miracles. Maybe that's true in your case, but seeing the data will help us all to help you.

Brian

---

From: SPSSX(r) Discussion <[hidden email]> on behalf of spssdummy <[hidden email]>
Sent: Thursday, May 23, 2019 11:02:49 AM
To: [hidden email]
Subject: Re: Link files and add variables

 

I really would like to share the data but I''m not allowed to bc it's data
from a specific study that is not mine. But if they cannot find out, maybe I
can just share.



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

===================== To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

[David Marso-2]

I 'll bet the dates simply don't match because there is an invisible time part.
Clean them up and try again. Hint see XDATE.DATE function.
COMPUTE CleanDate=XDATE.DATE(DirtyDate).

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[spssdummy]

So I tried COMPUTE CleanDate=XDATE.DATE(DirtyDate) and I get these super high
numbers that don't make any sense really.



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Maguin, Eugene]

Format cleandate(adate10).

-----Original Message-----
From: SPSSX(r) Discussion <[hidden email]> On Behalf Of spssdummy
Sent: Thursday, May 23, 2019 12:52 PM
To: [hidden email]
Subject: Re: Link files and add variables

So I tried COMPUTE CleanDate=XDATE.DATE(DirtyDate) and I get these super high numbers that don't make any sense really.



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso]

Please do yourself (and us) a favor and read up  on how SPSS stores dates.

From the  FM Universals section.  You would do well to review that entire
section.  You ask a lot of questions which would be unnecessary if you were
to RTFM  just a tiny bit.

*Date and Time Formats*
Date and time formats are both input and output formats. Like numeric
formats, each input format generates a default output format, automatically
expanded (if necessary) to accommodate display width. Internally,*all date
and time format values are stored as a number of seconds: ... since October
14, 1582*; .......


spssdummy wrote

> So I tried COMPUTE CleanDate=XDATE.DATE(DirtyDate) and I get these super
> high
> numbers that don't make any sense really.
>
>
>
> --
> Sent from: http://spssx-discussion.1045642.n5.nabble.com/
>
> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD





-----
Please reply to the list and not to my personal email.
Those desiring my consulting or training services please feel free to email me.
---
"Nolite dare sanctum canibus neque mittatis margaritas vestras ante porcos ne forte conculcent eas pedibus suis."
Cum es damnatorum possederunt porcos iens ut salire off sanguinum cliff in abyssum?"
--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[spssdummy]

Yeah I could definitely learn a lot by reading but my date variables seem
just fine. They are both date variables in the format dd.mm.yyyy so I don't
see any problem here.



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso-2]

You completely missed my point!
Why aren't the files properly matching?

What do you see when you throw a DATETIME format on the beast.
I'll bet the time part on both files is NOT always midnight!!!
RTFM grasshopper.
"date variables seem just fine"
Because you are a clueless noob?
I think I am done here.
Lead a horse to water and all of that shit.
quote author="spssdummy">
Yeah I could definitely learn a lot by reading but my date variables seem
just fine. They are both date variables in the format dd.mm.yyyy so I don't
see any problem here.



--
</quote>

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[spssdummy]

Please stay respectful even if the point you were trying to make didn't come
across.

kind regards and thanks for the effort



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[spssdummy]

BTW you were right about the time part of the data variables. I wasn't to
lasy to read through the manuals but I just didn't get what actually the
problem was until just a few mins ago. So I made a new data variable for one
of the files (in the other file the dates did all have the same time part).
Now everything has been matched correctly:)

Thx



--
Sent from: http://spssx-discussion.1045642.n5.nabble.com/

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso-2]

I am delighted things worked out. Sorry about the "stick" earlier.  
How did the epiphany feel?

"BTW you were right about the time part of the data variables. I wasn't to
lasy to read through the manuals but I just didn't get what actually the
problem was until just a few mins ago. So I made a new data variable for one
of the files (in the other file the dates did all have the same time part).
Now everything has been matched correctly:) "

Thx "

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD