topic Re: Date in Statistical Procedures

Date

Thalitacosta — Mon, 06 Sep 2021 19:11:00 GMT

I have the variable "date" whose format is in "03APR2020:00:00:00.000", but I want to make a new variable "dt" using only "202004". What code can I use?

Code below is wrong:

data tabl1;

set tabl;

dt = year(date) + month(date);

run;

Re: Date

sbxkoenk — Mon, 06 Sep 2021 19:50:05 GMT

Try something like this.

Use concatenation operator (|| or !!) and not the plus-sign.

Or use CATx functions.

data have;
 a='03APR2020:00:00:00.000'dt;
 put a= dtmonyy7.;
 b=datepart(a);
 put b= monyy7.;
 put b= yymmdd5.; 
 c=year(b)||'-'||put(month(b),z2.);
 put c=;
run;

Koen

Re: Date

Kurt_Bremser — Mon, 06 Sep 2021 19:51:24 GMT

dt = datepart(date);
format dt yymmn6.;

since your "date" variable contains in fact a datetime value.

Re: Date

PaigeMiller — Mon, 06 Sep 2021 20:07:01 GMT

Advice: don't create your own text strings or numbers to represent dates. If you do that, and then at some point need to know what 6 months before 202004 is, you then have to program your own calculations as well.

If you use SAS date values, these will always be more useful then your own text strings. Example from @Kurt_Bremser shows how. Then, calculations are built into SAS via the INTCK and INTNX function, so you don't have to program these calculations yourself.

Re: Date

sbxkoenk — Mon, 06 Sep 2021 20:16:24 GMT

> Advice: don't create your own text strings or numbers to represent dates. If you do that, and then at some point need to know what 6 months before 202004 is, you then have to program your own calculations as well.

You are absolutely right !!

I was too quick with my answer (and its variable 'c'), sorry. 🙄

Koen