Hi i am trying to produce next best three offers lists for my customer.   I used link analysis node to produce my list and have my lists on results tab. EM orders offers in descending order and let the offer with highest confidence as the 1st next best offer, and  i could see rank numbers and confidence values are inline.   But when i took score code and move procedure to EG, i saw that score assigns rank = 1 value for the  product which has the  lowest confidence value.   In short i can observe  rank values correlated  with their rank number in EM but on EG ordering is completely different.    Regards ... View more

I am using SAS Base V9.4 I have daily balances each of my customers and i want to find out if they increases or decreases their balance from one day to another. So I wrote the following code but i am receiving following Error.   "ERROR 72-185: The LAG function call has too many arguments." IF LAG(CUST_ID,1)=CUST_ID AND (BALANCE - LAG(BALANCE,1))>0 THEN FLAG="FLAG=1"     what could be the problem?   i have  to calculate differences while grouping  the same cuatomer  ... View more

Hi I am trying to prepare a transactional data. I have  Individuals and their transaction dates. I want to sort data primarly on Customer ID and  then tranaction date. Until there it is not a big challenge, but in addition to this i require to print a new variable that states oder of every transaction by number for every individual. The final data would look like the picture i attached bellow.        Thank you very much  ... View more

I have already clustered my customers by using SAS Miner using a specific month's data. I want to implement produced rules to the historical data set to understand consistency of clustering.     However, when I use the "Flow Code" of Clustering Node, historical dataset is grouped in only one cluster. How can I implement selected clustering rules to the new dataset?   ... View more

Hi We have  a very limited SASData space in our company. So we generally download tables that we create for our analysis. However after a while updating  analysis we have to upload our data to SAS enviroment again. However because these tables ara huge in size, is there a way to only upload coloumns which i need  for my analysis. ... View more

I have different demographis segments within my training data. I need my modelling node to estimate different models for each segments. Is there a easy way to state that in SAS EM apart from using a filter node Than You Very Much ... View more

Hi Unless i was able to see and  perform actions related to some specific columns in SAS Miners Transform (method and bins columns) and Regression (use and method columns) nodes. Starting from my new project i am unable to see these columns. Accordingly i have no options to calibrate these nodes to estimate my equation. On the other hand i am  fully operational on nodes like replacement, impute, sampling. Could you please help me on this problem thanks ... View more

Hi After dealing with ovarious models i would like to add demographics to my model data set. But is it possiblle to make this kind of left join in SAS Eminer bacause i dont want to turn back to SAS EG I have used MERGE node but some how i received a run time error ... View more