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;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.