Date format excel transformation datepart
Bonjour, j’ai un fichier Excel avec des dates sous forme: 03/29/2020 20:56
J’ai essayé de prendre cette variable date pour la séparer et avoir l’heure, la date mais je n y arrive pas.
tous les participants ont une date.
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14
| Data mem; set mem1;
datee = datepart(date);
format datee MMDDYY10.;
heure = timepart(date);
format heure HHMM.;
run;
Data mem; set mem1;
format datee ddmmyy10. heure time5.;
datee = datepart(date);
heure = timepart(date);
run;
proc print data = mem ; var datee heure ;
title "entrevue";
run; |
message erreur
Citation:
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line) : (Column).
936 at 421:9 936 at 423:9
NOTE: There were 936 observations read from the data set .
NOTE: The data has 936 observations and 148 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.17 seconds