Hi all, I have performed a clustering analysis for some  IDs with their characteristics and therefore been able to group each one of them into  clusters. I was thinking that i have to validate my model with  discriminant analysis to see if the model catches a good ratio. After validating i would like to be able to  classify new given data into the clusters. I have to say though I am a bit confused with the procedure cause i havent had much experience before but i would like learn how.  So here i go : 1) What would be the most efficient and clear SAS syntax for proc discriminant , i mean do i need all those options provided? 2) What part of the outputs should i center my focus on in order to better explain the procedure to someone else? So ok since i validate my model with already known outcomes (meaning cluster number at one column) i can understand a bit what the model is comparing to, my big confusion is when i have new given data without known outcome and i need to put my new ids into my given clusters. I mean how does that exactly work,  sorry if i sound stupid about it but i am  stuck on how that occurs. Would it be easy to demonstrate with a set with known outcomes and one without so i could get it better (even how to run the procedure). Do i have to run a similar procedure like when i validate? many thnx in advance ... View more

Hi all, Excuse my ignorance but i am kinda new in using these procedures and papers I found on the net dont seem to really give a broke down explaination. So my question is what are the differences between Proc ucm and proc mixed ? I mean when is it more appropriate to use one or other method? any good papers or examples that could give me more insight? Thnx in advance, ... View more

Hi all, This might have a simple answer but i just want to be sure. Lets say that through clustering i have created 6 clusters , each cluster containing various IDs whith its characteristics lets say like up to 5 attributes (columns for each ID). Since i have proven my model to be robust based on historical data my question is the following: When i receive lets say 10000 new IDs (with their 5 attributes) and i want to place them into the clusters i have already created given based on their similar attributes , what would be the best procedure to follow? I hope this makes sense , thnx in advance ... View more

Hi all, Quite new to the macro world so here it goes, I have a significant amount of txt files that i wish to upload into sas and then merge them . example of name of the files is as following: zomb_200911.txt zomb_200912.txt zomb_201001.txt zomb_201002.txt zomb_201003.txt and etc. They all contain the same info, so i was wondering is there any simple macro i could apply for this situation? Thnx in advance ... View more

Hi all, Kinda new in the SAS world so i would gladly take your advice. My issue is as following: I dont possess text miner and i am trying to handle a case with text via SAS Base. So what i want to figure out is to recognize if in a group of rows (5,7,3) the names match, meaning if i have for example Alex Smith  in row 1 and Smith Alex in row 2 that the program will figure that it is the same name. In addition there can be a rows where the name is   Smith Alexander  or Smith Alex which is the same name and i would like SAS to recognize that. That means that if two rows have at least 2 words in common (the total for each row would be lets say 3 words) i would like to find a command so that SAS can consider them the same and therefore place them in the same group. I hope it makes sense and hope in addition that any advice can be found here. Thnx in advance ... View more

Hi all, Kinda new in the SAS world so i would gladly take your advice. My issue is as following: I dont possess text miner and i am trying to handle a case with text via SAS Base. So what i want to figure out is to recognize if in a group of rows (5,7,3) the names match, meaning if i have for example Alex Smith  in row 1 and Smith Alex in row 2 that the program will figure that it is the same name. In addition there can be a rows where the name is   Smith Alexander  or Smith Alex which is the same name and i would like SAS to recognize that. That means that if two rows have at least 2 words in common (the total for each row would be lets say 3 words) i would like to find a command so that SAS can consider them the same and therefore place them in the same group. I hope it makes sense and hope in addition that any advice can be found here. Thnx in advance ... View more

Hi all, Could anyone explain to me what is the difference between the above mentioned methods? Trying to build a model for churn and pondering over which one to choose to achieve better results Thnx in advance, Aristos ... View more

Hi all, Ok maybe my question is simple but i cant seem to find if there is any solution to it, I was just wondering when i create a new column(new variable ) in a dataset is there any command to define the place it should take instead of automatically placing it last? lets say i calculate the sum of a few variables and i want the column that contains the sum to appear after the variables is it possible? thnx in advance ... View more