topic Re: only need date in SAS Programming

only need date

aanan1417 — Wed, 26 May 2021 11:57:55 GMT

data have; input d date14.; datalines; 20may2021 5:15 ; run; data want; input d $ date9.; datalines; 20may2021 ; run;

Re: only need date

aanan1417 — Wed, 26 May 2021 11:58:47 GMT

data have; input d date14.; datalines; 20may2021 5:15 ; run; data want; input d $ date9.; datalines; 20may2021 ; run;

Re: only need date

PaigeMiller — Wed, 26 May 2021 12:06:19 GMT

Please state a clear question that you want to have an answer to.

Re: only need date

Astounding — Wed, 26 May 2021 13:54:41 GMT

First, note that dates should be numeric, not character. So this DATA step would need to change:

data want; 
input d $ date9.; 
datalines; 
20may2021
 ;

Get rid of the dollar sign and apply a format:

data want; 
input d date9.;
format d date9.; 
datalines; 
20may2021
 ;

Second, note that you don't have to read in everything on the line. You can pick and choose. So this DATA step still works when the data contains the time and you only want the date:

data want; 
input d date9.;
format d date9.; 
datalines; 
20may2021 05:15
 ;

Re: only need date

Sajid01 — Wed, 26 May 2021 14:06:57 GMT

Hello @aanan1417
Try this

data have (drop=t);
 informat d date9. t time5.;
 format d date9.;
	input d t ;
	datalines;
20may2021 5:15 
;
run;

The output will be as follows

Re: only need date

aanan1417 — Thu, 27 May 2021 06:54:23 GMT

both date are under same variable . and i need number of days