topic Re: Splitting the Numberic value in SAS Programming

Splitting the Numberic value

Vinayakumar — Fri, 24 Nov 2017 20:29:47 GMT

I need help in the following:-

1. I need to convert the numberic variable 20171223 to a date 23DEC2017

2. I need to split a numberic variable 20171223 to numeric variables 2017 12 and 23.

Thanks.

Vinay

vinayradhi@gmail.com

Kurt_Bremser — Fri, 24 Nov 2017 20:43:36 GMT

#1:

newvar = input(put(oldvar,8.),yymmdd8.);

#2:

day = mod(oldvar,100);
month = mod(int(oldvar/100),100);
year = int(oldvar/10000);