topic Re: date format in New SAS User

date format

mmea — Tue, 11 May 2021 14:37:01 GMT

How to make this dateformat in SAS 11052021?

Re: date format

PaigeMiller — Tue, 11 May 2021 14:50:41 GMT

What do you mean "make this dateformat"? Do you mean apply it to a variable?

11052021 does not have a clear meaning. Is it MMDDYYYY or DDMMYYYY or something else?

Re: date format

asuman — Tue, 11 May 2021 14:57:12 GMT

data test;
input date;
cards;
11052021
;
run;
data test1;
set test;
format newdate date10.;
newdate = input(put(date,8.),ddmmyy8.);
run;

Re: date format

mmea — Tue, 11 May 2021 14:59:46 GMT

i need to have a date that I make in this macro. Currently it gives me 11/05/21 - but i want it to come out like 11052021

%let todaysDate = %sysfunc(today(), DDMMYY8.);
%put &todaysDate;

Re: date format

mmea — Tue, 11 May 2021 15:01:23 GMT

sorry i clicked wrong - this i not what I need - I need it as a macro so that I can put it in a file name

Re: date format

PaigeMiller — Tue, 11 May 2021 15:04:15 GMT

%let todaysDate = %sysfunc(today(), DDMMYYN8.);

Please note: macro variables should not be formatted, except in rare instance, or when used in titles, labels or external file names. If you are not in one of these cases, do not format your macro variables.

Your example code should have ideally been included in your original question. You will get faster and more correct answers by being specific in your first post.

Re: date format

mmea — Tue, 11 May 2021 15:07:12 GMT

thank you this only adds 110521 - can I add 2021

Re: date format

mmea — Tue, 11 May 2021 15:07:33 GMT

Sorry my bad it works