I want to create data set by enter the data.
What is the way to define the informat for data set "Have1"?
Note- Informat for data set "Have2" is working well
data have1; input d_time : datetime18.; format d_time datetime20.; cards; 27/05/2023:06:05:00 03/10/2022:14:24:00 02/10/2022:20:19:00 ; Run; data have2; input d_time : datetime18.; format d_time datetime20.; cards; 27MAY2023:06:05:00 03OCT2022:14:24:00 02OCT2022:20:19:00 ; Run;
You could try the ANYDTDTM informat.
678 data have1; 679 input d_time : anydtdtm.; 680 format d_time datetime20.; 681 put d_time _infile_; 682 cards; 27MAY2023:06:05:00 27/05/2023:06:05:00 10MAR2022:14:24:00 03/10/2022:14:24:00 10FEB2022:20:19:00 02/10/2022:20:19:00 NOTE: The data set WORK.HAVE1 has 3 observations and 1 variables.
But you will notice that for the ambiguous records where the first value could be either the month or the day of the month (at least on my machine) it defaults to use MDY ordering.
If you want to force it to use DMY order in those ambiguous situations then you need to se the datestyle option.
690 options datestyle=dmy; 691 data have1; 692 input d_time : anydtdtm.; 693 format d_time datetime20.; 694 put d_time _infile_; 695 cards; 27MAY2023:06:05:00 27/05/2023:06:05:00 03OCT2022:14:24:00 03/10/2022:14:24:00 02OCT2022:20:19:00 02/10/2022:20:19:00 NOTE: The data set WORK.HAVE1 has 3 observations and 1 variables.
data have1; input d ddmmyy10. @12 t time8.; d_time = dhms(d,0,0,t); format d_time datetime20.; drop d t; cards; 27/05/2023:06:05:00 03/10/2022:14:24:00 02/10/2022:20:19:00 ;
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.