date problem

[drfg2008]

SPSS20 / Win

I have a csv-file with the following date format:

2007-03-17 13:00:00


I couldn't find a way to import it in SPSS as a date format (either while importing it from csv or as a function after being imported as a string, or any other solution)

Thanks for some help

[David Marso]

Two approaches:
data list /x (A19).
BEGIN DATA
2007-03-17 13:00:00
end data.
COMPUTE DATEX=NUMBER(CONCAT(SUBSTR(X,9,2),SUBSTR(X,5,4),SUBSTR(X,1,4),SUBSTR(X,11)),DATETIME).
FORMAT DATEX (DATETIME).
list.

data list /D (SDATE) T (TIME).
BEGIN DATA
2007-03-17 13:00:00
end data.
COMPUTE DT=D+T.
FORMAT DT (DATETIME).
list.
HTH, David
--

drfg2008 wrote

SPSS20 / Win

I have a csv-file with the following date format:

2007-03-17 13:00:00


I couldn't find a way to import it in SPSS as a date format (either while importing it from csv or as a function after being imported as a string, or any other solution)

Thanks for some help

[David Marso]

Two approaches:
data list /x (A19).
BEGIN DATA
2007-03-17 13:00:00
end data.
COMPUTE
DATEX=NUMBER(CONCAT(SUBSTR(X,9,2),SUBSTR(X,5,4),SUBSTR(X,1,4),SUBSTR(X,11)),DATETIME).
FORMAT DATEX (DATETIME).
list.

data list /D (SDATE) T (TIME).
BEGIN DATA
2007-03-17 13:00:00
end data.
COMPUTE DT=D+T.
FORMAT DT (DATETIME).
list.
HTH, David
--

drfg2008 wrote:

>
> SPSS20 / Win
>
> I have a csv-file with the following date format:
>
> 2007-03-17 13:00:00
>
>
> I couldn't find a way to import it in SPSS as a date format (either while
> importing it from csv or as a function after being imported as a string,
> or any other solution)
>
> Thanks for some help
>

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/date-problem-tp4990196p4990282.html
Sent from the SPSSX Discussion mailing list archive at 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

[drfg2008]

thanks, it works perfectly