Please help me on below scenario ?

Reply
New Contributor
Posts: 4

Please help me on below scenario ?

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.

Super User
Posts: 5,255

Re: Please help me on below scenario ?

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).

Data never sleeps
New Contributor
Posts: 4

Re: Please help me on below scenario ?

Hi,

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

Please suggest..

Super User
Posts: 5,255

Re: Please help me on below scenario ?

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

Data never sleeps
Super User
Posts: 5,255

Re: Please help me on below scenario ?

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).

Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 970 views
  • 0 likes
  • 2 in conversation