Sorry for the late response.   I did another quick look through and it looks like it is just those four. Did not realize I was worried about just needing to fix four. Thank you very much.   ... View more

There are a bunch of datasets with the same issue. I am not sure how to figure out what causes the problem either. I simply just copied the contents of the link and followed the instructions to generate the data. ... View more

Thank you.   Would I have to just manually rewrite the code for each affected dataset then? ... View more

Thank you, that seemed to fix the log errors for invalid data, but some datasets still have incorrect/missing data. For example:   data budget2; input Manager $1-7 Job_Type 9-11 WageCat $13-14 WageRate 16-21 Yearly_Salary 24-31 Payroll 33-43; datalines; Coxe 3 S 3392.50 40710.0 40710.0 Coxe 50 S 3420.00 41040.0 41040.0 Coxe 50 S 6862.50 82350.0 123390.0 Coxe 240 H 13.65 27300.0 27300.0 Coxe 240 S 4522.50 54270.0 81570.0 Delgado 240 S 2960.00 35520.0 35520.0 Delgado 240 S 5260.00 63120.0 98640.0 Delgado 420 S 1572.50 18870.0 18870.0 Delgado 420 S 3819.20 45830.0 64700.4 Delgado 440 S 1813.30 21759.6 21759.6 Overby 1 S 6855.90 82270.8 82270.8 Overby 5 S 4045.80 48550.2 48549.6 Overby 10 S 4480.50 53766.0 53766.0 Overby 20 S 5910.80 70929.0 70929.0 Overby 20 S 9073.80 108850.0 179815.2 ; run; I guess there isn't a fix all line of code, and I would just have to live with it. Also according to what @sabisw pointed out the inherent flaw of the sampledata when used in SAS Studio.   ... View more

The code you posted does not seem to work. ... View more

Ok thank you for your patience and help. I was hoping there was a way. ... View more

This is what the log shows   Maybe I can say it this way. This doesn't work. data datechange; set pg1.eu_occ; Newdate=input("2018M03",anydtdte32.); format NewDate yymm10.; run; But this works data datechange; set pg1.eu_occ; Newdate=input("2018-03",anydtdte32.); format NewDate yymm10.; run; ... View more

I am not sure what more you want. data datechange; set pg1.eu_occ; /* YearMon=tranwrd(YearMon, "M", "-"); */ Newdate=input(YearMon, anydtdte32.); format Newdate date9.; run; I used that, and the output is the same as in the picture in post one. I replaced "date9" with many other formats and it does not work. ... View more

Are you talking about line 6? If so, it does not return back any value. ... View more

Hello,   Thank you for responding. I am trying to figure out any valid date format, it doesn't matter. I was experimenting on how to change the variable YearMon to another date format, but I wasn't having any luck in doing it. data datechange; set pg1.eu_occ; /* YearMon=tranwrd(YearMon, "M", "-"); */ Newdate=input(YearMon, anydtdte32.); format Newdate yymm10.; run;     ... View more