DATA Step, Macro, Functions and more

Splitting the Numberic value

Reply
Senior User
Posts: 1

Splitting the Numberic value

Hi  

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

Super User
Posts: 9,594

Re: Splitting the Numberic value

Posted in reply to Vinayakumar

#1:

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

#2:

day = mod(oldvar,100);
month = mod(int(oldvar/100),100);
year = int(oldvar/10000);
---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 141 views
  • 3 likes
  • 2 in conversation