How to convert Numeric date format YYMMDDn8. to numeric DDMMYYn8.

[Kurt_Bremser]

I merged this back into the thread with the original question. Please keep questions and answers on the same subject in the same thread.

[vnreddy]

@Kurt_Bremser  thank you for mapping this.

Thought i posted the ? in wrong group...infact i am working on DI thought of posting in right platform.

[Tom · Accepted solution]

---

@vnreddy wrote:

Hi @Kurt_Bremser 

Variable is in Numeric format.

No format is attached to it, i want the output column as well to be in Numeric format.

---

In SAS a format is instructions for how to display the values.  You are using the word FORMAT when you mean TYPE.  SAS has two types of variables, fixed length strings and floating point numbers.

You want to convert a number to another number. You want to treat the original numbers as if they are in the form YY,YYM,MDD (so the tens and ones place are the day of the month) and treat the target numbers as if they are in the form DD,MMY,YYY (so the tens are ones place are the year within the century).

So use PUT + Z8. format to convert the original number to text. Then use INPUT() + YYMMDD. informat to convert that text into a date number.  Then you can use PUT() + DDMMYYN format to convert that date into a string in the right style. Now you can use an INPUT() function with the normal numeric informat to convert that string into a number.

want = input(put(input(put(have,z8.),yymmdd8.),ddmmyyn8.),8.);