I can not get what exactly "(" should be placed in the codes How to solve this? data trans_summary(drop=txn_amt_rmb); set trans_list; by party_id plus_minus_flag; retain sum_rmb; if first.plus_minus_flag then sum_rmb=0; sum_rmb=(sum_rmb,txn_amt_rmb); if last.plus_minus_flag then output; run; ... View more

How to understand weight variable here?what is it for?redm_flag=0 means negative samples.   proc surveyselect data=lg.develop_original(where=( redm_flag =0)) noprint method=srs rate=0.1 out=lg.develop_sury ; run; data lg.develop_final; set lg.develop_ original(where=( redm_flag =1)) lg.develop_sury; if redm_flag=1 then weight=1; else weight=10; run; proc freq data= lg.develop_final; weight weight; table redm_flag/missing; run;   ... View more

I have a table in SAS work.mytable,how to create it into hadoop.this way will not work:   proc sql; connect to hadoop( server=xxx user=sas password=xxx schema=xxx subprotocol=hive2 hdfs_tempdir='/tmp/sastemp/' properties=xxx ); select * from connection to hadoop( create table sas_card_tmp.test01 as ) select * from work.mytable; disconnect from hadoop; quit; ... View more

Hi,someone know summary statement please help me with the explanation  of line with number below. I have written the annotation as I understood my way,however they are not the situation when I check it back in the excel file. Thanks in advance! data ccm_base_trans_3m; retain txn_amt_rmb_08 txn_amt_rmb_09 0; set ccm_base_trans(drop=event_id org where=("1jul2014"d le eff_date le "30sep2014"d)); if "1aug2014"d le eff_date le "31aug2014"d then do; txn_amt_rmb_08=txn_amt_rmb; end; if "1sep2014"d le eff_date le "30sep2014"d then do; txn_amt_rmb_09=txn_amt_rmb; txn_date=datepart(eff_date); end; length mcc_desc $200.; mcc_desc=put(mcc,$mcc.); run; proc summary data=ccm_base_trans_3m(keep=becif_custid txn_amt_rmb txn_amt_rmb_08 txn_amt_rmb_09 eff_date) nway missing; /*each becif_custid*/ class becif_custid; var txn_amt_rmb txn_amt_rmb_08 txn_amt_rmb_09 eff_date; output out=ccm_base_trans_3m(rename=(_freq_=p3m_sum_cnt) drop=_type_) /*1.count of txn_amt_rmb for each becif_custid*/ sum(txn_amt_rmb) =p3m_sum_cnt /*2.sum of txn_amt_rmb_08 for each becif_custid*/ sum(txn_amt_rmb_08)=txn_amt_rmb_08 /*3.sum of txn_amt_rmb_09 for each becif_custid*/ sum(txn_amt_rmb_09)=txn_amt_rmb_09 /*4.last date of eff_date for each becif_custid*/ max(eff_date)=last_txn_date; run; ... View more

Anyone has SAS macro to create tables according to a column values? Column id has 3 values (a,b,c),and create thress tables by this column. original:   id spend lend a 10.1 0.5 a 5.5 7 b 1.2 2 c 3 6 b 6 3.1       id_a:     id spend lend a 10.1 0.5 a 5.5 7       id_b:     id spend lend b 1.2 2 b 6 3.1       id_c:     id spend lend c 3 6 ... View more

Could someone familiar with sas change sql into data step.thank you for your attention proc sql noprint; create table temp as select A.a,A.b,A.c,A.d, put(datepart(A.e),YYMMDDN8.) as e, case when A.f is null then calculated e else A.f end as f, put(datepart(A.g),YYMMDDN8.) as g, put(datepart(A.h),YYMMDDN8.) as h, B.city, B.channel from tableA(where=("20150501" le batch_date le "20150519")) A left join (select distinct a,f,city,channel from tableB) B on A.a=B.a order by 1; quit;   ... View more