date formats

Solly7 — Wed, 15 Jan 2020 13:19:06 GMT

Hi, i need help in changing below dates formats

DATA HAVE DATA WANT

190125 25JAN2019

180809 09AUG2018

170111 11JAN2017

Re: date formats

ErikLund_Jensen — Fri, 17 Jan 2020 16:26:10 GMT

Hi @Solly7

You don't provide many informations. Are your input dates a number or a character string? - and do you want your output as a SAS date value (number of days since jan 1, 1960) with a format to show the date in reports as ddmonyyyy, or do you want a text string with the date in ddmonyyyy-format? -

This covers all combinations. The dates are converted to SAS data values, and the values with format and converted to string:

* test input: dates as numbers and strings;
data have;
	input date cdate$;
cards;
190125 190125
180809 180809
170111 180809
;
run;
data want; set have;

	sas_date = input(put(date,6.),yymmdd6.); * SAS-date from num input;
	sas_cdate = input(cdate,yymmdd6.);       * SAS-date from char input;

	format fmt_sas_date date9.;              * format to display SAS dates as ddmonyyyy;
	fmt_sas_date = sas_date;                 * SAS date value with format to show as ddmonyyyy;
	str_date = put(sas_date,date9.);         * formatted ddmonyyyy-string from SAS date value;
run;

topic Re: date formats in SAS Programming

date formats

Re: date formats