topic Need to help to create new variables from date_variables "01Jan2005" in SAS Programming

Need to help to create new variables from date_variables "01Jan2005"

Cathy — Wed, 06 Apr 2016 01:39:28 GMT

I would like to know how I can create three variables date, month and year from date_variable (example: 01Jan2005). I have a column of date_variable,but I want to extract it into date_variable, month_variable, and year_variable. Please suggest me. Thanks.

Re: Need to help to create new variables from date_variables "01Jan2005"

Cathy — Wed, 06 Apr 2016 01:50:33 GMT

Please I need the help!Anyone knows?

Re: Need to help to create new variables from date_variables "01Jan2005"

Astounding — Wed, 06 Apr 2016 02:07:25 GMT

When you say your date variable might be 01JAN2005 ... it makes a big difference whether or not this is stored as a character string. It also makes a big difference as to what you want the output to be. So, assuming your original variable is a character string, and assuming you want three numeric variables as the result, this would work:

day = input(date_var, 2.);

month = month(input(date_var, date9.));

year = year(input(date_var, date9.));

If what you want is something different, you'll have to provide more details.

Re: Need to help to create new variables from date_variables "01Jan2005"

Haikuo — Wed, 06 Apr 2016 02:10:15 GMT

Ok. see example below:

data test;
date='01jan2005'd;
day=day(date);
month=month(date);
year=year(date);
run;

However, my question for you is: what is the big picture problem you are facing?There maybe better solutions from the root or beginning.

Re: Need to help to create new variables from date_variables "01Jan2005"

PGStats — Wed, 06 Apr 2016 02:10:31 GMT

data test;
date_str = "01Jan2005";

date_var = "01Jan2005"d;
/* Or */
date_var = input("01Jan2005", date9.);

format date_var yymmdd10.;
day_var = day(date_var);
month_var = month(date_var);
year_var = year(date_var);
run;

proc print; run;

Re: Need to help to create new variables from date_variables "01Jan2005"

Cathy — Wed, 06 Apr 2016 02:20:15 GMT

Thanks a lot, it is the numeric variable. And I have a column of date_variable;
cards;
gender date_variabe
F 01Jan2005
M 04Sep2007
M 09Oct2008
;
I want to create new 3 variables from date_variables, and I did as you suggested

day = input(date_var, 2.);
month = month(input(date_var, date9.));
year = year(input(date_var, date9.));

But all the columns are blank. Thanks a lot again. I will try with the last comment that you mentioned.

Re: Need to help to create new variables from date_variables "01Jan2005"

Cathy — Wed, 06 Apr 2016 02:35:44 GMT

Thanks a lot Haikuo, Astounding, and PGStats. I got it, finally. It took me 3 or 4 days to understand. I am so happy now. Thanks again.