Hi, I have many tables with same name conventioning for every month : TEMPCAAD.LIFT_&NOME_MODELO._&VERSAO_MODELO._'!! put(cur_month,yymmn6.)) I am trying to append all datasets but because i am doing current monht= month now and previousyearmonth= month one year ago and some datasets don't exist, how can i append them only if they exist? Here is my try:   %let currentmonth = &anomes_scores; %let previousyearmonth = &anomes_x12; data _null_; length string $1000; cur_month = input("&previousyearmonth.01",yymmdd8.); do until (cur_month > input("&currentmonth.01",yymmdd8.)); string = catx(' ',trim(string),'TEMPCAAD.LIFT_&NOME_MODELO._&VERSAO_MODELO._'!! put(cur_month,yymmn6.)); cur_month = intnx('month',cur_month,1,'b'); end; call symput('mydatasets',trim(string)); run; %macro checkds(data); %if %sysfunc(exist(data)) %then %do; data WORK.LIFTS_U6M; set data; run; %end; %mend checkds; %checkds(&mydatasets.) The problem is that it does not return anything the macro checkds   Thanks! ... View more

Hi everyone,   I am learning how to use oversampling methods in SAS Miner and I am using this tutorial : https://documentation.sas.com/doc/en/emref/14.3/p0ak10c0ywr8mrn1an7tum03sp7g.htm#p1exm858amo9ren1k17yz8e0qu5s   I completly understant when to use the decisions node and what the priors are but when they explain how to fill the decision weights, i don't understand how they calculate the inverse prior:   "enter the decision weights as shown in the figure above. For level GOOD, column DECISION1, enter the inverse prior value for the original proportion (0.05) of rare events: 1.0526. For level BAD, column DECISION2, enter the inverse value prior for the original proportion (0.95) of non-events: 20.0. All other values in the matrix should be 0.0. Click OK. Now your Decisions node is configured."   Can someone help me here? ... View more

Hi everyone! I have a dataset with policies date began between 2018-01-01 and 2019-12-31 (2 years) that has the following info: policy policy_beg_date policy_end_date a 01-02-2018 06-02-2018 b 04-02-2019 02-04-2020 c 23-12-2019 03-02-2020 d 02-02-2019 policy begining date (date that policy started) and policy end date (date that policy ended - is missing if policy is still active)   I would like to create flags of 13 months (flag_0month, flag_1month,....flag_13month) where i give 1 if policy is active in month 0, month1, and so on....where month0 is the month of beginnig, month1 is month of begining + 1 and so on so i would have something like this:   policy policy_beg_date policy_end_date month_begining month_end act_month0 act_month1 act_month2 a 01-01-2018 06-01-2018 201801 201801 1 b 04-02-2019 02-04-2020 201902 202003 1 1 1 c 23-12-2019 03-02-2020 201912 202002 1 1 1 d 02-02-2019 201902 1 1 1 Can anyone please help me achivieng this? I already tryied someting like in this post : https://communities.sas.com/t5/SAS-Programming/How-to-create-a-flag-for-each-month-lying-between-2-dates/td-p/433331 but i get errors and i think it's not the same as i need.   Thank you!!   ... View more

Hi everyone, hope to find you well!   I have a table called "policies" that has the following data:   Date_begin_policy Customer_id Policy_id 01-09-2019 A 111 02-10-2019 A 123 09-07-2019 A 126 and i want to build 2 columns "has_policy_month_before" and "has_policy_month_less2" that for each date_begin_policy checks if customer has already other policies in date_begin_policy -1month and date_begin_policy - 2 month: Date_begin_policy Customer_id Policy_id has_policy_month_before has_policy_month_less2 01-09-2019 A 111 no yes 02-10-2019 A 123 yes no 09-07-2019 A 126 no no I would do it like this in Teradata sql: select t1.customer_id , t1.policy_id , t1.date_begin_policy , case when trunc(t2.date_begin_policy, 'mm') >= add_months(trunc(t1.date_begin_policy, 'mm'), -1) then 'yes' else 'no' end as has_policy_month_before , case when trunc(t2.date_begin_policy, 'mm') < add_months(trunc(t1.date_begin_policy, 'mm'), -1) then 'yes' else 'no' end as has_policy_month_less2 from mvt_data as t1 left join mvt_data as t2 on t2.customer_id = t1.customer_id and trunc(t2.date_begin_policy, 'mm') >= add_months(trunc(t1.date_begin_policy, 'mm'), -2) and trunc(t2.date_begin_policy, 'mm') < trunc(t1.date_begin_policy, 'mm') where t1.customer_id = 'A' order by t1.policy_id asc; but the problem is the add_months function and the trunc function are not like this in SAS. Could anyone please help me?    Please note i really would like to do it in sql and not sas syntax preferably.  Thanks ... View more