About Raghs_Newbee

Raghs_Newbee · ‎02-17-2012

Hi Hima I have attached some sample data in the post. Thanks to all for the wonderfull help.

Raghs_Newbee · ‎02-17-2012

Yes, The Date Column is in DateTime format. Attached is a Sample Data. I am not worried about the blanks in the Date Column, Just need the Last Date Time Transaction. I did try the Querry of HIMA. I get repeated Account ID when the transaction Amount is Different.

Raghs_Newbee · ‎02-16-2012

Thanks Art, But unfortunately yes.. few customer have more transactions in the last date.. So i am unable to do so using Proc SQL. The report I am pulling also consits of a lot of other variables that needs either to be summed up or transposed to find the count. I will post some Sample data and the output I need for a Better understanding.

Raghs_Newbee · ‎02-16-2012

Hi Team, I have 3 million obs with account numbers of different persons with N number of transactions at different dates for the last three years. I need to collect the Distinct(Account_Number) and the Amount which is actually the last transaction made by the customer. Thanks

Raghs_Newbee · ‎01-26-2012

Thanks to Both for the Reply. I am asking if we know/Understand the Way SAS EM performs - Cant we break the Code into different set of SAS BASE Algorithms - Like I have found few Algorthms for run CHI Sqauare Test, Entropy Reduction - Still in Search for Gini Reduction - So why cant we Map One out put to the other so we get the Required output in an Excel or CSV Format from which further analysis can be made. The SAS EM Decision Tree Surely runs behind a logical algorithm that is in place, Why not we try to break into pieces that will produce the same output. I have also seen a module on PROC ARBORETUM - Why am I not able to use it SAS BAse. Does it reuire SAS EM too. I am not a Statistician to understand & read formulas that are available on the internet - But I am sure these are the formulas used in the algorithm for the tree.

Raghs_Newbee · ‎01-25-2012

Hi friends, Just curious, If at there exists any Algorithm or Code that produces the output of a Decision Tree - WITHOUT THE GUI type. Just the Data alone in Excel is suffiecient. I am not looking for Interactive Tree Representation. Just Feed Data with N Variables and N Observations - The algo should do the work that a DTREE Does. Run CHI Square Test, Run Entropy Reduction and Gini Reduction and give me an intermediate output for analysis. Thanks, Raghuraman Ramesh

Raghs_Newbee · ‎01-23-2012

If I was in your position, I would think of a very simple macro in Excel. Select the Range Cell( A,B) - Cell (X,Y) - Fromat them as Number if store as Text. Simple the job gets done in mater of minutes. You can also convert the headers to DATE format in Excel Macro - select the right rigne is what matters.

Raghs_Newbee · ‎01-23-2012

You are right, I used Proc SQL to get the same data that proc summary fetched me. So I used proc Transpose with the tables that i created using the proc SQL. The only difference I find between Datasets generated from Proc SQL and Proc Summary is - In Proc Summary Blanks are replaced with ZERO but that is not the case in Proc SQL. Thanks a ton, You have been great. Raghuraman Ramesh

Raghs_Newbee · ‎01-23-2012

Thank you... Works great ..

Raghs_Newbee · ‎01-23-2012

Hi Folks, Data Class; input Name $ Sex $; Cards; John M Ruby F Smith M Dolly F Cathy F run; Output: Name Sex John M Ruby F Smith M Dolly F Cathy F So I am trying to get the following output: Name M F John 1 0 Ruby 0 1 Smith 1 0 Dolly 0 1 Cathy 0 1 I have shown just an Example, Just like M or F - The column can contain 'N' number of Values. So all these should be taken as Variables and produce the given output. I dont want this code because I cant search and group all observations to write an If Clause. Data Just (Drop=Sex); set Class ; if Sex = 'M' then Male = 1; else Male = 0; if Sex = 'F' then Female = 1; else Female = 0; run; Thanks, Raghuraman Ramesh

Raghs_Newbee · ‎01-17-2012

I have done this to the Treedisc Macro: %inc 'D:\SAS\Decision Tree\xmacro.sas'; %include macros(xmacro); The xMacro file is located in the location I have mentioned. Is there anyother file that i have to look for.. Please Advice. Thanks, Raghuraman Ramesh

Raghs_Newbee · ‎01-17-2012

Hi Iam trying to run the following Treedisc Macro. I am getting an Error " Physical file does not exist, C:\Users\Raghu\Macros. I am not able to understand what other macro file I would require. Can some one help me. Attached are xMacros and Treedisc Macros Thanks, Raghuraman Ramesh

Raghs_Newbee · ‎01-13-2012

Hi Team, I just found that Decision Tree Analysis Code (Open Source) is available in Java. I also found that Java Code can be incorporated in SAS. http://support.sas.com/rnd/base/datastep/dot/javaobj.html http://support.sas.com/91doc/docMainpage.jsp?_topic=lrcon.hlp/a002586295.htm The Java .jar file can be found here: http://www.run.montefiore.ulg.ac.be/~francois/software/jaDTi/ So now what I want to know is how to implement it with the Data Set that I have in my Library for A Dtree analysis Thanks, Raghuraman Ramesh

Raghs_Newbee · ‎01-13-2012

Yup! Thats what I thought initially when I saw the first few observations in the Sample File (Which I thought was the Actual). I have now recieved the actual file with 2.3 Million Observations ?????? I may have to sit a whole month just translating this.... Thanks, Raghuraman Ramesh

Raghs_Newbee · ‎01-13-2012

Thank you so much! You are one among the best!!!

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

Re: Find the Last Transaction in DataSet

Re: Find the Last Transaction in DataSet

Find the Last Transaction in DataSet

Find the Last Transaction in DataSet

Re: Algorithm in SAS Base / SAS STAT

Algorithm in SAS Base / SAS STAT

convert alpha to numeric without creating a new var

Column Transpose

Column Transpose

Column Transpose

Re: Find the Last Transaction in DataSet

Re: Find the Last Transaction in DataSet

Find the Last Transaction in DataSet

Find the Last Transaction in DataSet

Re: Algorithm in SAS Base / SAS STAT

Algorithm in SAS Base / SAS STAT

convert alpha to numeric without creating a new var

Column Transpose

Column Transpose

Column Transpose

SAS macro Error

SAS macro Error

Java's Influence in SAS

Observations with Different Language

Create a Report