topic Re: Substr Functions in Statistical Procedures

Substr Functions

Yondori — Thu, 06 Jun 2013 15:34:43 GMT

I have my own dataset as follows

Now Birthday is like yyyymmdd (e.g. 20011011)

and I want to make it seperately like

B_Year B_Month B_Day

2001 10 11

But, how can I do this?

I tried to make it using substr function but, it doesn't work.

maybe because it is numeric format or somehing. but, Is there any way that I can extract it separtely?

Re: Substr Functions

Astounding — Thu, 06 Jun 2013 16:18:20 GMT

You'll have to tell us more about the variable BIRTHDAY.

Is it character or numeric?

If numeric, does it actually take on the value that you have displayed, or is that a formatted value based on the scale that SAS normally uses for dates?

Once we know those answers, the programming will be easy.

Re: Substr Functions

ballardw — Thu, 06 Jun 2013 16:24:31 GMT

Is the date a SAS date value, possibly with a yymmddn8. format? If so then the date functions would be appropriate

B_year= year(birthday);

B_Month=month(birthday);

B_Day = day(birthday).

if you want a text result and the birthday is a simple number then something like this may work:

b_year = substr(put(birthday,f8.0),1,4);

b_month= substr(put(birthday,f8.0),5,2);

b_day = substr(put(birthday,f8.0),7,2);

Re: Substr Functions

Yondori — Fri, 07 Jun 2013 07:56:23 GMT

it was numeric value.

Thanks~ it worked~!