Hi All, I am new to proc power procedure and need your help calculating sample size for two groups of unequal sizes. I have a population split into two groups 60% test and 40% control. Wanted to calculate sample size for my two unequal groups with couple scenarios: I want to test the Difference in means between two groups of 30 bps,50bps and 100 bps where mean1=0.65 .With alpha 0.05 and power 0.80. Any help would be greatly appreciated.   ... View more

HI Trying to run the code below but keep on getting an error  ERROR: ORACLE prepare error: ORA-00933: SQL command not properly ended. Can you help me figure out why ? See code below: PROC SQL; CONNECT TO ORACLE (PATH = COLLP USER = &USERID. PASSWORD = &PWD.); CREATE TABLE mytable  AS SELECT * FROM CONNECTION TO ORACLE ( SELECT lf.list_name, lf.priority, wk.call_id, wk.parent_call_id, dl.mds_rec_id, dl.acct_contact_key, dl.system_no, dl.principle_num, dl.file_date, dl.DWNLD_DT, CASE WHEN ex.mds_field_value IS NULL THEN 'N' ELSE 'Y' END as Excluded_Account_Flag, CASE WHEN exZip.mds_field_value IS NULL THEN 'N' ELSE 'Y' END as Excluded_Zip_Flag, CASE WHEN dl.days_delq <= '029' THEN '1' WHEN dl.days_delq <= '059' THEN '2' WHEN dl.days_delq <= '089' THEN '3' WHEN dl.days_delq <= '119' THEN '4' WHEN dl.days_delq <= '149' THEN '5' WHEN dl.days_delq <= '179' THEN '6' WHEN dl.days_delq <= '209' THEN '7' ELSE '0' END as Due_Stage, wk.sso_id, dl.min_tz , dl.max_tz, wk.mds_status, wk.mds_term_cd, acl.ACTION_DESC as ACTION_DESC, SUM(acl.ATTEMPT_CNT) as ATTEMPT_CNT, SUM(acl.CALL_CNT) as CALL_CNT, SUM(acl.CONNECT_CNT) as CONNECT_CNT, SUM(acl.CONTACT_CNT) as CONTACT_CNT, SUM(acl.CUST_CALL_CNT) as CUST_CALL_CNT, SUM(acl.FIND_CNT) as FIND_CNT, SUM(acl.NO_PROMISE_CNT) as NO_PROMISE_CNT, SUM(acl.PROMISE_CNT) as PROMISE_CNT, SUM(acl.RPC_CNT) as RPC_CNT, COUNT(DISTINCT CASE WHEN dl.HOME_PH = '0000000000' AND dl.MOBILE_NUMBER = '0000000000' AND dl.WORK_PH = '0000000000' AND dl.FAX_PH = '0000000000' AND dl.PAGER_PH = '0000000000' THEN dl.mds_rec_id ELSE NULL END) as No_Phone_Accounts, COUNT(DISTINCT CASE WHEN wk.mds_term_cd = 'ML' THEN wk.mds_rec_id ELSE NULL END) as Just_Looking, SUM(dl.mds_acct_status) as mds_acct_status_attempts FROM mpoc.dbo.MDS_LOAD_FACT dl LEFT JOIN MDS_EXCLUSION_FACT ex on dl.acct_contact_key = ex.mds_field_value and ex.header_date = dl.header_date LEFT JOIN MDS_EXCLUSION_FACT exZip on dl.zip = exZip.mds_field_value and exZip.header_date = dl.header_date LEFT JOIN MDS_ACTV_WKST_FACT wk on dl.acct_contact_key = wk.acct_contact_key and dl.header_date = wk.header_date LEFT JOIN dbo.action_cd_lkup acl on wk.mds_term_cd = acl.action_cd LEFT JOIN MDS_LISTS_PRIORITY_FACT lf on lf.acct_contact_key = dl.acct_contact_key and lf.header_date = dl.header_date where dl.file_dt >='01Jan2019'd and dl.file_dt<='28Feb2019'd); QUIT; ... View more

Hi All, I am new to SAS  macros and I am literally awful at doing it ! I have 100 random digits 00-99 and want to t-test their interaction  with SAS. For example test cell 00 with 1-99 other cells,test cell 1 with 00 and 2-99 cells. Is there a way to write a macro that will do this ? So  say i=00-99 and j=00-99; run the test if i=00 with j which is between 1 and 99 .if i=j then do not test so do not test same cells . Is there an easy way to do this ? Please help Thanks in advance Ivy ... View more

Hi ,I am new to SAS . I need to pull statement data by month as of Jan 2014 . Each month of data 1,2,3,4,5,6,months of performance for base month. (so for Jan 14 I pull Feb,Mar,Apr,May,Jun,Jul 14 data to check performance,for Feb2014 I pull Mar,Apr,May,Jun,Jul, August 2014 , etc.) I need to do that for January 2014   Aug 18. Which is 56 months and each month has 6 months pf perf. Something like this below. For I iteration =1 I have base month and track performance by 6 different dates. etc... I base_month m1 m2 m3 m4 m5 m6 1 201401 201402 201403 201404 201405 201406 201407 2 201402 201403 201404 201405 201406 201407 201408 3 201403 201404 201405 201406 201407 201408 201409 4 201404 201405 201406 201407 201408 201409 201410 5 201405 201406 201407 201408 201409 201410 201411 6 201406 201407 201408 201409 201410 201411 201412 7 201407 201408 201409 201410 201411 201412 201501 8 201408 201409 201410 201411 201412 201501 201502 9 201409 201410 201411 201412 201501 201502 201503 10 201410 201411 201412 201501 201502 201503 201504 11 201411 201412 201501 201502 201503 201504 201505 12 201412 201501 201502 201503 201504 201505 201506 13 201501 201502 201503 201504 201505 201506 201507 14 201502 201503 201504 201505 201506 201507 201508 15 201503 201504 201505 201506 201507 201508 201509 16 201504 201505 201506 201507 201508 201509 201510 17 201505 201506 201507 201508 201509 201510 201511 18 201506 201507 201508 201509 201510 201511 201512 19 201507 201508 201509 201510 201511 201512 201601 20 201508 201509 201510 201511 201512 201601 201602 21 201509 201510 201511 201512 201601 201602 201603 22 201510 201511 201512 201601 201602 201603 201604 23 201511 201512 201601 201602 201603 201604 201605 24 201512 201601 201602 201603 201604 201605 201606 25 201601 201602 201603 201604 201605 201606 201607 26 201602 201603 201604 201605 201606 201607 201608 27 201603 201604 201605 201606 201607 201608 201609 28 201604 201605 201606 201607 201608 201609 201610 29 201605 201606 201607 201608 201609 201610 201611 30 201606 201607 201608 201609 201610 201611 201612 31 201607 201608 201609 201610 201611 201612 201701 32 201608 201609 201610 201611 201612 201701 201702 33 201609 201610 201611 201612 201701 201702 201703 34 201610 201611 201612 201701 201702 201703 201704 35 201611 201612 201701 201702 201703 201704 201705 36 201612 201701 201702 201703 201704 201705 201706 37 201701 201702 201703 201704 201705 201706 201707 38 201702 201703 201704 201705 201706 201707 201708 39 201703 201704 201705 201706 201707 201708 201709 40 201704 201705 201706 201707 201708 201709 201710 41 201705 201706 201707 201708 201709 201710 201711 42 201706 201707 201708 201709 201710 201711 201712 43 201707 201708 201709 201710 201711 201712 201801 44 201708 201709 201710 201711 201712 201801 201802 45 201709 201710 201711 201712 201801 201802 201803 46 201710 201711 201712 201801 201802 201803 201804 47 201711 201712 201801 201802 201803 201804 201805 48 201712 201801 201802 201803 201804 201805 201806 49 201801 201802 201803 201804 201805 201806 201807 50 201802 201803 201804 201805 201806 201807 201808 51 201803 201804 201805 201806 201807 201808 201809 52 201804 201805 201806 201807 201808 201809 201810 53 201805 201806 201807 201808 201809 201810 201811 54 201806 201807 201808 201809 201810 201811 201812 55 201807 201808 201809 201810 201811 201812 201901 56 201808 201809 201810 201811 201812 201901 201902 Is there a way to create a Macro that will help me run this code so many times?     ... View more