topic Re: Combine the (m-dd-yy) into one variable representing the date. in SAS Programming

Combine the (m-dd-yy) into one variable representing the date.

Koke — Mon, 10 Jul 2017 03:53:25 GMT

Hello, guys

I'm struggling in a date issue. I searched for informat date statement and did not find this type of format M-DD-YY.

here is my data

3-05-98,5.79,7.69,112.8,128,47,46.7,10.6
4-06-98,4.75,5.49,61.3,75,20,19.3,7.1
4-07-98,4.95,5.79,65.5,62,20,19.8,7.6
2-25-98,5.34,6.77,.,102,33.5,33.5,8.3

This my code

data limes
;
infile "/folders/myshortcuts/SASUniversityEdition/module 3/limes.txt"
firstobs=2 dsd 
;
input 
date fruitdia f_length fruit_Wt f_vol J_vol juice_wt peel_wt
;
proc
print data = limes
;

Obs date fruitdia f_length fruit_Wt f_vol J_vol juice_wt peel_wt 1 2 3 4 5 6

.	5.79	7.69	112.8	128	47.0	46.7	10.6
.	4.75	5.49	61.3	75	20.0	19.3	7.1
.	4.95	5.79	65.5	62	20.0	19.8	7.6
.	5.34	6.77	.	102	33.5	33.5	8.3
.	5.44	6.16	86.6	100	32.0	31.8	8.7
.	6.71	7.46	164.2	184	67.0	67.5	15.7

Thank you guys

Re: Combine the (m-dd-yy) into one variable representing the date.

Reeza — Mon, 10 Jul 2017 04:01:00 GMT

Try the informat of ANYDTDTE or MMDDYY10. Either appeared to work fine for me.

@Koke wrote:

Hello, guys

I'm struggling in a date issue. I searched for informat date statement and did not find this type of format M-DD-YY.

here is my data

3-05-98,5.79,7.69,112.8,128,47,46.7,10.6
4-06-98,4.75,5.49,61.3,75,20,19.3,7.1
4-07-98,4.95,5.79,65.5,62,20,19.8,7.6
2-25-98,5.34,6.77,.,102,33.5,33.5,8.3

This my code
data limes
;
infile "/folders/myshortcuts/SASUniversityEdition/module 3/limes.txt"
firstobs=2 dsd 
;
input 
date fruitdia f_length fruit_Wt f_vol J_vol juice_wt peel_wt
;
proc
print data = limes
;
Obs date fruitdia f_length fruit_Wt f_vol J_vol juice_wt peel_wt 1 2 3 4 5 6

. 5.79 7.69 112.8 128 47.0 46.7 10.6

. 4.75 5.49 61.3 75 20.0 19.3 7.1

. 4.95 5.79 65.5 62 20.0 19.8 7.6

. 5.34 6.77 . 102 33.5 33.5 8.3

. 5.44 6.16 86.6 100 32.0 31.8 8.7

. 6.71 7.46 164.2 184 67.0 67.5 15.7

Thank you guys

Re: Combine the (m-dd-yy) into one variable representing the date.

kiranv_ — Mon, 10 Jul 2017 04:06:54 GMT

this worked for me

data limes
;
infile datalines dsd ;
;
input 
date:mmddyy10. fruitdia f_length fruit_Wt f_vol J_vol juice_wt peel_wt;
format date date9.;
datalines;
3-05-98,5.79,7.69,112.8,128,47,46.7,10.6
4-06-98,4.75,5.49,61.3,75,20,19.3,7.1
4-07-98,4.95,5.79,65.5,62,20,19.8,7.6
2-25-98,5.34,6.77,.,102,33.5,33.5,8.3
;

Re: Combine the (m-dd-yy) into one variable representing the date.

Kurt_Bremser — Mon, 10 Jul 2017 08:29:13 GMT

The MMDDYY, DDMMYY and YYMMDD informats can all deal with single-digit days and months, so you don't need to look for a special format for dates written like that.