Patrick you are something else! :smileycool: Code works!  Thanks for the readings, fascinating stuff!  From this day forth I am going to approach the fickle creature SAS with a great deal of caution. Sorry for keeping you up late! ... View more

Hm interesting, thanks for that. If you refer to the original question, the sample of the DBF "real data" is saved there. ... View more

Just when we thought the misery was over. The code doesn't work on my full data set. My original data holds about 1.3mill observations, so I originally had this saved as a DBF file. To make the data compatible with the code, I reopened the large DBF file and saved it as a CSV in temp, C drive and renamed it TESTER. When I ran the code, the date values became blank, and the desired want database had 0 observations. See snap shot. I have attached a small sample of my real data in its DBF origin. Hopefully it is a simple tweak to get this working. ... View more

My TESTER data was saved to desktop so I altered "%let csvFile=C:\temp\tester.csv;" to "%let csvFile=desktop\tester.csv"  and couldn't get your results. So I created a temp folder in C drive and saved the TESTER data there, to prevent me from editing anything and ET VOILA it started working! So strange, I'm perplexed why location of the db would of caused conflicting results ... View more

I just read this sorry. OK so SAS dates are the way to go, I still can't narrow down the problem in my tester data. ... View more

I think this problem vests with the different SAS platforms in use. When I copy and paste your code above and my variables adopt some pretty "funky" values (see attachment). Any readers of this thread if you could please assist with the original question posted, I am looking to create a code to obtain the variable below, with using integer dates, not sas dates. (June T0) CF= (EARN+DEP)/ME (INPUTS ON THE RIGHT HAND SIDE ARE FOR DEC T-1) ... View more

If I save my data as a DBF file can we avoid the data strings/SAS dates and use integers as dates for the code above? I thought the calculation of CF in June whilst using last years DEC variables wouldn't be so difficult haha. Sigh, I followed your directions above, I was able to assemble the "want" database but I had blanks for CF1 CF2 and ME. Please see attachment ... View more

What version of SAS do you use? I am using 9.2. I click file and import and I don't receive the prompts to define field attributes. Hm this is worrisome, is it not possible to alter the code to account for dates as integers? ... View more

Seems like the intnx is causing a similar problem with my tester data, I just used the code on the sample submitted above and I received the following message: ... View more

If I wanted to change to code to recognise dates as integers instead of SAS date values. How do I do I edit the code? As a lot of the dates I address are numbers not sas dates. Thanks for your input. ... View more

Thanks is there something missing from the above code? I have received an error message (see attached). ... View more

permn number ... View more