Generally variable names in SAS are not allowed to start with digits. Examine your data set r_test to douple check. If so then they are called "name literals" and because they violate the standard naming conventions each one needs to be enclosed in parentheses and followed with n    '11111'n for example. It is possible that you are seeing a LABEL and not the actual variable's name. Use Proc Content or your other preferred tool for examining data set description information. ... View more

Please post the whole query and the table datatypes which are involved in any type of calculation for this. ... View more

Ok Good 🙂 ... View more

data _null_; chardate = '01/31/2017'; date = input(chardate, mmddyy10.); format date date9.; put date; run; ... View more

I'm with @Tom on this. I read lots of files with that date (almost time) field as dates because the data source exposes data as date and time but the time values are invariate (all 12:00:00 AM for example). Why anyone lets "time" become part of something when it never changes continues to annoy me greately. ... View more

I am with @LinusH here, the problem lies with your data supplier.  You will of course have a data import agreement setup which defines the structure, content of the data yes?  If not, then whatever you code may need to change next time you get data, I mean wht if the vendor decides to drop that field, or add a field, or change them all to DDMONYYYY?  The control and specification is all in the documentation, programming is more or less irrelevant. ... View more

At this point the question is can you go to the data source and have them clean up the dates, either provide the leading 0 as needed or separate year, month and day columns. ... View more

I would say that you can't.  You will probably need to get additional information to help decide.   You might say that 201433 could only be divided into 2014-3-3, but perhaps the missing digit is a 1 or a 2 instead of a 0.  Then the intended value could be 2014-03-13 or 2014-03-23.  Or perhaps the 4 is the typo and it is really in ddmmyy format so that the intended value is really 1933-12-20.   ... View more