Hello everyone   i'm trying to create a STP in EG, to allow user to manually type their comment, to save in dataset colume, for corresponding record.   i have tried following:   Step 1:  create a customer data column (name as "user_comment") via advance expression like:  &user_comment   Step 2:  create a filter as "user_comment = $user_comment"   Step 3:  in Prompt Manager, create a prompt as text (multi-line)   Step: 4:  run the process, to see if i can manually type comment, and save in that customer column.   but i found it doesn't work as i thought, it shows error like "can not find column".   would it be possible to guide me how to achieve my purpose if above way is not right?   Thank you very much in advance.   ... View more

hello    i'm now trying to convert data comparing function which today i'm using Excel Macro to do, to SAS program, so that i can use for further purpose in SAS tool.   Data comparing is performed between 2 data table, one is actual data, one is template data:   Actual Data   Identity Value 1 Value 2 2563 41 2562700 2611 83 3644700         Template Data Identity Template 1 Template 2 2342 22;33;35;52;91 2340300 2522 82;83 2522400;2522800 2524 27;82;83;71 2522800 2563 31;41 2560300;2562700 2611 24;82 2610800 2631 29 2631800   As you can see, the comparison is:   1. Search "identity" in Actual data can be found in "identity" in Template data or not, row by row until end. 2. if found, comparing Value 1 with Template 1 in that row, if found, then give figure 1, otherwise 0.                     comparing Value 2 with Template 2 in that row, if found, then give figure 1, otherwise 0. 3. Perform such comparing row by row in Actual data table, until the end.   Today, the excel macro code as below:   For i = 2 To maxrow1 For j = 2 To maxrow2 CLC = Sheet1.Range("I" & i).Value FG = Sheet1.Range("F" & i).Value CLC2 = Sheet2.Range("D" & j).Value If Sheet2.Range("A" & j).Value = FG And InStr(CLC2, CLC) > 0 Then Sheet1.Range("P" & i).Value = 1 GoTo Line300 Else Sheet1.Range("P" & i).Value = 0 End If Next j Line300: Next i   I'm now struggling how to achieve such function via SAS programming coding,  and would appreciate if any of you can provide some guidance here.   thank you very much in advance.   BR     ... View more

Hello Everyone   I'm trying to use CumulativePeriod function in VA to calculate a cumulative result over a period, i found result is quite strange as below:   Frequency cummlated number of claims Repair Date 43 43 2014-02 13 56 2014-03 70 126 2014-04 114 240 2014-05 303 543 2014-06 77 620 2014-07 182 802 2014-08 496 1,298 2014-09 577 1,875 2014-10 406 2,281 2014-11 562 2,843 2014-12 1,266 1,266 2015-01 1,008 2,274 2015-02 1,263 3,537 2015-03 894 4,431 2015-04 2,126 6,557 2015-05 1,516 8,073 2015-06 1,782 9,855 2015-07 1,624 11,479 2015-08 1,686 13,165 2015-09 1,170 14,335 2015-10 1,183 15,518 2015-11 936 16,454 2015-12 1,197 1,197 2016-01 1,203 2,400 2016-02 1,253 3,653 2016-03 994 4,647 2016-04 1,054 5,701 2016-05 1,159 6,860 2016-06 1,017 7,877 2016-07 856 8,733 2016-08 973 9,706 2016-09 1,884 11,590 2016-10 1,804 13,394 2016-11 944 14,338 2016-12 1,314 1,314 2017-01 1,514 2,828 2017-02 1,421 4,249 2017-03 1,424 5,673 2017-04 1,251 6,924 2017-05 1,300 8,224 2017-06 949 9,173 2017-07 664 9,837 2017-08 109 9,946 2017-09   As you may see, this function is working well until 2016-12, but seems starting from 2017-01, it started over...   below is how i set up this aggregated measure in VA:   CumulativePeriod(_Sum_, Frequency, Repair Date, _ByMonth_, _Inferred_, 0, _Full_, )   would it be possible to help me pointing out where i did wrong?  or some reason outside my control?   Thanks a lot in advance.     ... View more