Hi, I am new to SAS and would like some help in filtering this set of data from bankscope which has a problem with duplications. There are instances where a certain bank in a certain year has 3 rows of financial data, hence there is a need to remove/delete duplicates according to the following priority of filtering - C1/C2, C*, U1/U2, U*. From table 1 to table 2. Table 1 Year ISIN Name Consolidation code 2000 Uk123 ABC C1 2000 Uk123 ABC C* 2000 Uk123 ABC U1 2001 Uk123 ABC C2 2001 Uk123 ABC U1 2001 UK345 DEF U1 2001 UK345 DEF C* 2002 UK345 DEF U* Table 2 Year ISIN Name Consolidation code 2000 Uk123 ABC C1 2001 Uk123 ABC C2 2001 UK345 DEF C* ... View more

Hi, I am new to SAS and would like some help in filtering this set of data from bankscope which has a problem with duplications. There are instances where a certain bank in a certain year has 3 rows of financial data, hence there is a need to remove/delete duplicates according to the following priority of filtering - C1/C2, C*, U1/U2, U*. From table 1 to table 2. Table 1 Year ISIN Name Consolidation code 2000 Uk123 ABC C1 2000 Uk123 ABC C* 2000 Uk123 ABC U1 2001 Uk123 ABC C2 2001 Uk123 ABC U1 2001 UK345 DEF U1 2001 UK345 DEF C* 2002 UK345 DEF U* Table 2 Year ISIN Name Consolidation code 2000 Uk123 ABC C1 2001 Uk123 ABC C2 2001 UK345 DEF C* ... View more

I need some help on how to transpose my table, so that it looks like the second table. ISIN Name 2000 2001 2002 2003 2004 UK123 ABC 5000 4030 3500 2070 1050 UK124 DEF 6000 4330 3550 654 5678 UK125 GHI 5070 5030 390 683 345 UK126 JKL 5040 4030 390 45 567 Year Name ISIN 2000 ABC UK123 5000 2001 ABC UK123 4030 2002 ABC UK123 3500 2003 ABC UK123 2070 2004 ABC UK123 1050 2000 DEF UK124 5000 … … …. …. ... View more

Hi guys, I just picked up SAS, and have trouble doing the following. There are around 100k of observations, hence its impossible for me to do it manually. As you can see, there are duplicates for one company (identified by the ISIN) due to the different statements that were produced by bankscope. There are 6 types of possible statements for a company in a certain year. And the priority should be C1/C2, C*, U1/U2,U* whenever possible as shown in table 2. In another words, the priority should be followed and duplicates to be deleted. Thanks in advance guys. Table 1 year ISIN Consolidation code total assets 2005 AU123 C* 20 2005 AU123 C2 18 2006 UK345 C1 25 2006 UK345 C* 40 2006 UK345 U1 28 Table 2 year ISIN Consolidation code total assets 2005 AU123 C2 18 2006 UK345 C1 25 ... View more

Hi, new user here that is trying to learn the ropes. I have a question here, how do I convert table 1 to table 2? table 2 is to calculate the frequency of eg, number of times in year 2005, 2006.. where the index is 6. table 1 Year Index 2005 5 2005 8 2005 11 2006 6 2007 13 2007 5 2007 6 2007 5 2008 8 2008 5 2008 5 table 2 2005 2006 2007 2008 Index<6 1 0 2 2 Index=6 0 1 1 0 Index=8 1 0 0 1 Index>8 1 0 1 0 ... View more

Hi, I need some help getting the summary statistics for table A to the format of table B. I have tried the following code but that is not sufficient (test table), I will require stats such as mode and median too. AND how do I format the data to look like the one in B. proc means data=work.t2;         var gindex;         class year;         output out=work.t2 run; Test Analysis Variable : Index Year N Obs N Mean Std Dev Minimum Maximum 2008 2009 2010 2011 Table A                                                         Year Index 2008 4 2008 8 2008 7 2009 5 2009 8 2010 11 2010 14 2010 5 2011 6 Table B 2008 2009 2010 2011 Min Mean Median Mode Max Stand Dev ... View more

Hi, I am a student and learning how to use SAS by replicating the result from a published paper. I faced a long list of "ERROR: Asterisks are an indication of a format width problem". As you can see from the screenshot, there are some that are calculated corrected, but most of the variables are indicated with asterisks. What I am trying to do is to do a sum up for each variable (28 in total) by year. I am not sure whether it is due to some of the variables have format as numeric 1. while some are in numeric best12. But this is not the case when I check those that managed to sum up, they are a mixture of both numeric formats. The following is my codes with the variables in red. proc sort data=sas.governancedropt1;     by year; run; proc means data=sas.governancedropt1 noprint;     var BLANKCHECK CBOARD LSPMT LWCNST COMPPLAN DIRIND DIRLIAB GOLDENPARACHUTE SEVERANCE CUMVOTE     CUMVOTESS LABYLW LACHTR SECRETBALLOT SUPERMAJOR UNEQVOTE ANTIGREEN DUTIESNF FAIRPRICE PPARACHUTE     PPILL SPARACHUTE SL_BUSCOMP SL_CASHOUT SL_CSA SL_DUTIES SL_FAIRPRICE SL_RPROFITS;     output out=governancedropt1_byyear (drop=_type_ _freq_)         sum(BLANKCHECK CBOARD LSPMT LWCNST COMPPLAN DIRIND DIRLIAB GOLDENPARACHUTE SEVERANCE CUMVOTE     CUMVOTESS LABYLW LACHTR SECRETBALLOT SUPERMAJOR UNEQVOTE ANTIGREEN DUTIESNF FAIRPRICE PPARACHUTE     PPILL SPARACHUTE SL_BUSCOMP SL_CASHOUT SL_CSA SL_DUTIES SL_FAIRPRICE SL_RPROFITS)         = BLANKCHECK1 CBOARD1 LSPMT1 LWCNST1 COMPPLAN1 DIRIND1 DIRLIAB1 GOLDENPARACHUTE1 SEVERANCE1 CUMVOTE1     CUMVOTESS1 LABYLW1 LACHTR1 SECRETBALLOT1 SUPERMAJOR1 UNEQVOTE1 ANTIGREEN1 DUTIESNF1 FAIRPRICE1 PPARACHUTE1     PPILL1 SPARACHUTE1 SL_BUSCOMP1 SL_CASHOUT1 SL_CSA1 SL_DUTIES1 SL_FAIRPRICE1 SL_RPROFITS1;     by year; run; ... View more