Search results for query: *

Hello Chris, Sorry about not getting back to you sooner, I went on vacation. I tried your recommendation today but I got the same results, the column attributes are still character. Here's the code I tried using your suggestion: Data tollfree (drop = access_typ usg_calls bill_min bill_secs...

Per your request, here's some raw data from the dataset MCN ACCT_NUM IB_SUBACCT SRVC_TYPE ACCESS_TYP BTN DIALED_800 10002628740 18000019879 1865800544604 810 05 0001 8005420027 10002628740 18000019879 1865800544604 810 10 0001 8005420027 10002628740 18000019879 1865800544604 810 20 0001...

Thanks for the reply, when I tried your code the column atrributes is still character. The toll free numbers in the variable DIALED_800 do not have commas. Here's the log data after I tried it again, 180 Data tollfree_1 (drop = access_typ usg_calls bill_min bill_secs bill_tenth usg_amt...

Hello, I'm trying to convert a variable that has multiple toll free numbers to numeric. When I import the dataset from a .dbf it sets the column attribute to character. I've tried using different variations of code but to no avail. I'm self taught in SAS so I'm not sure if I'm using the right...

Perfect, thanks for the help.

Thank you so much, it will avgerge the data no but if the source cells are null I get the #VALUE error in the summary sheet. I thought if I used the logical test it would make the summary cell blank? -Scott

Hello, I'm trying create a formula on a summary Excel worksheet that will average cells from different worksheets within the same workbook. But as the formula stands now I'm getting errors. Here's the formula I thought would work: =IF('FY07 CLAIMS'!I27,'FY07 CUST SVC CNCL'!I28=0,0...

Thanks for the reply, I managed to create the results I was seeking after all.

Hello, I've been trying to figure out a way to sum similiar observations to create a total. The programs below display IVR usage for the English and Spanish modules. How can I add the event results together to create one dataset? PROC SQL; create table in101 as select calr_id, event...

Thank you both.

That would work if the all cells contained the same number of characters. As in the sample, the next to last cell has fewer minutes that the rest

Hello, First time poster long time reader. I've imported a dataset from another source that displays call information. The time field is in a Minutes:Seconds:Tenths format. I've used the =ISTEXT() and the response is TRUE. How do I format and sum the row to achieve the same results in the...