About Ujjawal

Ujjawal · ‎11-22-2017

I am working on building a fraud model for insurance company. I have close to 2000 frauds and more than 1M non-fraud claims. Some of the "non-fraud" claims are "fraud" claims in reality as some claims are incorrectly captured and tagged as "non-frauds" in data. I need to identify the claims which are likely to be fraud but tagged as non-fraud. I was thinking to find similarity (distance) between "fraud claims" and "non-fraud claims". If the similarity is low, it means these are non-fraud claims. Can clustering (k-mean) solve this problem? If i take k=2 and run k-mean clustering, ideally all [my fraud plus "can-be fraud"] claims and non-fraud claims should fall under different clusters. I have mixed variables so k-mean won't work properly. Any other algorithm to solve this problem?

Ujjawal · ‎09-23-2017

I am trying to calculate forecasted value using moving average. I am getting different result using PROC EXPAND and PROC ARIMA Proc expand data= data1 out= new_mydata; convert sales = sales_movave / transformout=(movave 3); run; proc arima data=WORK.DATA1 plots=none out=WORK.out0001; identify var=Sales; estimate p=(1 2 3) ar=(0.3333333333333333 0.3333333333333333 0.3333333333333333) noint method=ULS; forecast lead=12; run; quit;

Ujjawal · ‎02-25-2017

Is there any way to load code when new session of SAS EG? I meant whenever a NEW SAS EG project gets opened, some useful programs also load. It's like bookmark / favourites in SAS EG. The idea is not to spend time in finding the code that's frequently used. One more question - SAS EG clears history of previously submitted code. Is there any way to keep it like base SAS?

Ujjawal · ‎12-26-2016

data temp; input idno abbrivation $ Amt; cards; 101 asd 2000 102 dfg 2000 ; run; data want; set temp (where=(idno = 101)); set temp (rename=(idno =idno1 abbrivation=abbrivation1 Amt=Amt1) where=(idno1 = 102)); Difference = Amt - Amt1; proc print; run; You can google 'Multiple use of SET statement' to know more about it.

Ujjawal · ‎12-26-2016

data temp; input idno abbrivation $ Amt; cards; 101 asd 2000 102 dfg 2000 ; run; data want; set temp (where=(idno = 101)); set temp (where=(idno1 = 102) rename=(idno =idno1 abbrivation=abbrivation1 Amt=Amt1)); Difference = Amt - Amt1; proc print; run; Google 'Use of Multiple Set Statement' to read more about it. Check out this link - Use of Multiple SET statement

Ujjawal · ‎12-15-2016

Thanks a ton. What an elegant solution! Would you mind explaining how it works? I didn't get what second WHICHC is doing.

Ujjawal · ‎12-15-2016

Hi Team, I have data in the following form - var1 A A C D C D A A B C D E E A B E I want the above data in the following form - A B C D E 1 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 1 0 1 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 I want to create a binary flag for each of the distinct values of a variable and create variables accordingly.

Ujjawal · ‎12-12-2016

I want to use the other variable when filter is cleared from dropdown. In other words, I want to refer the different variable when data is shown at overall level (which means clearing filter). Is it possible via parameter?

Ujjawal · ‎12-03-2016

Thanks @RobPratt. You have been very helpful. I've made a good progress in learning PROC OPTMODEL and credit goes to you for providing links and clarifying doubts with examples. Last question - Why do we need to write 1 in the following statement? sum {c in customers: product[c] IN {'A', 'B'}} 1 Can't we simple write (without 1) - sum {c in customers: product[c] IN {'A', 'B'}} I remember you provided the similar solution wherein you mentioned 1 before dividing by 3- ceil(sum {c in customers: sales[c] > 50} 1 / 3)

Ujjawal · ‎12-03-2016

Thanks @RobPratt for your reply. Very much appreciated! Is sum {c in customers: product[c] IN {'A', 'B'}} equivalent to sum {c in customers} (product[c] IN {'A', 'B'})? I get confused with ':' symbol. Does it represent AND condition? Many times i see ':' is not required to apply AND condition.

Ujjawal · ‎12-02-2016

Is there any way we can change length of the variable created with CREATE DATA statement? I have a text variable which is used as a key variable in PROC OPTMODEL but it gets truncated in the data which is created with CREATE DATA statement. I am new to PROC OPTMODEL. Could you also please give a example of how OR condition is used in constraint? For example, sum {c in customers} (product[c] IN ('A', 'B'))

Ujjawal · ‎12-01-2016

I want to calculate distinct count by group. When i tried to create aggregate measure and use distinct count, it returns an error as variable is character (see the variable 'code' below) ID flag Code 1 0 B1 1 0 B1 1 0 B2 1 1 A1 1 1 A1 1 1 A1 2 0 D1 2 0 D1 2 1 C1 2 1 C1 I want to generate the following output in cross tab. For ID =1, it should return this output (i.e. distinct count of variable 'Code'. flag Status 0 2 1 1 I would put ID in the drop down.

Ujjawal · ‎12-01-2016

I have dataset in the following format. The first 3 variables are already there in the dataset. I want to create the fourth variable 'Status'. By each ID and Code, I look at the variable 'flag' and want to generate serial numbers in the variable 'status'. If flag = 0, it should be prefixed with P otherwise Q. Please make sure serial number increment by 1 (See the row3 and row7 in the table below). ID flag Code Status 1 0 B1 P1 1 0 B2 P2 1 0 B2 P2 1 1 A1 Q1 1 1 A2 Q2 1 1 A3 Q3 2 0 D1 P3 2 0 D1 P3 2 1 C1 Q4 2 1 C1 Q4

Ujjawal · ‎11-19-2016

I apologize for confusing you. It's the same sales parameter( changed the parameter name in my code). I have used ceil(sum {c in customers} sales[c] > 50 / 3). I am trying to calculate the number of customers having sales greater than 50.It doesn't return an error but ahows infessible solution. After all these constraints, a few customers are being ignored in the optimization. For example - there are 500 customers in the customer table. In the final result, it is assigning PMs against 497 customers. When method = comcomp is enabled, it returns 494 customers. Another thing i observed, when I use method = concomp, it doesn't return optimization result when there is out of memory. But sas returns the best possible solution when this method is disabled.

Ujjawal · ‎11-18-2016

Thank you so much. In this section of code "sum {p in PORTFOLIO_MANAGERS} UseManager[p] <= 34;", i was trying to calculate 34 from the customer's file. I added this code ' ceil(sum {c in customers} debt[c] / 3) ' instead of 34. But it does not work.

Online Status	Offline
Date Last Visited	‎02-09-2018 10:54 AM

Distance / Similarity with Events

Moving Average Forecasting

Loading code

Re: code to match merge

Re: code to match merge

Re: Binary Flags

Binary Flags

Use Different variable on clearing filter

Re: Length in CREATE DATA

Re: Length in CREATE DATA

Re: Binary Flags

Re: Binary Flags

Re: Binary Flags

Re: Length in CREATE DATA

Re: Conditional Retain on Multiple Variables

Maximum number of characters in a macro variable

Re: Column Percentage in bar

Distance / Similarity with Events

Moving Average Forecasting

Loading code

Re: code to match merge

Re: code to match merge

Re: Binary Flags

Binary Flags

Use Different variable on clearing filter

Re: Length in CREATE DATA

Re: Length in CREATE DATA

Length in CREATE DATA

Distinct Count

Conditional Retain on Multiple Variables

Re: Optimize Traveling Distance

Re: Optimize Traveling Distance