topic Re: Please help me on below scenario ? in SAS Programming

Please help me on below scenario ?

nitin_k24 — Wed, 06 Mar 2013 13:40:41 GMT

I have a variable name Losstime which has date with time stamp

My scenario is

if losstime in between 4pm 29jan2011 (Here 4pm inclusive) to 4pm29jan2012 (Here 4pm is exclusive ) then the variable

Policy year = 2011/12 (Variable need to create as per the scenario)

if losstime in between 4pm 29jan2010 (Here 4pm inclusive) to 4pm29jan2011 (Here 4pm is exclusive ) then the variable

Policy year = 2010/11 (Variable need to create as per the scenario) etc...

Please help me with Sas and Sql code.

Re: Please help me on below scenario ?

LinusH — Wed, 06 Mar 2013 13:50:25 GMT

Is this a one time ad-hoc update?

Just use SQL update, with a set statement combined with a where clause.

Be sure that you use SAS date and datetime constants (if your data is stored correspondingly).

Re: Please help me on below scenario ?

nitin_k24 — Wed, 06 Mar 2013 13:54:00 GMT

Hi,

Losstime variable has lakhs of records. Date, month, year, time varies for every record.

Please suggest..

Re: Please help me on below scenario ?

LinusH — Wed, 06 Mar 2013 14:16:02 GMT

Don't understand, if your requirement differ from your example, give us some more flesh (example data that is)...

Re: Please help me on below scenario ?

LinusH — Wed, 06 Mar 2013 14:22:06 GMT

Sorry, now I get it!

Well, I should build a lookup-up table, containing your start and end datetime, for each policy year. Then you fetch the policy year in a join, or you could define the interval as a format, with the policy year as label (the formatted value).