I have one column that demonstrate each people's birthd.
Column contains 2million people's information(each are different and format yymmdd8. / ex : 19910111)
I want to dadd 65days to each people's birthd.
Much help appreciated. Thanks. Jamie.
To do this, you will need to study a little on how SAS handles dates. If BIRTHDT were actually a SAS date, you could just use:
newvar = birthdt + 65;
format newvar yymmdd10.;
However, I suspect that BIRTHDT is really just a number and 19110111 is really just 19,110,111. In that case, it needs to be converted to a SAS date first:
birthdt = input(put(birthdt,8.), yymmdd8.);
format birthdt yymmdd10.;
Then you can use newvar = birthdt + 65;
To do this, you will need to study a little on how SAS handles dates. If BIRTHDT were actually a SAS date, you could just use:
newvar = birthdt + 65;
format newvar yymmdd10.;
However, I suspect that BIRTHDT is really just a number and 19110111 is really just 19,110,111. In that case, it needs to be converted to a SAS date first:
birthdt = input(put(birthdt,8.), yymmdd8.);
format birthdt yymmdd10.;
Then you can use newvar = birthdt + 65;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.