cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
srikanthyadav44
‎09-17-2024
  • 153 Posts
  • 32 Likes Given
  • 1 Solutions
  • 2 Likes Received

running regression with condition on sample size

by Quartz | Level 8 in SAS Programming
‎07-20-2022 01:31 AM
‎07-20-2022 01:31 AM
dear all,  i have my data in the following format  company_name year NIC Y X1 X2 20 Microns Ltd. 2011 8 0.332 1.484 0.367 20 Microns Ltd. 2012 8 0.306 1.324 0.139 20 Microns Ltd. 2013 8 0.289 1.081 0.050 20 Microns Ltd. 2014 8 0.303 1.030 0.048 20 Microns Ltd. 2015 8 0.283 0.972 0.071 20 Microns Ltd. 2016 8 0.280 1.015 0.067 20 Microns Ltd. 2017 8 0.287 1.068 0.069 20 Microns Ltd. 2018 8 0.249 1.050 0.075 20 Microns Ltd. 2019 8 0.251 1.145 0.135 20 Microns Ltd. 2020 8 0.251 1.233 0.142 20 Microns Ltd. 2021 8 0.223 1.057 -0.137 3I Infotech Ltd. 2011 62 0.110 0.186 0.010 3I Infotech Ltd. 2012 62 0.106 0.155 -0.011 3I Infotech Ltd. 2013 62 0.075 0.103 -0.037 3I Infotech Ltd. 2014 62 0.054 0.072 -0.012 3I Infotech Ltd. 2015 62 0.052 0.089 0.017 3I Infotech Ltd. 2016 62 0.034 0.092 -0.015 3I Infotech Ltd. 2017 62 0.028 0.099 -0.024 3I Infotech Ltd. 2018 62 0.028 0.085 -0.014 3I Infotech Ltd. 2019 62 0.037 0.108 0.018 3I Infotech Ltd. 2020 62 0.018 0.073 -0.032 3I Infotech Ltd. 2021 62 0.023 0.073 0.003 3M India Ltd. 2011 22 0.332 1.919 0.158 3M India Ltd. 2012 22 0.331 1.842 0.281 3M India Ltd. 2013 22 0.303 1.681 0.182 3M India Ltd. 2014 22 0.268 1.272 0.120 3M India Ltd. 2015 22 0.263 1.279 0.069 3M India Ltd. 2016 22 0.283 1.393 0.195 3M India Ltd. 2017 22 0.348 1.570 0.145 3M India Ltd. 2018 22 0.241 1.289 0.104 I have to regress Y on X1 and X2. the regression should be run for each year  and in each year, each NIC code separately. I use the following code for running the regression and for saving the residual and predicted values.    PROC REG DATA=have; MODEL Y=X1 X2; by YEAR NIC; output out=estimated p=predicted r=residual; run;    in some cases, the observations under any particular NIC code will be less than 10 also. i would like to exclude observations under such NIC codes in running the regression.    please let me how should i modify the above mentioned code to achieve this purpose.    thanking you in advance   ... View more

Re: recoding of the variable

by Quartz | Level 8 in SAS Programming
‎07-17-2022 03:51 AM
‎07-17-2022 03:51 AM
thanks. it is working ... View more

recoding of the variable

by Quartz | Level 8 in SAS Programming
‎07-16-2022 02:36 AM
‎07-16-2022 02:36 AM
dear all,  i have the data in the following format  company_name Year investor_name 20 Microns Ltd. 2010 Gujarat Venture Capital Fund-1995 20 Microns Ltd. 2010 Narendra Manibhai Patel 3I Infotech Ltd. 2010 Emirates Bank International Pjsc 3I Infotech Ltd. 2010 Lic Of India Money Plus 3I Infotech Ltd. 2010 Lic Of India Money Plus -1 3I Infotech Ltd. 2010 Life Insurance Corporation Of India Ltd 3I Infotech Ltd. 2010 Norges Bank A/C Government Petroleum Fund 3I Infotech Ltd. 2010 Reliance Capital Trustee Co Ltd A/C Reliance Equity Opportunities Fund 3I Infotech Ltd. 2010 Reliance Capital Trustee Co Ltd A/C Reliance Regular Saving Fund Equity Option 3I Infotech Ltd. 2010 Reliance Capital Trustee Co Ltd Reliance Long Term Equity Fund 3I Infotech Ltd. 2010 Sundaram Bnp Paribas Mutual Fund A/C Sudaram Bnp Paribas Equity Multiplier Fun 3I Infotech Ltd. 2010 Swiss Finance Corporation Mauritius Ltd 3M India Ltd. 2010 Acacia Institutional Partners Lp 3M India Ltd. 2010 Acacia Partners Lp 3M India Ltd. 2010 Bright Star Investments Pvt Ltd 3M India Ltd. 2010 Hdfc Trustee Company Ltd - Hdfc Prudence Fund 3M India Ltd. 2010 Tata Offshore India Opportunities Scheme 3P Land Holdings Ltd. 2010 Deep Star Investment & Finance Co Pvt Ltd 3P Land Holdings Ltd. 2010 Santosh S Goenka 3P Land Holdings Ltd. 2010 Shree Global Tradefin Ltd 52 Weeks Entertainment Ltd. 2010 Alpic Finance Ltd 52 Weeks Entertainment Ltd. 2010 Dr Hemant Thacker 52 Weeks Entertainment Ltd. 2010 Jainam Sec Pvt Ltd 52 Weeks Entertainment Ltd. 2010 Suman L Shah 52 Weeks Entertainment Ltd. 2010 Winever Investment & Consultants Pvt Ltd 63 Moons Technologies Ltd. 2010 Acacia Institutional Partners Lp 63 Moons Technologies Ltd. 2010 Acacia Partners Lp 63 Moons Technologies Ltd. 2010 Aic Advantage Fund 63 Moons Technologies Ltd. 2010 Bharat K. Sheth 63 Moons Technologies Ltd. 2010 Deutsche Securities Mauritius Ltd 63 Moons Technologies Ltd. 2010 Fid Funds Mauritius Ltd 63 Moons Technologies Ltd. 2010 Passport Capital Llc A/C Passport India Investments Mauritius Ltd 63 Moons Technologies Ltd. 2010 Pivotal Securities Pvt Ltd 63 Moons Technologies Ltd. 2010 Ravi K. Sheth 63 Moons Technologies Ltd. 2010 Reliance Capital Trustee Company Ltd A/C Reliance Equity Fund 63 Moons Technologies Ltd. 2010 Reliance Capital Trustee Company Ltd A/C Reliance Growth Fund 63 Moons Technologies Ltd. 2010 Reliance Capital Trustee Company Ltd A/C Reliance Vision Fund 63 Moons Technologies Ltd. 2010 Reliance Life Insurance Company Ltd A B B India Ltd. 2010 Aberdeen Asset Managers Ltd A/C Aberdeen Global Indian Fund Mauitius Ltd A B B India Ltd. 2010 General Insurance Corporation Of India A B B India Ltd. 2010 Icici Prudential Life Insurance Company Ltd A B B India Ltd. 2010 Lic Of India Market Plus A B B India Ltd. 2010 Lic Of India Money Plus A B B India Ltd. 2010 Life Insurance Corporation Of India A B B India Ltd. 2010 Life Insurance Corporation Of India Profit Plus A B C Gas (International) Ltd. 2010 Canbank Financial Services Ltd A B C Gas (International) Ltd. 2010 Naresh K Aggarwala A B C Gas (International) Ltd. 2010 Savasthi Investment Ltd A B C Gas (International) Ltd. 2010 St. Helens Nominees India Pvt Ltd   I have to recode the variable "investor_name" into "1" if the  variable contains any of below mentioned words or else "0"  “Investment”  “Ltd” “Pvt” “India” “Lic” “Bank” “Securities” “Corporation”  “Fund”             please suggest to me a suitable SAS code for this purpose thanking you in advance  ... View more

Re: How to find largest and second largest values?

by Quartz | Level 8 in SAS Programming
‎05-09-2022 07:43 AM
‎05-09-2022 07:43 AM
thanks a lot ... View more

Re: how to compute standard deviation, skewness and kurtosis?

by Quartz | Level 8 in SAS Programming
‎05-09-2022 07:26 AM
‎05-09-2022 07:26 AM
thanks a lot. the code is working ... View more

How to find largest and second largest values?

by Quartz | Level 8 in SAS Programming
‎05-09-2022 12:48 AM
‎05-09-2022 12:48 AM
dear all, i have the data set in the following format company_name year type  percent_shares 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.77 20 Microns Ltd. 2010 Locked-In Shares 2.5 20 Microns Ltd. 2010 Locked-In Shares 0.57 20 Microns Ltd. 2010 Locked-In Shares 0.35 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 1.85 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0.5 20 Microns Ltd. 2010 Locked-In Shares 10.76 20 Microns Ltd. 2010 Locked-In Shares 0.37 20 Microns Ltd. 2010 Locked-In Shares 0.01 20 Microns Ltd. 2010 Locked-In Shares 9.26 20 Microns Ltd. 2010 Locked-In Shares 0.61 20 Microns Ltd. 2010 Locked-In Shares 0.13 20 Microns Ltd. 2010 Locked-In Shares 0.14 20 Microns Ltd. 2010 Locked-In Shares 0.08 20 Microns Ltd. 2010 Locked-In Shares 0.12 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.65 20 Microns Ltd. 2010 Locked-In Shares 0.21 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 0.04 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0 20 Microns Ltd. 2010 Locked-In Shares 6.81 20 Microns Ltd. 2010 Locked-In Shares 1.25 20 Microns Ltd. 2010 Locked-In Shares 0.58 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 1.05 20 Microns Ltd. 2010 Locked-In Shares 0.36 20 Microns Ltd. 2010 Locked-In Shares 1.39 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.64 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.33 20 Microns Ltd. 2010 Locked-In Shares 0.17 20 Microns Ltd. 2010 Non-Promoters 18.67 20 Microns Ltd. 2010 Non-Promoters 1.65 20 Microns Ltd. 2010 Promoters 0.77 20 Microns Ltd. 2010 Promoters 2.5 20 Microns Ltd. 2010 Promoters 0.57 20 Microns Ltd. 2010 Promoters 0.35 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 1.85 20 Microns Ltd. 2010 Promoters 10.8 20 Microns Ltd. 2010 Promoters 18.94 20 Microns Ltd. 2010 Promoters 0.14 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.08 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.21 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 6.81 20 Microns Ltd. 2010 Promoters 0.06 20 Microns Ltd. 2010 Promoters 1.19 20 Microns Ltd. 2010 Promoters 0.58 20 Microns Ltd. 2010 Promoters 1.05 20 Microns Ltd. 2010 Promoters 1.39 20 Microns Ltd. 2010 Promoters 0.33   i have to compute largest and second largest values of percent_shares for each 'company' for 'year' for each 'type' . my output should be in the following format company_name year type  percent_shares first_largest second_largest                                                                                                                                                   please suggest me a SAS code in this regard  thanking you in advance  ... View more

how to compute standard deviation, skewness and kurtosis?

by Quartz | Level 8 in SAS Programming
‎05-09-2022 12:16 AM
‎05-09-2022 12:16 AM
dear all, i have the data of in the following format company_name year type  percent_shares 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.77 20 Microns Ltd. 2010 Locked-In Shares 2.5 20 Microns Ltd. 2010 Locked-In Shares 0.57 20 Microns Ltd. 2010 Locked-In Shares 0.35 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 1.85 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0.5 20 Microns Ltd. 2010 Locked-In Shares 10.76 20 Microns Ltd. 2010 Locked-In Shares 0.37 20 Microns Ltd. 2010 Locked-In Shares 0.01 20 Microns Ltd. 2010 Locked-In Shares 9.26 20 Microns Ltd. 2010 Locked-In Shares 0.61 20 Microns Ltd. 2010 Locked-In Shares 0.13 20 Microns Ltd. 2010 Locked-In Shares 0.14 20 Microns Ltd. 2010 Locked-In Shares 0.08 20 Microns Ltd. 2010 Locked-In Shares 0.12 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.65 20 Microns Ltd. 2010 Locked-In Shares 0.21 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 0.04 20 Microns Ltd. 2010 Locked-In Shares 0.03 20 Microns Ltd. 2010 Locked-In Shares 1.95 20 Microns Ltd. 2010 Locked-In Shares 0.1 20 Microns Ltd. 2010 Locked-In Shares 0 20 Microns Ltd. 2010 Locked-In Shares 6.81 20 Microns Ltd. 2010 Locked-In Shares 1.25 20 Microns Ltd. 2010 Locked-In Shares 0.58 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 0.18 20 Microns Ltd. 2010 Locked-In Shares 1.05 20 Microns Ltd. 2010 Locked-In Shares 0.36 20 Microns Ltd. 2010 Locked-In Shares 1.39 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.64 20 Microns Ltd. 2010 Locked-In Shares 0.07 20 Microns Ltd. 2010 Locked-In Shares 0.33 20 Microns Ltd. 2010 Locked-In Shares 0.17 20 Microns Ltd. 2010 Non-Promoters 18.67 20 Microns Ltd. 2010 Non-Promoters 1.65 20 Microns Ltd. 2010 Promoters 0.77 20 Microns Ltd. 2010 Promoters 2.5 20 Microns Ltd. 2010 Promoters 0.57 20 Microns Ltd. 2010 Promoters 0.35 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 1.85 20 Microns Ltd. 2010 Promoters 10.8 20 Microns Ltd. 2010 Promoters 18.94 20 Microns Ltd. 2010 Promoters 0.14 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.08 20 Microns Ltd. 2010 Promoters 0.12 20 Microns Ltd. 2010 Promoters 0.21 20 Microns Ltd. 2010 Promoters 1.95 20 Microns Ltd. 2010 Promoters 6.81 20 Microns Ltd. 2010 Promoters 0.06 20 Microns Ltd. 2010 Promoters 1.19 20 Microns Ltd. 2010 Promoters 0.58 20 Microns Ltd. 2010 Promoters 1.05 20 Microns Ltd. 2010 Promoters 1.39 20 Microns Ltd. 2010 Promoters 0.33 it represents the company name, year and shareholding percentage. it the panel data of nearly 5000 companies from 2010 to 2019. i have to find out mean, standard deviation, skewness and kurtosis for each company for every year from 2010 to 2019. my output should have the following information company_name year type  percent_shares mean  stand.dev skewness kurtosis                                                                                                                                                                                                                                                                                                                                                                 please suggest the appropriate SAS CODE   thanks in advance ... View more

Re: how to find the sum of first three largest shareholdings ?

by Quartz | Level 8 in SAS Programming
‎05-04-2022 03:06 AM
‎05-04-2022 03:06 AM
thanks it is working ... View more

how to find the sum of first three largest shareholdings ?

by Quartz | Level 8 in SAS Programming
‎05-02-2022 07:46 AM
‎05-02-2022 07:46 AM
dear all, i have the data of in the following format  company_name year percent_shares 20 Microns Ltd. 2010 0.07 20 Microns Ltd. 2010 0.77 20 Microns Ltd. 2010 2.5 20 Microns Ltd. 2010 0.57 20 Microns Ltd. 2010 0.35 20 Microns Ltd. 2010 1.95 20 Microns Ltd. 2010 1.85 20 Microns Ltd. 2010 0.1 20 Microns Ltd. 2010 0.5 20 Microns Ltd. 2010 10.76 20 Microns Ltd. 2010 0.37 20 Microns Ltd. 2010 0.01 20 Microns Ltd. 2010 9.26 20 Microns Ltd. 2010 0.61 20 Microns Ltd. 2010 0.13 20 Microns Ltd. 2010 0.14 20 Microns Ltd. 2010 0.08 20 Microns Ltd. 2010 0.12 20 Microns Ltd. 2010 0.03 20 Microns Ltd. 2010 1.65 20 Microns Ltd. 2010 0.21 20 Microns Ltd. 2010 0.03 20 Microns Ltd. 2010 0.04 20 Microns Ltd. 2010 0.03 20 Microns Ltd. 2010 1.95 20 Microns Ltd. 2010 0.1 20 Microns Ltd. 2010 0 20 Microns Ltd. 2010 6.81 20 Microns Ltd. 2010 1.25 20 Microns Ltd. 2010 0.58 20 Microns Ltd. 2010 0.18 20 Microns Ltd. 2010 0.18 20 Microns Ltd. 2010 1.05 20 Microns Ltd. 2010 0.36 20 Microns Ltd. 2010 1.39 20 Microns Ltd. 2010 0.07 20 Microns Ltd. 2010 0.64 20 Microns Ltd. 2010 0.07 20 Microns Ltd. 2010 0.33 20 Microns Ltd. 2010 0.17 20 Microns Ltd. 2010 18.67 20 Microns Ltd. 2010 1.65 20 Microns Ltd. 2010 0.77 20 Microns Ltd. 2010 2.5 20 Microns Ltd. 2010 0.57 20 Microns Ltd. 2010 0.35 20 Microns Ltd. 2010 1.95 20 Microns Ltd. 2010 1.85 20 Microns Ltd. 2010 10.8 20 Microns Ltd. 2010 18.94 20 Microns Ltd. 2010 0.14 20 Microns Ltd. 2010 0.12 20 Microns Ltd. 2010 0.08 20 Microns Ltd. 2010 0.12 20 Microns Ltd. 2010 0.21 20 Microns Ltd. 2010 1.95 20 Microns Ltd. 2010 6.81 20 Microns Ltd. 2010 0.06 20 Microns Ltd. 2010 1.19 20 Microns Ltd. 2010 0.58 20 Microns Ltd. 2010 1.05 20 Microns Ltd. 2010 1.39 20 Microns Ltd. 2010 0.33 3I Infotech Ltd. 2010 2.73 3I Infotech Ltd. 2010 1.39 3I Infotech Ltd. 2010 1.59 3I Infotech Ltd. 2010 8.12 3I Infotech Ltd. 2010 2.57 3I Infotech Ltd. 2010 1.75 3I Infotech Ltd. 2010 2.07 3I Infotech Ltd. 2010 3.5 3I Infotech Ltd. 2010 1.9 3I Infotech Ltd. 2010 2.07 3I Infotech Ltd. 2010 23.13 3M India Ltd. 2010 1.2 3M India Ltd. 2010 1.93 3M India Ltd. 2010 1.48 3M India Ltd. 2010 2.9 3M India Ltd. 2010 1.93 3M India Ltd. 2010 76 3P Land Holdings Ltd. 2010 4.87 3P Land Holdings Ltd. 2010 1.2 3P Land Holdings Ltd. 2010 5.56 3P Land Holdings Ltd. 2010 2.11 3P Land Holdings Ltd. 2010 4.58 3P Land Holdings Ltd. 2010 2.24 3P Land Holdings Ltd. 2010 0.34 3P Land Holdings Ltd. 2010 2.74 3P Land Holdings Ltd. 2010 3.47 3P Land Holdings Ltd. 2010 4.59 3P Land Holdings Ltd. 2010 21.92 3P Land Holdings Ltd. 2010 2.04 3P Land Holdings Ltd. 2010 4.65 3P Land Holdings Ltd. 2010 3.58 3P Land Holdings Ltd. 2010 13.94 it represents the company name, year and shareholding percentage.  it the panel data of nearly 5000 companies from 2010 to 2019.  i have to find out the sum of first three largest shareholdings for each company for every year from 2010 to 2019.  my output should have the following information  company_name year sum of three largest shareholdigns                                        please suggest  the appropriate SAS CODE    thanks in advance ... View more

how to compute cumulative return for 50 days and 200 days for array of...

by Quartz | Level 8 in SAS Programming
‎01-16-2022 03:16 AM
‎01-16-2022 03:16 AM
dear all, i have the dataset of stock returns for 163 stocks in daily frequency, i have to compute cumulative return for 50 preceding days and 200 preceding days for all the 163 stock returns.  I need 50 days cumulative return in one file and 200 days cumulative returns in another file. my present data file is in this format  Date C1 C2 C3 ……………… C163 5/4/2010 0.034732 -1.30527 1.414732   3.014732 6/4/2010 0.204732 0.124732 -0.32527   2.304732 7/4/2010 2.394732 0.174732 1.314732   -0.72527 8/4/2010 -1.26527 -2.06527 -0.22527   -0.83527 9/4/2010 -0.48527 0.384732 -0.28527   1.584732 ######## -0.74641 -1.14641 -0.91641   3.173589 ######## -0.90641 3.443589 0.973589   -0.46641 ######## -0.47641 0.373589 -0.59641   1.833589 ######## -0.53641 -1.36641 -0.73641   -0.82641 ######## -1.46617 -2.06617 1.773835   3.353835 ######## 0.133835 0.743835 6.183835   -2.59617 ######## 1.143835 0.083835 3.933835   2.473835 ######## -1.31617 0.323835 1.743835   3.173835 ######## -1.81617 0.593835 1.713835   -0.57617 ######## 0.533835 0.693835 1.893835   -0.22617 ######## -0.52617 0.883835 1.043835   -1.14617 ######## 0.543835 -1.99617 -2.63617   -0.79617 ######## -1.19617 -0.86617 -0.35617   -0.75617 ######## 0.973835 -1.02617 0.103835   1.453835 3/5/2010 -0.35601 1.94399 0.35399   -1.64601 4/5/2010 -2.72601 0.48399 -0.33601   -3.02601 5/5/2010 0.73399 -0.80601 0.25399   1.29399 6/5/2010 -1.12601 0.29399 0.02399   -2.11601 7/5/2010 -1.33601 -0.30601 -0.65601   -2.90601 ######## 2.813835 0.823835 3.373835   2.243835 ######## -0.40617 -0.05617 0.223835   -2.31617 ######## -0.83617 0.253835 -0.16617   3.283835 ######## 1.443835 2.953835 0.343835   4.833835 ######## 0.213835 -2.05617 2.253835   -2.18617 ######## -3.32632 -1.35632 -2.28632   3.863679 ######## 0.163679 0.353679 0.723679   -3.56632 ######## -2.23632 0.043679 -1.69632   -3.91632 ######## -0.06632 0.243679 2.323679   3.513679 ######## 1.753679 -0.96632 -0.64632   -2.73632 ######## -0.46942 0.150578 0.390578   -1.56942 ######## -1.60942 -4.41942 -1.93942   -2.16942 ######## -1.35942 2.830578 0.410578   -0.08942 ######## -1.65942 1.300578 -6.48942   0.780578 ######## 1.150578 2.230578 -0.80942   1.870578 ######## -1.22004 -1.90004 0.509959   0.019959 1/6/2010 0.169959 1.199959 -1.32004   -2.67004 2/6/2010 0.889959 0.729959 1.199959   0.069959 3/6/2010 1.959959 -1.63004 1.529959   5.539959 4/6/2010 -0.20004 -0.33004 0.309959   1.639959 7/6/2010 1.039804 -1.9902 -2.6102   -2.2102   required output format for 50 days cumulative returns is as follows  Date C1_CR50 C2_CR50 C3_CR50 ……………… C163_CR50 16/6/2010 0.210412 0.189752 -1.72066   -0.04066 17/6/2010 0.789863 0.769204 -0.19066   0.31934 18/6/2010 -0.2325 -0.25316 -0.07066   -0.70066 21/6/2010 1.708799 1.68814 2.44934   -0.44066 22/6/2010 -0.68886 -0.70952 -2.45066   -0.35066 23/6/2010 0.124064 0.103404 1.03934   -0.19066 24/6/2010 -0.04792 -0.06857 -0.41066   -0.27066 25/6/2010 -0.9736 -0.99426 -0.62066   -0.21066 28/6/2010 1.21576 1.19541 0.859649   0.169649 29/6/2010 -1.46089 -1.48124 -0.40035   0.089649 30/6/2010 1.066371 1.046021 0.999649   0.649649 1/7/2010 -1.15678 -1.17713 -0.89035   -0.46035 2/7/2010 -0.27268 -0.29303 -0.86035   -0.17035 5/7/2010 -0.02292 -0.04357 0.409342   0.009342 6/7/2010 1.00999 0.989331 -0.98066   -0.72066 7/7/2010 -0.91072 -0.93138 -0.32066   -0.28066 8/7/2010 1.05809 1.037432 -1.01066   0.689342 9/7/2010 1.04421 1.023551 -0.96066   -0.27066 12/7/2010 0.569144 0.548332 -1.21081   -0.09081 13/7/2010 0.327348 0.306536 -0.84081   0.139188 14/7/2010 -0.26885 -0.28966 -1.77081   0.779188 15/7/2010 -0.13748 -0.1583 0.689188   -0.03081 16/7/2010 0.281268 0.260456 0.149188   0.519188 19/7/2010 -0.13821 -0.16026 -0.05205   0.607952 20/7/2010 -0.34311 -0.36516 -0.38205   -0.19205 21/7/2010 0.582318 0.56027 1.917952   0.927952 22/7/2010 0.785888 0.76384 -1.08205   1.737952 23/7/2010 0.1313 0.109253 0.417952   -0.69205 26/7/2010 -0.5613 -0.58335 0.457952   2.447952 27/7/2010 0.221215 0.199167 3.017952   3.057952 28/7/2010 -0.61045 -0.6325 0.137952   0.657952 29/7/2010 0.21006 0.188012 0.067952   -1.44205 30/7/2010 -0.76649 -0.78853 -1.11205   -0.02205 2/8/2010 1.186207 1.163233 0.347025   4.717025 3/8/2010 0.145338 0.122364 -0.58297   2.087025 4/8/2010 0.518915 0.49594 -1.21297   -1.63297 5/8/2010 -0.38021 -0.40319 -0.40297   -0.46297 6/8/2010 -0.14422 -0.16719 0.947025   0.447025   required output format for 200 days cumulative returns is  Date C1_CR200 C2_CR200 C3_CR200 ……………… C163_CR200 16/6/2010 0.064732433 -0.625267567 2.274732433 -0.545267567 -0.545267567 17/6/2010 -1.235267567 0.034732433 -1.095267567 -0.985267567 -0.985267567 18/6/2010 2.254732433 -0.775267567 11.27473243 -0.635267567 -0.635267567 21/6/2010 -0.185267567 0.034732433 -4.445267567 -1.545267567 -1.545267567 22/6/2010 0.484732433 -0.915267567 0.564732433 2.174732433 2.174732433 23/6/2010 -1.226411246 0.963588754 -1.556411246 -0.466411246 -0.466411246 24/6/2010 0.193588754 -0.626411246 0.953588754 -0.376411246 -0.376411246 25/6/2010 0.613588754 5.763588754 -3.166411246 -1.456411246 -1.456411246 28/6/2010 -0.976411246 0.123588754 -2.736411246 0.713588754 0.713588754 29/6/2010 -0.986165446 -1.806165446 1.353834554 -1.646165446 -1.646165446 30/6/2010 1.433834554 3.423834554 0.523834554 2.743834554 2.743834554 1/7/2010 1.623834554 0.613834554 1.593834554 -0.646165446 -0.646165446 2/7/2010 -0.756165446 -0.126165446 -1.136165446 1.963834554 1.963834554 5/7/2010 0.063834554 0.293834554 -2.216165446 0.253834554 0.253834554 6/7/2010 1.103834554 -2.476165446 1.213834554 -0.366165446 -0.366165446 7/7/2010 1.753834554 0.583834554 -1.696165446 -0.366165446 -0.366165446 8/7/2010 0.103834554 0.103834554 -2.486165446 -0.996165446 -0.996165446 9/7/2010 0.263834554 -0.436165446 0.473834554 -1.096165446 -1.096165446 12/7/2010 -2.396165446 1.583834554 -2.746165446 8.683834554 8.683834554 13/7/2010 -0.516010208 -1.196010208 -1.816010208 1.063989792 1.063989792 14/7/2010 -3.786010208 -1.616010208 -3.086010208 0.153989792 0.153989792 15/7/2010 0.323989792 -0.526010208 4.893989792 2.953989792 2.953989792 16/7/2010 -3.706010208 -0.726010208 -2.396010208 4.463989792 4.463989792 19/7/2010 -0.506010208 -2.286010208 -3.556010208 -3.306010208 -3.306010208 20/7/2010 2.803834554 -0.156165446 5.413834554 1.563834554 1.563834554 21/7/2010 -3.246165446 -1.346165446 -1.906165446 2.013834554 2.013834554 22/7/2010 -1.416165446 -1.086165446 2.793834554 2.203834554 2.203834554 23/7/2010 -0.066165446 2.693834554 1.563834554 1.853834554 1.853834554 26/7/2010 -3.356165446 -1.836165446 -3.056165446 -1.336165446 -1.336165446 27/7/2010 -0.256321002 -1.246321002 1.803678998 -0.906321002 -0.906321002 28/7/2010 2.213678998 -0.336321002 -0.876321002 -2.116321002 -2.116321002 29/7/2010 -3.126321002 -2.156321002 -5.226321002 -3.156321002 -3.156321002 30/7/2010 -0.016321002 -2.966321002 -2.536321002 -3.736321002 -3.736321002 2/8/2010 1.133678998 2.203678998 -0.796321002 0.473678998 0.473678998 3/8/2010 1.160577594 -0.889422406 -0.489422406 -2.229422406 -2.229422406 4/8/2010 -1.799422406 -2.479422406 0.850577594 -4.619422406 -4.619422406 5/8/2010 0.980577594 5.610577594 2.970577594 3.840577594 3.840577594 6/8/2010 2.340577594 8.000577594 0.440577594 1.250577594 1.250577594   please guide in writing the SAS code  ... View more

Re: how to Identify Peer group companies from the quartiles?

by Quartz | Level 8 in SAS Programming
‎01-16-2022 02:51 AM
‎01-16-2022 02:51 AM
Dear Reeza  an example of my required output  i need the output in the following format  ESG_company Peer_companies Jubilant Foodworks Ltd. Dwarikesh Sugar Inds. Ltd.   Vadilal Industries Ltd.   Apex Frozen Foods Ltd.   Bajaj Hindusthan Sugar Ltd.   K S E Ltd.   Parag Milk Foods Ltd.   Manorama Industries Ltd.   Andrew Yule & Co. Ltd.   Dhampur Sugar Mills Ltd.   Prataap Snacks Ltd.   Dalmia Bharat Sugar & Inds. Ltd.   A D F Foods Ltd.   D F M Foods Ltd.   Shree Renuka Sugars Ltd.   Mrs. Bectors Food Specialities Ltd.   Bannari Amman Sugars Ltd.   Agro Tech Foods Ltd.   Triveni Engineering & Inds. Ltd.   Venky'S (India) Ltd.   Tata Coffee Ltd.   Gujarat Ambuja Exports Ltd.   C C L Products (India) Ltd.   Tasty Bite Eatables Ltd.   Hindustan Foods Ltd.   Balrampur Chini Mills Ltd.   E I D-Parry (India) Ltd.   Avanti Feeds Ltd.   Godrej Agrovet Ltd.   Zydus Wellness Ltd.   Ruchi Soya Inds. Ltd. Marico Ltd. Dwarikesh Sugar Inds. Ltd.   Vadilal Industries Ltd.   Apex Frozen Foods Ltd.   Bajaj Hindusthan Sugar Ltd.   K S E Ltd.   Parag Milk Foods Ltd.   Manorama Industries Ltd.   Andrew Yule & Co. Ltd.   Dhampur Sugar Mills Ltd.   Prataap Snacks Ltd.   Dalmia Bharat Sugar & Inds. Ltd.   A D F Foods Ltd.   D F M Foods Ltd.   Shree Renuka Sugars Ltd.   Mrs. Bectors Food Specialities Ltd.   Bannari Amman Sugars Ltd.   Agro Tech Foods Ltd.   Triveni Engineering & Inds. Ltd.   Venky'S (India) Ltd.   Tata Coffee Ltd.   Gujarat Ambuja Exports Ltd.   C C L Products (India) Ltd.   Tasty Bite Eatables Ltd.   Hindustan Foods Ltd.   Balrampur Chini Mills Ltd.   E I D-Parry (India) Ltd.   Avanti Feeds Ltd.   Godrej Agrovet Ltd.   Zydus Wellness Ltd.   Ruchi Soya Inds. Ltd. in the above output Jubilant Foodworks Ltd. and  Marico Ltd  are ESG companies belonging to NIC group 10 and quantile 4. So, all the remaining companies in the same quantile will become peer group companies to those companies.  i hope you understood my requirement now   thanks in advance   ... View more

Re: how to Identify Peer group companies from the quartiles?

by Quartz | Level 8 in SAS Programming
‎01-12-2022 02:21 AM
‎01-12-2022 02:21 AM
i am getting the output in the this format company_name matching_company 20 Microns Ltd.   Raghav Productivity Enhancers Ltd.   Ashapura Minechem Ltd.   Gayatri Sugars Ltd. Madhur Industries Ltd. Diana Tea Co. Ltd. Madhur Industries Ltd. Narmada Agrobase Ltd. Madhur Industries Ltd. Ledo Tea Co. Ltd. Madhur Industries Ltd. Uniroyal Marine Exports Ltd. Madhur Industries Ltd. Sampre Nutritions Ltd. Madhur Industries Ltd. Datiware Maritime Infra Ltd. Madhur Industries Ltd. Oswal Overseas Ltd. Madhur Industries Ltd. Prima Agro Ltd. Madhur Industries Ltd. Natraj Proteins Ltd. Madhur Industries Ltd. Norben Tea & Exports Ltd. Madhur Industries Ltd. Poona Dal & Oil Inds. Ltd. Madhur Industries Ltd. Riga Sugar Co. Ltd. Madhur Industries Ltd. Valencia Nutrition Ltd. Madhur Industries Ltd. Sunil Agro Foods Ltd. Madhur Industries Ltd. Kohinoor Foods Ltd. Madhur Industries Ltd. Tyroon Tea Co. Ltd. Madhur Industries Ltd. Terai Tea Co. Ltd. Madhur Industries Ltd. Shah Foods Ltd. Madhur Industries Ltd. Sir Shadi Lal Enterprises Ltd. Madhur Industries Ltd. Saboo Sodium Chloro Ltd. Madhur Industries Ltd. Lotus Chocolate Co. Ltd. Madhur Industries Ltd. V S F Projects Ltd. Madhur Industries Ltd. Spectrum Foods Ltd. Madhur Industries Ltd. Progrex Ventures Ltd. Madhur Industries Ltd. Jhandewalas Foods Ltd. Madhur Industries Ltd. Dharani Sugars & Chemicals Ltd. Madhur Industries Ltd. Thiru Arooran Sugars Ltd. Madhur Industries Ltd. Diligent Industries Ltd. Madhur Industries Ltd. Prima Industries Ltd. Madhur Industries Ltd. Ravalgaon Sugar Farm Ltd. Madhur Industries Ltd. Kanco Tea & Inds. Ltd. Madhur Industries Ltd. Tirupati Starch & Chemicals Ltd. Madhur Industries Ltd. Parvati Sweetners & Power Ltd. Madhur Industries Ltd. Madhur Industries Ltd. Gayatri Sugars Ltd. Diana Tea Co. Ltd. Gayatri Sugars Ltd. Narmada Agrobase Ltd. Gayatri Sugars Ltd. Ledo Tea Co. Ltd. Gayatri Sugars Ltd. Uniroyal Marine Exports Ltd. Gayatri Sugars Ltd. Sampre Nutritions Ltd. Gayatri Sugars Ltd. Datiware Maritime Infra Ltd. Gayatri Sugars Ltd. Oswal Overseas Ltd. Gayatri Sugars Ltd. Prima Agro Ltd. Gayatri Sugars Ltd. Natraj Proteins Ltd. Gayatri Sugars Ltd. Norben Tea & Exports Ltd. Gayatri Sugars Ltd. Poona Dal & Oil Inds. Ltd. Gayatri Sugars Ltd. Riga Sugar Co. Ltd. Gayatri Sugars Ltd. Valencia Nutrition Ltd. Gayatri Sugars Ltd. Sunil Agro Foods Ltd. Gayatri Sugars Ltd. Kohinoor Foods Ltd. Gayatri Sugars Ltd. Tyroon Tea Co. Ltd. Gayatri Sugars Ltd. Terai Tea Co. Ltd. Gayatri Sugars Ltd. Shah Foods Ltd. Gayatri Sugars Ltd.         here companies in both the columns are not ESG companies      ... View more

Re: how to Identify Peer group companies from the quartiles?

by Quartz | Level 8 in SAS Programming
‎01-10-2022 01:47 PM
‎01-10-2022 01:47 PM
i tried with this code. but i am not getting the output with the desired features. it means the code is not identifying the ESG companies and not matching the peer companies as non-ESG companies from the same quartile of the ESG companies ... View more

Re: how to create datalines?

by Quartz | Level 8 in SAS Programming
‎01-10-2022 07:52 AM
‎01-10-2022 07:52 AM
i have to create SAS internal data file for my data which is in excel. i need it because, in my earlier query on SAS code for a particular data processing, the members who would like to help me, were asking the data in datalines format. ... View more

Re: how to create datalines?

by Quartz | Level 8 in SAS Programming
‎01-10-2022 07:30 AM
‎01-10-2022 07:30 AM
it is not working ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-17-2024 05:01 AM
Likes given to
Likes from
View All
Quick links