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
‎02-26-2023
  • 153 Posts
  • 32 Likes Given
  • 1 Solutions
  • 2 Likes Received

how to repeat weekly values for all the days in the week?

by Quartz | Level 8 in SAS Programming
‎02-26-2023 03:27 AM
‎02-26-2023 03:27 AM
dear all i have the data on interest rates in weekly frequency.  i would like to convert it into daily frequency by repeating the same rates throughout the week. please suggest a SAS code to perform this function  my data is in the following format  date  interest_rate 30-Jun-2021 3.8898 07-Jul-2021 3.8419 14-Jul-2021 3.8099 20-Jul-2021 3.7744 28-Jul-2021 3.7299   i want output in the following format  date  interest_rate 30-Jun-2021 3.8898 01-Jul-2021 3.8898 02-Jul-2021 3.8898 03-Jul-2021 3.8898 04-Jul-2021 3.8898 05-Jul-2021 3.8898 06-Jul-2021 3.8898 07-Jul-2021 3.8419 08-Jul-2021 3.8419 09-Jul-2021 3.8419 10-Jul-2021 3.8419 11-Jul-2021 3.8419 12-Jul-2021 3.8419 13-Jul-2021 3.8419 14-Jul-2021 3.8099 15-Jul-2021 3.8099 16-Jul-2021 3.8099 17-Jul-2021 3.8099 18-Jul-2021 3.8099 19-Jul-2021 3.8099 20-Jul-2021 3.7744 21-Jul-2021 3.7744 22-Jul-2021 3.7744 23-Jul-2021 3.7744 24-Jul-2021 3.7744 25-Jul-2021 3.7744 26-Jul-2021 3.7744 27-Jul-2021 3.7744 28-Jul-2021 3.7299 29-Jul-2021 3.7299 30-Jul-2021 3.7299 31-Jul-2021 3.7299 01-Aug-2021 3.7299 02-Aug-2021 3.7299 03-Aug-2021 3.7299     thanking in advance        ... View more

how to interpret EGARCH output in SAS ?

by Quartz | Level 8 in SAS Forecasting and Econometrics
‎01-27-2023 12:25 AM
‎01-27-2023 12:25 AM
Dear all The SAS is using the following notation to run EGARCH   I run the EGARCH model on nifty50_returns in SAS with the following code  proc autoreg data=garch; model Nifty50_return= / garch=(p=1,q=1, type=exp) maxit=1500; run;   I got the following output. I could not understand how to interpret the parameters.  Which is the asymmetry parameter in the equation?   Earlier, i used to apply Eviews to run EGARCH. Eviews uses the following equation for EGARCH.  LOG(GARCH) = C(2) + C(3)*ABS(RESID(-1)/@SQRT(GARCH(-1))) + C(4)*RESID(-1)/@SQRT(GARCH(-1)) + C(5)*LOG(GARCH(-1))   For the same variable, I got the following output in Eviews Variable Coefficient Std. Error z-Statistic Prob.            C 0.030646 0.015879 1.929991 0.0536             Variance Equation                 C(2) -0.09955 0.01165 -8.54524 0 C(3) 0.127285 0.014562 8.740835 0 C(4) -0.10378 0.006991 -14.8442 0 C(5) 0.974315 0.003433 283.8053 0   i am not able to correlate the results of views and GARCH and also unable to interpret the EGARCH parameters from SAS. Can anybody help me in this regard?   Thanks in advance    ... View more

unblanced to balanced panel?

by Quartz | Level 8 in New SAS User
‎12-25-2022 07:53 AM
‎12-25-2022 07:53 AM
dear all  i have the panel data in unbalanced form.  i have to convert it into balanced form by imputing the missing values with mean of the respective company from the time period 2011 to 2021.    the following is my data format  company_name year var 20 Microns Ltd. 2011 0.805904 20 Microns Ltd. 2012 0.828198 20 Microns Ltd. 2013 0.817836 20 Microns Ltd. 2016 0.755992 20 Microns Ltd. 2017 0.773837 20 Microns Ltd. 2018 0.725707 20 Microns Ltd. 2019 0.695296 20 Microns Ltd. 2020 0.656195 20 Microns Ltd. 2021 0.580448 3I Infotech Ltd. 2011 5.643716 3I Infotech Ltd. 2013 6.415471 3I Infotech Ltd. 2014 8.262973 3I Infotech Ltd. 2015 7.151063 3I Infotech Ltd. 2016 3.419378 3I Infotech Ltd. 2017 4.005865 3I Infotech Ltd. 2019 6.123732 3I Infotech Ltd. 2020 5.872237 3I Infotech Ltd. 2021 5.987689   I need the output in the following format  company_name year var 20 Microns Ltd. 2011 0.805904 20 Microns Ltd. 2012 0.828198 20 Microns Ltd. 2013 0.817836 20 Microns Ltd. 2014 0.737712 20 Microns Ltd. 2015 0.737712 20 Microns Ltd. 2016 0.755992 20 Microns Ltd. 2017 0.773837 20 Microns Ltd. 2018 0.725707 20 Microns Ltd. 2019 0.695296 20 Microns Ltd. 2020 0.656195 20 Microns Ltd. 2021 0.580448 3I Infotech Ltd. 2011 5.643716 3I Infotech Ltd. 2012 5.875792 3I Infotech Ltd. 2013 6.415471 3I Infotech Ltd. 2014 8.262973 3I Infotech Ltd. 2015 7.151063 3I Infotech Ltd. 2016 3.419378 3I Infotech Ltd. 2017 4.005865 3I Infotech Ltd. 2018 5.875792 3I Infotech Ltd. 2019 6.123732 3I Infotech Ltd. 2020 5.872237 3I Infotech Ltd. 2021 5.987689   please suggest to me a SAS code for mean imputation in panel data  thanking you in advance  ... View more

Re: generating frequency table for the words?

by Quartz | Level 8 in SAS Programming
‎11-21-2022 05:54 AM
‎11-21-2022 05:54 AM
Dear Mr. Kurt_Bremser   can you please show me the SAS code  i am not able to do it    thanking you in advance  ... View more

Re: generating frequency table for the words?

by Quartz | Level 8 in SAS Programming
‎11-21-2022 05:52 AM
‎11-21-2022 05:52 AM
can you please write the SAS CODE     Thanking you in advance  ... View more

Re: generating frequency table for the words?

by Quartz | Level 8 in SAS Programming
‎11-21-2022 04:46 AM
‎11-21-2022 04:46 AM
just as an example, i have shown it. Ltd and ltd are the same. SAS treats them as same,its great ... View more

generating frequency table for the words?

by Quartz | Level 8 in SAS Programming
‎11-21-2022 02:13 AM
‎11-21-2022 02:13 AM
dear all    i have my data in the following format  investor 3A Capital Services Limited 3A Capital Services Ltd A M M Vellayan Sons P Ltd Aadi Financial Advisors Llp Aagam Holdings Private Limited Abakkus Emerging Opportunities Fund-1 Abakkus Growth Fund-1 Aberdeen Global Indian Equity Fund Mauritius Ltd   I have to generate a frequency table for the words repeated in the above table  i need the output in the following format word frequency 3A 2 capital 2 services  2 Limited  2 Ltd 3 A 1 M 1 M 1 Vellayan  1 sons  1 p 1 Aadi 1 fnancial  1 Advisors  1 Llp 1 Aagam 1 Holdings  1 Private 1 Abakkus  2 Emerging  1 Opportunities  1 Fund-1 2 Growth 1 Aberdeen  1 Global  1 Idian    Equity  1 fund 1 Mauritius 1 i am attaching a sample file in .CSV format    please suggest me a SAS code    thanking you in advance      ... View more

SAS query to transpose the column to single column?

by Quartz | Level 8 in SAS Programming
‎11-21-2022 12:57 AM
‎11-21-2022 12:57 AM
dear all i have my data in the followng format  Group_code comany01 comany02 comany03 comany04 comany05 64191 Axis Bank Ltd. Punjab National Bank H D F C Bank Ltd. Kotak Mahindra Bank Ltd. I C I C I Bank Ltd. 30911 Bajaj Auto Ltd. T V S Motor Co. Ltd. Hero Motocorp Ltd. Eicher Motors Ltd.   2513 Bharat Heavy Electricals Ltd.         61209 Bharti Airtel Ltd. Reliance Communications Ltd.   Vodafone Idea Ltd.   41001 D L F Ltd. Unitech Ltd.   Housing Development & Infrastructure Ltd.   21002 Dr. Reddy'S Laboratories Ltd. Glaxosmithkline Pharmaceuticals Ltd. Cipla Ltd. Lupin Ltd. Sun Pharmaceutical Inds. Ltd. 52109 G A I L (India) Ltd. Petronet L N G Ltd.   Indraprastha Gas Ltd.   64191 H D F C Bank Ltd. Axis Bank Ltd. I C I C I Bank Ltd. Punjab National Bank State Bank Of India 20239 Hindustan Unilever Ltd. Procter & Gamble Hygiene & Health Care Ltd.   Jyothy Labs Ltd.   64192 Housing Development Finance Corpn. Ltd. L I C Housing Finance Ltd.   Dewan Housing Finance Corpn. Ltd.     i have to transpose the five columns of the companies into a single column by group code  . I need the output in the following format  code  company  64191 Axis Bank Ltd. 64191 Punjab National Bank 64191 H D F C Bank Ltd. 64191 Kotak Mahindra Bank Ltd. 64191 I C I C I Bank Ltd. 30911 Bajaj Auto Ltd. 30911 T V S Motor Co. Ltd. 30911 Hero Motocorp Ltd. 30911 Eicher Motors Ltd. 2513 Bharat Heavy Electricals Ltd. 61209 Bharti Airtel Ltd. 61209 Reliance Communications Ltd. 61209 Vodafone Idea Ltd.  please suggest me an appropriate SAS CODE  i am attaching the sample input file .CSV format   thanking you in advance  ... View more

Re: SAS Programming to compute average CSR?

by Quartz | Level 8 in SAS Programming
‎11-18-2022 10:22 PM
‎11-18-2022 10:22 PM
Dear Ms. Reeza   thanks for your response.    in my dataset, the number of companies is not the same across all the industries. they vary from industry to industry and year to year also.  and CSR represents the amount of CSR spent mentioned in millions.  ... View more

Re: SAS Programming to compute average CSR?

by Quartz | Level 8 in SAS Programming
‎11-18-2022 01:29 PM
‎11-18-2022 01:29 PM
Dear Mr. Kurt_Bremser greetings of the day    thanks a lot for your prompt reply   i have calculated the values in the sample output manually as follows =avg(7.2+1.6+6.9+2.2+4.7)=4.52 =AVG(9.2,1.6,6.9,2.2,4.7)=4.92 =AVERAGE(9.2,7.2,6.9,2.2,4.7)=6.04   As i mentioned in calculating the average for a particular company, value of that company should be excluded. that's why, i got different values.  the sample output,  i have given only a model output for a few cells. so, there are no values from 2016 onwards    please suggest SAS code with this condition  ... View more

SAS Programming to compute average CSR?

by Quartz | Level 8 in SAS Programming
‎11-18-2022 12:38 PM
‎11-18-2022 12:38 PM
dear all,  I have the data on spending on CSR from 2015 to 2019 for companies in different industries.  I have to compute the average CSR spending by each industry for every year from 2015 to 2019.  in calculating the average CSR spending of the industry for the given year, the CSR spending of the given company should be excluded.    For example, in 2015, for industry code 10, there are five companies, In calculating the average CSR spending for "Balrampur Chini Mills Ltd. " I should calculate the average for the remaining 4 companies excluding this particular company and for calculating the average CSR spending for "Avanti Feeds Ltd." I should exclude this particular company and the average should be computed for the remaining four companies.    my data is in the following format  Company_Name year code CSR Balrampur Chini Mills Ltd. 2015 10 9.2 Avanti Feeds Ltd. 2015 10 7.2 Sayaji Industries Ltd. 2015 10 1.6 Jubilant Foodworks Ltd. 2015 10 6.9 Apex Frozen Foods Ltd. 2015 10 2.2 Ruchi Soya Inds. Ltd. 2015 10 4.7 Jayant Agro-Organics Ltd. 2016 10 1.7 Godrej Agrovet Ltd. 2016 10 21.5 Piccadily Agro Inds. Ltd. 2016 10 5.3 Kothari Sugars & Chemicals Ltd. 2016 10 1.5 Kanco Tea & Inds. Ltd. 2016 10 0.8 Manpasand Beverages Ltd. 2016 10 4.3 Foods & Inns Ltd. 2016 10 0.5 Banswara Syntex Ltd. 2015 13 1.6 Flexituff Ventures Intl. Ltd. 2015 13 7.2 Raymond Ltd. 2015 13 5.3 Indo Count Inds. Ltd. 2015 13 1.1 Suryalata Spinning Mills Ltd. 2015 13 2.2    In the above data, CSR stands for CSR spending and Code denotes industry classification code. I need the output in the following format.    Company_Name year code CSR average Balrampur Chini Mills Ltd. 2015 10 9.2 4.52 Avanti Feeds Ltd. 2015 10 7.2 4.92 Sayaji Industries Ltd. 2015 10 1.6 6.04 Jubilant Foodworks Ltd. 2015 10 6.9 4.98 Apex Frozen Foods Ltd. 2015 10 2.2 5.92 Ruchi Soya Inds. Ltd. 2015 10 4.7 5.42 Jayant Agro-Organics Ltd. 2016 10 1.7 5.09 Godrej Agrovet Ltd. 2016 10 21.5   Piccadily Agro Inds. Ltd. 2016 10 5.3   Kothari Sugars & Chemicals Ltd. 2016 10 1.5   Kanco Tea & Inds. Ltd. 2016 10 0.8   Manpasand Beverages Ltd. 2016 10 4.3   Foods & Inns Ltd. 2016 10 0.5   Banswara Syntex Ltd. 2015 13 1.6   Flexituff Ventures Intl. Ltd. 2015 13 7.2   Raymond Ltd. 2015 13 5.3   Indo Count Inds. Ltd. 2015 13 1.1   Suryalata Spinning Mills Ltd. 2015 13 2.2     please suggest me an appropriate SAS CODE i am attaching the .CSV file also.    ... View more

from peer group of ESG companies how to find whether the ESG company h...

by Quartz | Level 8 in SAS Programming
‎11-14-2022 03:57 AM
‎11-14-2022 03:57 AM
Dear all  greetings of the day it is the continuation of the further programming for the previous data in which i requested a SAS programming code to identify the peer group companies  my dataset is in the following format Name year mcap synch code RANK ESG Oil & Natural Gas Corpn. Ltd. 2010 2,349,765 1.60 610 1 1 Oil India Ltd. 2010 277,160 0.55 610 2 0 Selan Exploration Technology Ltd. 2010 6,604 1.53 610 3 0 Bharat Heavy Electricals Ltd. 2010 1,168,998 0.49 2513 1 1 Godrej Consumer Products Ltd. 2011 118,256 0.61 34 1 0 Tata Chemicals Ltd. 2011 86,662 0.58 34 2 0 Piramal Enterprises Ltd. 2011 69,996 0.59 34 3 1 H M T Ltd. 2011 45,032 1.35 34 4 0 K S K Energy Ventures Ltd. 2011 37,636 0.95 34 5 0 B A S F India Ltd. 2011 25,692 0.15 34 6 0 Peninsula Land Ltd. 2011 16,550 0.87 34 7 0 Texmaco Rail & Engg. Ltd. 2011 12,729 2.68 34 8 0 Alembic Ltd. 2011 9,760 2.59 34 9 0 I T I Ltd. 2011 9,202 3.41 34 10 0 Balmer Lawrie & Co. Ltd. 2011 8,876 2.94 34 11 0 Man Infraconstruction Ltd. 2011 6,957 3.75 34 12 0 D C M Shriram Ltd. 2011 6,678 2.77 34 13 0 Venky'S (India) Ltd. 2011 5,971 3.75 34 14 0 Bombay Burmah Trdg. Corpn. Ltd. 2011 5,537 3.25 34 15 0 T I L Ltd. 2011 5,058 3.55 34 16 0 Nitin Fire Protection Inds. Ltd. 2011 4,660 2.07 34 17 0 Jindal Cotex Ltd. 2011 4,559 3.31 34 18 0 Texmaco Infrastructure & Holdings Ltd. 2011 4,000 1.65 34 19 0 India Glycols Ltd. 2011 3,473 1.12 34 20 0 Kokuyo Camlin Ltd. 2011 3,239 1.04 34 21 0 Globus Spirits Ltd. 2011 2,830 1.09 34 22 0 B S Ltd. 2011 1,880 1.60 34 23 0 Technocraft Industries (India) Ltd. 2011 1,758 0.68 34 24 0   From the above database, i have to create a dummy variable that takes the value '1' if the ESG company (e., the company with value '1' in the ESG column) has the highest  'synch' compared to other companies in the peer group.   Peer group definition is the same as I mentioned in the previous query  if the company is making ESG reporting, ( i.e., value is equal to '1'), identify the companies which are closer to ESG reporting companies based on their MCAP(market capitalization) as peer companies within each industry code. the closeness should be just below the ESG company MCAP and just above the ESG company MCAP in two levels  in some industry groups, we cannot find peer companies just above the MCAP of ESG companies, and also in some industries, only one company. in such case no peer company     the output should be in the following format  name year  code  dummy Oil & Natural Gas Corpn. Ltd. 2010 610 1 Piramal Enterprises Ltd. 2011 34 1 Zee Entertainment Enterprises Ltd. 2011 6020 0   hope I mentioned the conditions clearly. if any clarity is required on the conditions, please let me know. i am attaching the .CSV file of the sample data  please suggest to me a SAS code to generate  the above table thanking you  in advance  ... View more

Re: how to filter the peer group companies

by Quartz | Level 8 in SAS Programming
‎11-13-2022 09:54 PM
‎11-13-2022 09:54 PM
thanks a lot . the CODE is working. i have to extend the code further to do further analysis. i posting the details. could you please help me out thanking you in advance ... View more

how to filter the peer group companies

by Quartz | Level 8 in SAS Programming
‎11-11-2022 09:04 PM
‎11-11-2022 09:04 PM
Dear all  greetings of the day    i have my dataset in the following format  Company_Name year mcap industry_code MCAPRANK ESG reporting Oil & Natural Gas Corpn. Ltd. 2010 2,349,765 610 1 1 Oil India Ltd. 2010 277,160 610 2 0 Selan Exploration Technology Ltd. 2010 6,604 610 3 0 Bharat Heavy Electricals Ltd. 2010 1,168,998 2513 1 1 Godrej Consumer Products Ltd. 2011 118,256 34 1 0 Tata Chemicals Ltd. 2011 86,662 34 2 0 Piramal Enterprises Ltd. 2011 69,996 34 3 1 H M T Ltd. 2011 45,032 34 4 0 K S K Energy Ventures Ltd. 2011 37,636 34 5 0 B A S F India Ltd. 2011 25,692 34 6 0 Peninsula Land Ltd. 2011 16,550 34 7 0 Texmaco Rail & Engg. Ltd. 2011 12,729 34 8 0 Alembic Ltd. 2011 9,760 34 9 0 i have to identify the peer group companies. the criteria are as follows if the company is making ESG reporting, ( i.e., value is equal to '1'), identify the companies which are closer to ESG reporting companies based on their MCAP(market capitalization) as peer companies within each industry code. the closeness should be just below the ESG company MCAP and just above the ESG company MCAP in two levels  in some industry groups, we cannot find peer companies just above the MCAP of ESG companies, and also in some industries, only one company. in such case no peer company   the output should be in the following format company_name year industry_code Peer01_Low  Peer01_high Peer02_low Peer02_high Oil & Natural Gas Corpn. Ltd. 2010 610 Oil India Ltd. 0 Selan Exploration Technology Ltd. 0 Bharat Heavy Electricals Ltd. 2010 2513 0 0 0 0 Piramal Enterprises Ltd. 2011 34 H M T Ltd. Tata Chemicals Ltd. K S K Energy Ventures Ltd. Godrej Consumer Products Ltd.   Peer01_low = means immediately succeeding peer company based on MCAP within the industry  Peer01_high =means immediately preceding peer company based on MCAP within the industry Peer02_low=means next to immediately succeeding peer company based on MCAP within the industry  Peer02_high =means prior  to immediately preceding peer company based on MCAP within the industry   in the above table for 'Oil & Natural Gas Corpn. Ltd'  peer01_high is zero, it means no peer company in the industry with a market capitalization of more than ESG Company    hope i mentioned the conditions clearly. if any clarity is required on the conditions, please let me know. i could not genet the data lines, so, i am attaching the sample company in . CSV format.    PLEASE HELP ME OUT IN WRITING THE SAS QUERY.  THANKING YOU IN ADVANCE     ... View more

Re: How to get frequency table in a separate excel sheet?

by Quartz | Level 8 in SAS Programming
‎09-16-2022 05:10 AM
‎09-16-2022 05:10 AM
no . i did not get any message like that  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-26-2023 02:03 PM
Likes given to
Likes from
View All
Quick links