Search results for query: *

Hey, I think the problem is that your projstdate and projenddate are in a datetime format not a date format. You need to take the datepart of these and then do your difference. I'm not sure if you can do it in a %let statement just by putting datepart(projectstdate)-datepart(projectstdate) or...

Hey, Have a look at my reply to a different query raised - you want to do something similar to this: http://www.tek-tips.com/viewthread.cfm?qid=1629289&page=1

But is it stored as a character field rather than a date field? Your error suggests that 01JAN2009 for example is a character field which it's then trying to change to a numeric to carry out the numeric date comparison on and it's causing an error. SAS dates work by linking a date to the number...

What format is your "date" variable in rf300l3.w_status_foup_count??

Hey, There may be an easier way to do it, but one method is using proc transpose. You'd have to play around with the sex field first - i'd probably remove that row, sort out the rest and then add it back in. But if you assume you start off with the following dataset called "test": Patient...

Hi, Does anyone know if this can be done? We currently have ODBC links from our SQL databases to SAS set up as libnames which work great, but I don't know how to set up a similar connection to an OLAP cube built in SSAS (sql server analysis services). Any ideas?