About kurofufu

kurofufu · ‎10-26-2012

I create a indicator variable X1 to set 0 for group A and 1 for group B and then run proc reg on X1 along with other continuous X variables and both intercept and X1's coefficient are significant. But if I code it as 1 for group A and 0 for group B, then intercept becomes not significant. So what happens here? How to explain this?

kurofufu · ‎10-19-2012

suppose the data look like below and month 1, 2,3 are before the marketing campaign and month 4, 5, 6 doing marketing campaign. region, store#, month, sales A, 001, 1, 100 A, 002, 1, 102 .... B, 101, 1, 67 B, 102, 1, 105 .... A, 001, 4, 99 A, 002, 4,110 ... B, 101, 4, 105 B, 102, 4, 121 ....

kurofufu · ‎10-19-2012

Suppose a company has retail stores in two regions, A & B and ran a marketing campaign in region B for 3 months. The average monthly store sales of last three months BEFORE the campaign of A is 5% higher than those of B. The average monthly store sales of last three months AFTER the campaign of A is 8% higher than those of B. I would like to know how to test 8% is significantly higher than 5%.

kurofufu · ‎09-22-2012

Any comments on this paper for my question? http://support.sas.com/resources/papers/proceedings10/213-2010.pdf Second, can we use propensity matching here? Suppose we have 2000 members available for creating a control and test groups. 1. Randomly select one members from them 2. Use propensity score matching to find a matching member 3 Repeat step 1 and 2 until exhaust all members ps. SAS paper for propensity score matching: http://www2.sas.com/proceedings/sugi26/p214-26.pdf

kurofufu · ‎09-17-2012

Thanks! This saves me a lot of time.

kurofufu · ‎09-17-2012

I used proc surveyselect to create control and test groups of equal size. But I was not able to make the average of some key variables tp be similar between two groups. What options can I use to remedy this situation? If I keep changing the seed number until two comparable groups are obtained, then this seems not random sampling anymore. Does SAS have an option to select two groups of equal size with all key variables having similar distribution?

kurofufu · ‎08-30-2012

Ksharp, Pattern1: When A prices high/low, B prices high/low most of time => group A & B together Pattern2: When A prices high/low, B prices low/high most of time. => group A & B together Can proc varclus group variables with Pattern2 together? Or it only can group variables with Pattern1?

kurofufu · ‎08-29-2012

Thanks for the suggestion, PG. I also would like to find out who price in the different direction than each other. So two patterns are interested: When A prices high/low, B prices high/low most of time => group A & B together When A prices high/low, B prices low/high most of time. => group A & B together I think only correlation matrix fits the bill.

kurofufu · ‎08-29-2012

The example is just intended for illustrating my question. I don't plan to go into a full analysis of airline industry. I don't see restructuring the data in ballarsw's way can solve my problem. Another point is I want to group variables, not observations. Can I create a correlation matrix of Airline1 to Airline10 and figure out the groupings?

kurofufu · ‎08-29-2012

More info: Expected outcome goes like this: Airline1, Airline5, Airline10 have the same pricing strategies Airline2, Airline3, Airline6 have the same pricing strategies .... What I mean by the same pricing strategies is when Airline1 prices high on a origination and destination pair, Airline5 and Airline10 also prices high.

kurofufu · ‎08-28-2012

Suppose we want to look at which airlines have similar pricing strategies. The data set looks like this: Variables: Flight Origination, Flight Destination, Airline1 Price, Airline2 Price, ....Airline10 Price. Data: Origination: A, Destination: B, Airline1 Price=100, Airline2 = 120, ...., Airline10=95 Origination: A, Destination: C, Airline1 Price=500, Airline2 = 450, ...., Airline10=505 ...... I wonder if I can use PROC VARCLUS to accomplish this objective. But as I read, it seems PROC VARCLUS is not used for this purpose.

kurofufu · ‎08-17-2012

I don't have access to the management tool, so I can't export another person's EM project to import it to my account. I would like to know if there is a workaround for doing this. I simply copied all the physical files over my folder, but I still can't see the project in my EM. I guess this has something to do with registering a project with the management tool or something like that.

kurofufu · ‎08-11-2012

I am looking for a data set that contains social-economic information for each country such as GDP, population, etc.

kurofufu · ‎08-08-2012

Suppose I have one character variable with length = 1 and I want to check if the value is an alphabet only. Below is my code.Let me know if you have handier code. data t2; set t1; if var1 in ("A","B","C","D", "E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y", "Z") then ind = 1; else ind = 0; run;

kurofufu · ‎08-04-2012

"At r-square = 0.1, your model has essentially no predictive power." Are you sure? The CMS-HCC model used by CMS to pay private insurance companies has R-square of 0.09. The model my company is using has R-square of 0.1, but it already helped the company save a lot of money. Variable transformation is one way which possible help improve the model's predictive power. I would like to know what other options I can have without acquiring more variables.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

a regression model question

Statistical Testing for A/B test, MVT

How to get ROC curve in Model Comparison

Re: Regression question

Re: Regression question

R replaces SAS/STAT?

Re: Regression question

Regression question

Re: Indicator Variable in PROC REG

Re: Indicator Variable in PROC REG

Indicator Variable in PROC REG

Re: How to test a marketing effect?

How to test a marketing effect?

Re: surveyselect question

Re: surveyselect question

surveyselect question

Re: Grouping similar competitors

Re: Grouping similar competitors

Re: Grouping similar competitors

Re: Grouping similar competitors

Grouping similar competitors

Copy Enterprise Miner Projects

country level social-economic data

check if a character is an alphabet

Re: model building