Hello everyone,   I try to get maximum value of rows with its maximum value column. I mean that I also see the Variable which is belong the Maximum value. I have a sample data set as below, also I have desired output as below. Can somebody help me, please?   Data Have; Length CustomerID 8 Value1 8 Value2 8 Value3 8; Infile Datalines MISSOVER; Input CustomerID Value1 Value2 Value3 ; DATALINES; 1 5 10 15 2 3 8 9 3 4 9 2 4 1 12 9 5 12 8 7 6 15 7 4 7 2 8 19 8 18 32 5 9 8 9 7 10 7 12 8 ; Run; PROC SQL; Create Table Want As Select CustomerID,Value1,Value2,Value3,Max(Value1,Value2,Value3) As MaxValue From Have Having Max(Value1,Value2,Value3); QUIT; Desired output; Thank you, ... View more

Hello everyone,   I try to analyze PSI(Population Stability Index) and SSI(Stability Statistic Index) between two data sets. The one of them is Large Small&Medium Businnes mass the other is Commercial&Corporate mass. I do this analyze to understand whether the two data sets’s ranges are consistent or not.   Firstly, is this a correct or approach or there can be a better approaches?   Secondly, I have two sample data sets as below, of course, these data sets have Model variables but I just did not add the whole variables. My question is that how can I pull just one YearMonth for every Year and then compare the two data sets?   Data DataSmall; Length CustomerID 8 YearMonth $ 10 Year $ 10 Turnover 8 ; Infile Datalines Missover; Input CustomerID YearMonth Year Turnover; Format ; Datalines; 001 201001 2010 70000 001 201002 2010 70000 001 201003 2010 70000 001 201004 2010 70000 001 201005 2010 70000 001 201006 2010 70000 001 201007 2010 70000 001 201008 2010 70000 001 201009 2010 70000 001 201010 2010 70000 001 201011 2010 70000 001 201012 2010 70000 001 201101 2011 80000 001 201102 2011 80000 001 201103 2011 80000 001 201104 2011 80000 001 201105 2011 80000 001 201106 2011 80000 001 201107 2011 80000 001 201108 2011 80000 001 201109 2011 80000 001 201110 2011 80000 001 201111 2011 80000 001 201112 2011 80000 ; Run; Data DataCommercial; Length CustomerID 8 YearMonth $ 10 Year $ 10 Turnover 8 ; Infile Datalines Missover; Input CustomerID YearMonth Year Turnover; Format ; Datalines; 003 201001 2010 9000000 003 201002 2010 9000000 003 201003 2010 9000000 003 201004 2010 9000000 003 201005 2010 9000000 003 201006 2010 9000000 003 201007 2010 9000000 003 201008 2010 9000000 003 201009 2010 9000000 003 201010 2010 9000000 003 201011 2010 9000000 003 201012 2010 9000000 003 201101 2011 10000000 003 201102 2011 10000000 003 201103 2011 10000000 003 201104 2011 10000000 003 201105 2011 10000000 003 201106 2011 10000000 003 201107 2011 10000000 003 201108 2011 10000000 003 201109 2011 10000000 003 201110 2011 10000000 003 201111 2011 10000000 003 201112 2011 10000000 ; Run;   I just want to get one YearMonth for every Year then implement the PSI and SSI analysis. It is like take a random sample based on CustomerNo and Year.   Here is my desired outputs;     Now, I will do the analyze, is it possible to do this?   Thank you ... View more

Hello everyone,   I would like to learn the size of specific data sets.   For example; after I wrote the following code, I went to C:\Test path and learnt the size of data set is 192 KB.   Libname Test "C:\Test"; Data Test.Cars; Set Sashelp.Cars; Run; But my question is how can I learn the size of Sas data set by using SAS code? Is it possible?   Thank you, ... View more