Hi @gyambqt    You don't supply information about your setup, but if the flow is scheduled to run in LSF it can be triggered from the command line (or a SAS X command) using the command:                  jtrigger flow_name   I don't know any way to trigger the flow if the flow is defined in MC and nothing more.  ... View more

Your model has a better chance of predicting the bad if there are more bad in the data set used to create the model.   You will get a different model fit, and different predicted probabilities, if your data set is 1000:1 versus 50% good and 50% bad. ... View more

Here is .Also calculated IV .   %let var=marital ; title "变量: &var"; proc sql; create table woe_&var as select &var as group, sum(good_bad='bad') as n_bad label='bad的个数',sum(good_bad='good') as n_good label='good的个数', sum(good_bad='bad')/(select sum(good_bad='bad') from have ) as bad_dist format=percent7.2 label='bad的占比', sum(good_bad='good')/(select sum(good_bad='good') from have ) as good_dist format=percent7.2 label='good的占比', log(calculated Bad_Dist/calculated Good_Dist) as woe from have group by &var order by woe; select *,sum( (Bad_Dist-Good_Dist)*woe ) as iv from woe_&var ; quit; ... View more

@Reeza wrote: If your model hasn't been trained with that category, it cannot predict for that category. In those cases, other methods are required - one is to look at a clustering analysis and see which category is most similar and slot it in to that category but it very contextually dependent on how you deal with this situation. This assumes that category 3 can be clustered with a similar category, in which case it's a reasonable thing to do; but there's no guarantee that a new category does cluster well with other categories. ... View more

data temp; input ID (v1 v2 v3) (:$1.); datalines; 1 a . . 2 a b . 3 . b d 4 . . d 5 a . . ; data have(rename=(_id=from v=to)); set temp; _id=put(id,best. -l); array _v v:; do i = 1 to dim(_v); if not missing(_v{i}) then do; v = _v{i}; output; end; end; keep _id v; run; data full; set have end=last; if _n_ eq 1 then do; declare hash h(); h.definekey('node'); h.definedata('node'); h.definedone(); end; output; node=from; h.replace(); from=to; to=node; output; node=from; h.replace(); if last then h.output(dataset:'node'); drop node; run; data want(keep=node household); declare hash ha(ordered:'a'); declare hiter hi('ha'); ha.definekey('count'); ha.definedata('last'); ha.definedone(); declare hash _ha(hashexp: 20); _ha.definekey('key'); _ha.definedone(); if 0 then set full; declare hash from_to(dataset:'full(where=(from is not missing and to is not missing))',hashexp:20,multidata:'y'); from_to.definekey('from'); from_to.definedata('to'); from_to.definedone(); if 0 then set node; declare hash no(dataset:'node'); declare hiter hi_no('no'); no.definekey('node'); no.definedata('node'); no.definedone(); do while(hi_no.next()=0); household+1; output; count=1; key=node;_ha.add(); last=node;ha.add(); rc=hi.first(); do while(rc=0); from=last;rx=from_to.find(); do while(rx=0); key=to;ry=_ha.check(); if ry ne 0 then do; node=to;output;rr=no.remove(key:node); key=to;_ha.add(); count+1; last=to;ha.add(); end; rx=from_to.find_next(); end; rc=hi.next(); end; ha.clear();_ha.clear(); end; stop; run; data final_want; if _n_=1 then do; if 0 then set want; declare hash h(dataset:'want'); h.definekey('node'); h.definedata('household'); h.definedone(); end; set temp; _id=put(id,best. -l); if not missing(_id) then h.find(key:_id); array _v v:; do i = 1 to dim(_v); if not missing(_v{i}) then h.find(key:_v{i}); end; drop _id i node; run; ... View more

As far as I can tell from the documentation, even in SAS Viya, the only variable lists defined seem to be _ALL_, _NUMERIC_, and _CHARACTER_. Have you tried _CHARACTER_ yet? ... View more

We changed SAS session from Latin1 to UTF8 and still receiving same error message. Inrestingly, it worked in our old environment with SAS9.4 M3  ... View more

Yes, definitely.   How to define My Week parameter Roles Details of the filter Go to Filters in the Right pane. Click + New filter. Click Advanced filter. There are two modes to create/edit filters: Visual and Text. Select Text mode from the top of the window. Copy paste this to the screen: IF ( 'My Week'p NotMissing ) RETURN ( ( TreatAs(_Number_, 'My Week'p) = ( 'Week Num'n + 1 ) ) OR ( TreatAs(_Number_, 'My Week'p) = TreatAs(_Number_, 'Week Num'n) ) ) ELSE ( 1 = 1 ) The OK button is disabled (grey). Click somewhere on the window's canvas to make the OK button activate (blue) and click OK. I didn't create "Week-1" in the VA - I had it in the data directly. The data doesn't have a proper date variable so one can't utilize f.ex. VA's period operators. Also VA doesn't have LAG function which would enable returning values from rows before. I hope this helps 😃   Best regards, Petri ... View more

Numbers are a VERY BAD IDEA for primary keys. They are limited by the 8-byte real format, which means that any string longer than ~7 bytes will lose accuracy/precision. Stay with character storage. UUID's can be stored reliably as 16-byte strings (use a $hex32. format for display). ... View more

@gyambqt wrote: Hi Patrick, I thought there might be some mathematic tricks like 12121212 is divisible by 10101 that able to solve the issue. May be. But especially because this is about the very common case of phone number validation I'd go for RegEx. There should be a lot of RegEx published on the Internet and you won't have to "invent" everything from scratch. Just search a bit and use the one closest to your needs as a starting point. ... View more

Will there ever be more than two terms for an ID? Is there a text length limit? Is it 5 characters or more? ... View more

Will there ever be more than two terms for an ID? Is there a text length limit? Is it 5 characters or more? ... View more

I realised BL_PRESERVE_BLANKS=YES will create the trailing blank for all the columns which is not the desired outcome we are seeking for.   By setting DBnull cannot be null for the column in the target oracle table, the table load option allows inserting a blank value into Oracle table. But it didn't work for the bulk load transform and want to  find out reason behind that ... View more