Maybe not as easy as I'd hoped. So every record associated with i=1 is 1/1/2017, i=2 is 2/1/2017, etc. So I was hoping just to add in a date variable as follows: format date mmddyy10.; if i=1 then date=01/01/2017; else if i=2 then date = 02/01/2017; else if i=3 then date=03/01/2017; however, all my dates are showing as 01/01/1960. I'm trying to merge join this file with another (left join using proc sql) using date as one of the keys, so somehow I need to get dates or some sort of translating language into the file I'm creating here. If the date should be showing up as a variable in the initial file and I just need to tweak the code that is fine, or if there is a simpler way to hardcode this in that will suffice for now (I really only the need the actual date in there right now to compare files/testing, moving forward it would only be needed to troubleshoot which is why while not ideal, hardcoding will work for now). Thanks!
... View more