topic Re: date conversion in SAS Programming

date conversion

paddyb — Sun, 26 Feb 2017 02:37:43 GMT

data have;

aestdtc="02mar2010";

aeendtc="03jul2010";

end;

how to convert these dates like 02-03-2010 and 03-07-2010?

thanks

Re: date conversion

mkeintz — Sun, 26 Feb 2017 02:46:31 GMT

Just as x=3 assigns a numeric literal (3) to x

and

name='paddyb' assigns a character literal (paddyb) to name

aestdtc="02mar2010"d assigns a date literal ("02mar2010"d) to the variable AESTDTC, which now contains a sas date value.

You only have to assign one of many date formats (date9., yymmdd10. yymon7. ...) to see it displayed in human-interpretable form. In your case, assign the format ddmmyy10:

format aestdtc ddmmyyd10.;

Note: the trailing "d" in ddmmyyd10. represents a dash. There are other separators available.

Re: date conversion

paddyb — Sun, 26 Feb 2017 02:49:08 GMT

Thanks for reply.Actually in my aestdtc have 100 obs and i want to convert all

so my question is how to apply 'aestdtc'd

Re: date conversion

mkeintz — Sun, 26 Feb 2017 02:52:05 GMT

Do you have 100 observations in a sas dataset, where aestdtc is a character variable? Show the input data set please, in the form of a sas data set or raw data file.

Re: date conversion

PGStats — Sun, 26 Feb 2017 03:17:57 GMT

Use the input function with SAS date informats (such as date9.) to convert strings to SAS dates, and make sure you associate a SAS date format (such as ddmmyyd10.) with SAS dates:

data have;
aestdtc="02mar2010";
aeendtc="03jul2010";
aestdt = input(aestdtc, date9.);
aeendt = input(aeendtc, date9.);
format aestdt aeendt ddmmyyd10.;
run;

proc print; run;

Re: date conversion

paddyb — Sun, 26 Feb 2017 04:10:13 GMT

thanks it works for full date but not working where aestdtc="mar2014"if day is misssing

Re: date conversion

mkeintz — Sun, 26 Feb 2017 04:12:08 GMT

You didn't mention that. Before I respond, are there other incoming date formats that you will need to accomodate?

Re: date conversion

PGStats — Sun, 26 Feb 2017 04:18:58 GMT

What date to you want to convert aestdtc="mar2014" into?

Re: date conversion

paddyb — Sun, 26 Feb 2017 04:26:20 GMT

sorry didnt mention it.thr r few dates in which month and day is missing