anilgvdbm Tracker

Re: TrendsPro - Customer Demand Forecasting and Advertisement Optimization

anilgvdbm — Mon, 28 Feb 2022 03:19:35 GMT

Hi Edwin,

I would like to join this team. Kindly let me know your thoughts.

Here is my LinkedIn profile

https://www.linkedin.com/in/anilkumarvemareddy

Re: TrendsPro - Customer Demand Forecasting and Advertisement Optimization

anilgvdbm — Mon, 28 Feb 2022 03:11:45 GMT

Dear Edwin,
I would like to join your team. Kindly let me know the possibility.

Re: How to create interactive stored process

anilgvdbm — Mon, 01 Jul 2019 02:15:39 GMT

Hi Cynthia,

I created the stored process in EG and the web service in the sas management console in client location. now from their side need to call my web service and the web service needs to be interactive. so that's the challenging part here.

Please let me know if anyone worked on this.

Regards,

Anil

How to create interactive stored process

anilgvdbm — Sun, 30 Jun 2019 09:07:04 GMT

Dear Experts,

I have developed a decision tree model in E Miner and need to deploy using web service. client needs my model is interactive after deploying, so it will be like a customer enters one parameter then it should ask the next parameter by interacting with the model.

So my problem is how to build interactive rules by using the model which i developed.

Regards,

Anil

Re If and then

anilgvdbm — Fri, 08 Feb 2019 11:22:54 GMT

Hi Experts,

I need a solution in if and then conditions for multiple variables.

I have data for 10 years and each year as one variable please find the example below

Cutomer ID	year1	year2	year3	year4	year5	year6	year7	year8	year9	year10	Tag
1	49	12	12	37	32	26	13	14	35	21
2	30	46	43	24	31	17	45	40	16	16
3	25	39	32	29	30	48	32	43	35	17
4	14	40	47	35	12	18	32	39	44	42
5	23	12	19	42	26	24	25	30	15	41

in the above table, i want to create tag as good, average and bad. how to use if and then for 10 variables at one go.

the conditions are if year1-year10 le 10 then Tag=good

else if year1-year10 le 10 then Tag=average;

else if year1-year10 le 10 then Tag=poor;

Request you all to suggest me how to do in otherways.

Regards.

Anil

Data Smoothing

anilgvdbm — Fri, 01 Feb 2019 06:53:47 GMT

Hi Experts,

I have one question regarding the data smoothing in SAS. let's say i have 4 years data for 10 million customers.

Sample data looks like this

Cutomer_ID	Year	values
2	2014	40
2	2015	24
2	2016	14
2	2017	26
4	2014	1
4	2015	18
4	2016	9
4	2017	8
5	2014	30
5	2015	20
5	2016	10
5	2017	12

So from the above table, i have to create risk tag for each customer based on their four years score. but in this case, if the customer gets a good score in years and a bad score in 2 years.

So I need to classify based on the smoothing technique in SAS.

Please, can i get any code reference for this?

Thanks in advance.

Regards,

Anil

Re: Rename the values in String variable

anilgvdbm — Sun, 13 Jan 2019 05:47:27 GMT

Dear All,

I have some product names in the product variable i want to rename some of the strings in that variable let's say Anil, Anilkumar, Ani - rename to Anilkumar and create new product variable.

Here i have product names dictionary in another file. now i want to map the product names from raw data with product name dictionary.

I want to use Loops for this because i want to generate weekly and monthly reports.

Can we automate this?

Regards.

Kumar

Re: Import Access DB file form Local drive

anilgvdbm — Fri, 12 Oct 2018 12:59:19 GMT

Yes SAS/Access PC files are installed and but I'm getting an error like failed to connect to server

Please suggest me if you have any reference code or file.

Re: Import Access DB file form Local drive

anilgvdbm — Fri, 12 Oct 2018 09:14:26 GMT

SAS installed remotely and the accdb file also there in that sas server.

I need to convert that accdb file into sas7bdat file for my further analysis.

Regards,

Anil

Import Access DB file form Local drive

anilgvdbm — Fri, 12 Oct 2018 09:05:37 GMT

Dear All,

I have a file with .accdb format in my local drive and i want to import that into SAS. Please help me in this issue.

Regards,

Anil

calculation of first 1 day last 7 days and 15 days average

anilgvdbm — Wed, 25 Apr 2018 06:11:00 GMT

Hi Team,

Need your help in calculating the average of 1 day, last 7 days and Last 15 days. I have the transaction amount by date and Account number.

I'm attaching the data for your reference.

thanks for the help.

Regards,

Kumar

Re : Merge using Proc SQL

anilgvdbm — Mon, 26 Feb 2018 16:26:23 GMT

Hi All,

I have 7 datasets and I need to extract the common records from all 7 datasets and I wrote a Proc SQL query.

Please correct me where i did wrong in the below code.

proc sql;
create table match as
select *
from success as a full join ringtm as b
on a.mobile_num=b.mobile_num
full join Hung_Up as c
on b.mobile_num=c.mobile_num
full join ub1 as d
on c.mobile_num = d.mobile_num
full join ntwk as e
on d.mobile_num = e.mobile_num
full join ivd as f
on e.mobile_num =f.mobile_num
full join other_error as g
on f.mobile_num =g.mobile_num
where a.mobile_num and b.mobile_num
and c.mobile_num and d.mobile_num and e.mobile_num
and f.mobile_num and g.mobile_num ;
quit;

Regards,

Anil

Re: need to delete customer who is not recieving call for last 12 months

anilgvdbm — Mon, 11 Dec 2017 13:28:50 GMT

in month variable 12 means December. I want to exclude customer who is coming under the bucket of audio heard (blanks, "-", less than 50%) for all 12 months then he should exclude.

Re: need to delete customer who is not recieving call for last 12 months

anilgvdbm — Mon, 11 Dec 2017 13:26:16 GMT

Ok ,'ll clarify the issue here. in the Bucket of Audio heard variable there are 3 buckets (" ". "-". "less than 50%") so who is falling into the 3 buckets for all the 12 months then he should remove.
let's say we send a voice message to the same customer 12 times if he listens at one time then he will come under heard category if he does not listen at least one he should exclude.

Re: need to delete customer who is not recieving call for last 12 months

anilgvdbm — Mon, 11 Dec 2017 12:48:26 GMT

only 9 mobile numbers missing this is the raw data table.. i want output like i need to exclude mobile number who are not listened at least once in 12 months.

Re: need to delete customer who is not recieving call for last 12 months

anilgvdbm — Mon, 11 Dec 2017 12:42:05 GMT

I have a dataset with the mobile number, the bucket of Audio heard, month. I have to exclude the customers who are having blank,"-" and less than 50% audio heard from last 12 months. if customer listens once in last 12 months then he should not exclude.

SAS Output

Obs	mobile_num	Disposition	Bucket_of_Audio_Heard	Month
1		Success	Less Than 50%	4
2		Success	95% - 99%	8
3		Success	95% - 99%	1
4		Ring Timeout	-	7
5		Success	Less Than 50%	6
6		Ring Timeout	-	3
7		Other error	-	5
8			-	10
9		Success	75% - 95%	9
10	-1234567	-	-	11
11	07223202201	-	-	12
12	07223235566	-	-	12
13	1032068450	Invalid Number	-	12
14	1032068450	Hung Up	-	12
15	1032068450	Ring Timeout	-	12
16	1032068450	Hung Up	-	12
17	1049061654	Invalid Number	-	12
18	1049061654	Hung Up	-	12
19	1049061654	Hung Up	-	12
20	12345678	Invalid	-	11

Re: need to delete customer who is not recieving call for last 12 months

anilgvdbm — Mon, 11 Dec 2017 12:08:03 GMT

Dear All,

let's say i have data for12 months. variables in the data Mobile number, month and promotion audio heard and other variables. I want to remove the customers who are not at all receiving the call at least once in last 12 months and also who received but audio heard less than 50% also i have to remove.

is there any way to write loops or any suggestions?

Appending dataset in Macro loop

anilgvdbm — Wed, 06 Dec 2017 10:37:44 GMT

Dear All,

I'm trying to append the 100 files from test001-test100;

when i run the below code

%macro append_all;
%do i=001 %to 194;
proc append base=final_mar data=test&i force; run;
%end;
%mend append_all;
%append_all;

the appending starts only from test100 file to test194... below 100 files are not appending what may be the reason?

Regards,

Anil

Proc append from multiple tables

anilgvdbm — Mon, 27 Nov 2017 09:03:03 GMT

Hi All,

I have a datasets 3000 lets say test0001 to test3000 and the variable names are same in all the datasets. I want to append all 3000 files in to one file.

Please suggest me any short simple way to do this task.

Regards,

Anil

Re: Need to Import more than 3000 xlsx files in sas

anilgvdbm — Thu, 12 Oct 2017 09:37:18 GMT

Hi KurtBremse,

These 3000 files are having same variable names. the data is for the entire country level so these 3000 files are only for one year like this I have 3 years data. Each File having only one sheet data.

So, I cont write macro for around 10000 files so is there any other way to do it?\

Regards,

Anil