Recent content by gilsonr

I have SAS 8.2 running under Windows XP home edition. But when I open up Enterprise miner it does not display correctly, therfore is there a compatability issue.

Thanks for the response, amended the code as follows if {status} = 86 then "Live" else if {status} = 87 then "Live" else if {status} = 88 then "Live" else if {status} = 89 then "Live" else if {status} = 90 then "Live" else if {status} = 91 then "Archive" else if {status} = 97 then "Archive" else...

I have created the folloing if then else statement in a formula field if status = "86" then "Live" else if status = "87" then "Live" else if status = "88" then "Live" else if status = "89" then "Live" else if status = "90" then "Live" else if status = "91" then "Archive" else if status = "97"...

How do I extract the Month name (i.e. March) form the current date.

Ibass Thanks for the, it seems that Im going in the right direction. I have created a Running Total Formula as you suggested for a couple of the columns in the xtab. The columns are populated with values but unfortunatley they are not the correct counts. Essentailly what I am trying to create...

ShortyA Thanks for the help, I see what you mean about creating a manual x-tab , its a bit more involved. I have created the rows with no problembut Iam having trouble with the conditional formula that creates the column values. Tried the following if-then-else, but its not quite right if...

ShortyA Thanks for the response, you have summarised my problem exactly. The Column & Row Grand Totals are distinct counts, how do I amend the x-tab so that the totals add up.

ShortyA Thanks for the response. Iam using Crytal version 9.2.0.448, and I am connecting to an Oracle Database via Microsoft ODBC for Oracle. In the cross tab the summarised field values are correct, but the Grand Totals for the Rows & Columns dont add up to the correct values.

I have created a report which just contains a Cross-tab. The problem is that the values are OK, and the column totals are OK, its just the row total that are not correct. Any suggestions would be appreciated.

This is probably a really basic question, but how do I add a Grand Total to a Report

I am trying to add an authorisation field to the bottom of an Access Form. As the database is to be used for authorising Purchase Orders within the Finance department, I need to add some sort of 'Electronic Signature' to the authorisation field. This will used to track and audit who has signed...

Chrisw75 & dje thanks for the help I initially tried this code data valex.BG; set cmn.Camt_promo_history; keep contact_urn source_account response_code campaign_ID date_extracted ; where substr(response_code,1,5, in ('XP87P','XP88P','XP89P','XP90P','XP92P','XP93P'...

I am running a query against an Oracle database that stores dates in the following format 23SEP2004:00:00:00. When I try to select records for an specific day, in a where clause I dont get the correct results. I am using the Datepart function to get rid of the Hr:mm:ss. Any ideas

Formula as requested isnull({CAMP_MGT.Date Completed}) and isnull({CAMP_MGT.Dialler File 1 Loaded}) and isnull({CAMP_MGT.Dialler File 2 Loaded}) and isnull({CAMP_MGT.Dialler File 3 Loaded}) and {CAMP_MGT.Job type} <> 9 and ({CAMP_MGT.Mailing File Due Date} in DateTime (2003, 10, 01, 00, 00...

Thanks for all you help its very much appreciated. I have amended the code above to fix the problem that I was having with the bracket and it works OK. But the records I now get are lower than expected, as I have run the same selection in Access. My guess at the formula that I need to produce...