Create specific date variables

juliehn — Tue, 29 Jan 2019 09:53:32 GMT

Hi all,

I need to create to date variables with the following formate: date1=dd/mm/yy and date2=dd/mm/yy.

I have the following program and it doesn't work:

data example;

set dataset;

date1='01jan18'd;

date2='31dec18'd;

put date1 ddmmyy8.;

put date2 ddmmyy8.;

run;

The dates return in weird formats.

Hope someone can help!

Best,

Julie

Re: Create specific date variables

PeterClemmensen — Tue, 29 Jan 2019 10:04:42 GMT

Hi. In the code you posted you only format the date variables in the date values you put to the log. The date variables in the data set will not be formatted. Use a Format Statement like this

data test;
   date1='01jan18'd;
   date2='31dec18'd;
   format date1 date2 ddmmyy8.;
run;

topic Re: Create specific date variables in New SAS User

Create specific date variables

Re: Create specific date variables