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
‎03-28-2025
  • 153 Posts
  • 32 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: how to make the type of all the variables same?

by Quartz | Level 8 in SAS Programming
‎09-03-2019 06:57 AM
‎09-03-2019 06:57 AM
dear draycut i tried the following code from the link suggested by you.  But it is not working. data test2; set test; array ch(*) $ &c_list; array nu(*) &n_list; do i = 1 to dim(ch); nu(i)=input(ch(i),8.); end; drop i &c_list; rename &renam_list; run; there are some other codes also. but i could not understand them.  i am attaching the error displayed by SAS please help me solving the problem thanks in advance   ... View more

how to transpose the data?

by Quartz | Level 8 in SAS Programming
‎09-03-2019 06:43 AM
‎09-03-2019 06:43 AM
dear all   i have the quarterly data from march, 2007 to March, 2018 in the following format.    Mar-07 Jun-07 Sep-07 Dec-07 Mar-08 Jun-08 Sep-08 Dec-08 ……………. Mar-17 Jun-17 Sep-17 Dec-17 Mar-18 Company  Investment Investment Investment Investment Investment Investment Investment Investment   Investment Investment Investment Investment Investment 3I Infotech Ltd. 24.03 27.29 30.34 31.73 33.39 33.2 32.46 28.48   52.31 48.96 47.89 47.73 38.96 3M India Ltd. 1.94 8.61 8.78 10.19 10.58 10.96 11.36 11.46   11.72 11.57 11.45 11.4 11.22 3P Land Holdings Ltd. 0.33 0.33 0.33 0.11 0.11 0.11 0.11 0.11   0.11 11.97 14.77 11.45 11.29 63 Moons Technologies Ltd. 33.03 33.39 34.42 32.61 33.8 34.65 34.38 34.03   11.56 11.18 4.51 5.33 5.48   i want to transpose the data as follows  company  Period Investment 3I Infotech Ltd. 200703 24.03 3I Infotech Ltd. 200706 27.29 3I Infotech Ltd. 200709 30.34 3I Infotech Ltd. 200712 31.73 3I Infotech Ltd. 200803 33.39 3I Infotech Ltd. 200806 33.2 3I Infotech Ltd. 200809 32.46 3I Infotech Ltd. 200812 28.48 3I Infotech Ltd. ……………… …………….. 3I Infotech Ltd. …………….. …………… 3I Infotech Ltd. ………….. ……………… 3I Infotech Ltd. 201703 52.31 3I Infotech Ltd. 201706 48.96 3I Infotech Ltd. 201709 47.89 3I Infotech Ltd. 201712 47.73 3I Infotech Ltd. 201803 38.96 3M India Ltd. 200703 1.94 3M India Ltd. 200706 8.61 3M India Ltd. 200709 8.78 3M India Ltd. 200712 10.19 3M India Ltd. 200803 10.58 3M India Ltd. 200806 10.96 3M India Ltd. 200809 11.36 3M India Ltd. 200812 11.46 3M India Ltd. ……………… 3M India Ltd. ……………..   3M India Ltd. …………..   3M India Ltd. 201703 11.72 3M India Ltd. 201706 11.57 3M India Ltd. 201709 11.45 3M India Ltd. 201712 11.4 3M India Ltd. 201803 11.22   please suggest a SAS code to transpose the data in the above format   thanks in advance          ... View more

how to make the type of all the variables same?

by Quartz | Level 8 in SAS Programming
‎09-03-2019 05:20 AM
‎09-03-2019 05:20 AM
dear all  i have 40 different variables in my dataset.  some of the variables are in character form and some are numeric.  I have to convert all tthe variables into numeric form.  how to do it in SAS.   thanks in advance.    ... View more

unable to import SAS univeristy edition through Oracle virtual box

by Quartz | Level 8 in New SAS User
‎09-01-2019 03:44 AM
‎09-01-2019 03:44 AM
i have been using SAS university edition without any problem for last one month.  But, yesterday by mistake I updated oracle virtual machine. From them, the SAS is not working.  I tried to reinstall virtual box and SAS university edition again.  I installed virtual machine and then tried to import SAS university edition. then, i am getting the following error message. Result Code: E_INVALIDARG (0x80070057)   i tried different types of solutions found in google, But i could not succeed.   Kindly help me resoving this problem.  ... View more

Re: How to transpose the multiple variables?

by Quartz | Level 8 in New SAS User
‎08-26-2019 02:11 AM
‎08-26-2019 02:11 AM
dear Mr. novinosrin thanks a lot. your SAS code is workign excellently. it is very easy and simple. ... View more

Re: How to transpose the multiple variables?

by Quartz | Level 8 in New SAS User
‎08-26-2019 02:10 AM
‎08-26-2019 02:10 AM
dear Mr. novinosrin thanks a lot. your SAS code is workign excellently. it is very easy and simple. ... View more

Re: how to compute the difference between current year and previous ye...

by Quartz | Level 8 in New SAS User
‎08-24-2019 03:16 PM
‎08-24-2019 03:16 PM
thank you Mr. Paige Miller for your quick reply. your SAS code is working excellently with one small correction i.e., prev_sales=lag(sales); thanks a lot ... View more

How to transpose the multiple variables?

by Quartz | Level 8 in New SAS User
‎08-24-2019 10:13 AM
‎08-24-2019 10:13 AM
dear all,  my dataset has multiple variables each variable is repeated for multiple number of  years, Each column in he dataset represent a variable-year.  I have to transpose the  data based on variable by creating separate column of each variable containing all the time series   the present format of the dataset is as follows Company Name PBDITA2010 Depreciation2010 sales2010 PBDITA2011 Depreciation2011 sales2011 …………….. PBDITA2018 Depreciation2018 sales2018 20 Microns Ltd. 238.7 47.5 1768.2 256.1 53.3 2349.8   545 91.1 3845.7 3I Infotech Ltd. 649.6 405 5195.3 3087.6 517.5 5479.2   1578.8 71.6 2368.2 3M India Ltd. 1648.8 169.5 10912.8 1727.9 173.7 11891.2   5308.7 418 25597.6 3P Land Holdings Ltd. 70.5 11.4 701.7 41.8 16.6 989.7   15.9 0.7 1.4 A B B India Ltd. 7455.1 485.1 62419.9 3618.5 516.6 62947.7   1534.7 221.6 2341 A B C Gas (International) Ltd. 1.8 0.1 136.3 3.6 0.1 239.9   3.1 0.9 100.8 A B C India Ltd. 84.5 24.1 1442.7 197.9 42 2039.4   11.6 6.3 13.4 A B G Shipyard Ltd. 6427.9 524.1 18076.7 6837.6 630.3 20770.9   156.7 8.4 504.9   the required format should be as follows   Company Name year PBDITA Depreciation sales 20 Microns Ltd. 2010 238.7 47.5 1768.2 3I Infotech Ltd. 2010 649.6 405 5195.3 3M India Ltd. 2010 1648.8 169.5 10912.8 3P Land Holdings Ltd. 2010 70.5 11.4 701.7 A B B India Ltd. 2010 7455.1 485.1 62419.9 A B C Gas (International) Ltd. 2010 1.8 0.1 136.3 A B C India Ltd. 2010 84.5 24.1 1442.7 A B G Shipyard Ltd. 2010 6427.9 524.1 18076.7 20 Microns Ltd. 2011 256.1 53.3 2349.8 3I Infotech Ltd. 2011 3087.6 517.5 5479.2 3M India Ltd. 2011 1727.9 173.7 11891.2 3P Land Holdings Ltd. 2011 41.8 16.6 989.7 A B B India Ltd. 2011 3618.5 516.6 62947.7 A B C Gas (International) Ltd. 2011 3.6 0.1 239.9 A B C India Ltd. 2011 197.9 42 2039.4 A B G Shipyard Ltd. 2011 6837.6 630.3 20770.9 20 Microns Ltd. 2018 545 91.1 3845.7 3I Infotech Ltd. 2018 1578.8 71.6 2368.2 3M India Ltd. 2018 5308.7 418 25597.6 3P Land Holdings Ltd. 2018 15.9 0.7 1.4 A B B India Ltd. 2018 1534.7 221.6 2341 A B C Gas (International) Ltd. 2018 3.1 0.9 100.8 A B C India Ltd. 2018 11.6 6.3 13.4 A B G Shipyard Ltd. 2018 156.7 8.4 504.9   thanks in advance  ... View more

how to compute the difference between current year and previous year v...

by Quartz | Level 8 in New SAS User
‎08-24-2019 09:40 AM
‎08-24-2019 09:40 AM
dear all  i have to compute  "change in sales" as the difference between current year and previous year values of variable on rolling basis in a panel data in SAS the format of my dataset is as follows Company_Name year sales  change_sales 20 Microns Ltd. 2005 565.2   20 Microns Ltd. 2006 668.9 103.7 20 Microns Ltd. 2007 869.1 200.2 20 Microns Ltd. 2008 1067.8 198.7 20 Microns Ltd. 2009 1374.9 307.1 20 Microns Ltd. 2010 1768.2 393.3 20 Microns Ltd. 2011 2349.8 581.6 20 Microns Ltd. 2012 2626.2 276.4 3I Infotech Ltd. 2005 2064.7   3I Infotech Ltd. 2006 2755.5 690.8 3I Infotech Ltd. 2007 3313.1 557.6 3I Infotech Ltd. 2008 4451 1137.9 3I Infotech Ltd. 2009 5249.6 798.6 3I Infotech Ltd. 2010 5195.3 -54.3 3I Infotech Ltd. 2011 5479.2 283.9 3I Infotech Ltd. 2012 5117.8 -361.4 3M India Ltd. 2005 2552   3M India Ltd. 2006 3780.5 1228.5 3M India Ltd. 2007 5030.7 1250.2 3M India Ltd. 2008 6066.1 1035.4 3M India Ltd. 2009 7413 1346.9 3M India Ltd. 2010 10912.8 3499.8 3M India Ltd. 2011 11891.2 978.4 3M India Ltd. 2012 14033 2141.8   thanks in advance  ... View more

how to compute rolling standard deviation ?

by Quartz | Level 8 in New SAS User
‎08-21-2019 01:59 AM
‎08-21-2019 01:59 AM
dear all  i have to compute rolling standard deviation based on past five years values of a variable.  my data set is as follows    Company_Name year sales std. dev 20 Microns Ltd. 2005 565.2   20 Microns Ltd. 2006 668.9   20 Microns Ltd. 2007 869.1   20 Microns Ltd. 2008 1067.8   20 Microns Ltd. 2009 1374.9 =STDEV(C2:C6) 20 Microns Ltd. 2010 1768.2 =STDEV(C3:C7) 3I Infotech Ltd. 2005 2064.7   3I Infotech Ltd. 2006 2755.5   3I Infotech Ltd. 2007 3313.1   3I Infotech Ltd. 2008 4451   3I Infotech Ltd. 2009 5249.6 =STDEV(C8:C12) 3I Infotech Ltd. 2010 5195.3 =STDEV(C9:C13)   it is in panel data format with more than 3000 companies from 2005 to 2018.  the calculation of standard deviation should be done company-wise.  i want to give equal weightage to all the observation for a company. there are no missing values in the dataset.    thanks in advance  ... View more

Re: how to compute standad deviation

by Quartz | Level 8 in New SAS User
‎08-20-2019 04:03 AM
‎08-20-2019 04:03 AM
dear Mr. PaigeMiller greetings of the day   for the computation of standard deviation, I would like to give equal weightage to all the time series observations.  please help me writing the code.    thanks in advance  ... View more

how to compute average of the given values for the last three years re...

by Quartz | Level 8 in SAS Programming
‎08-12-2019 02:08 PM
‎08-12-2019 02:08 PM
Dear all, Greetings of the day   I have  the quarterly data of a variable from june,2009 to march, 2018.   with those values, i have to compute the average value of the variable for the previous three years.    For example, at the end of march, 2012, i have to compute the average value of the variable from june,2009 to march,2012. Next at the end of march, 2013, i have to compute the average value of the variable from june,2010 to march,2013. and so on  till march, 2018.    the format of my dataset is as follows Company Name var_june2009 var_sept2009 var_dec2009 var_march2010 ................ var_march2018 20 Microns Ltd. 2.05 2.05 0.46 0.29 .............. 0.29 3I Infotech Ltd. 4.41 7.74 16.59 8.08 ............... 8.22 3M India Ltd. 5.92 5.88 5.42 5.33 ............... 5.14   please help me writing the SAS code to perform the above mentioned calculation.    thanks in advance.  ... View more

how to use array function to perform arithmetic calculation repeatedl...

by Quartz | Level 8 in New SAS User
‎08-12-2019 01:55 PM
‎08-12-2019 01:55 PM
Dear all Greetings of the day   i have to perform a arithmetical calculation repeated on the same dataset with the repeated variables from the year 2010 to 2018.  my data set is as follows    Var1_2010 var2_2010 var3_2010 Var1_2011 var2_2011 var3_2011 …………. Var1_2018 var2_2018 var3_2018 21.21 -1.4 -19.8 1.5 5.7 32.1   59.8 21.16 -8.9 5892.48 1807 245.7 824.6 158 7712.8   7617.3 5786.81 2025.8 107.71 -4.6 -18.5 1.2   -1.6   22.6 4.9 -5.9 206.18 35.6 1.5 79.9 19.5 1082   651.6 235.06 51.4 1080.4 -422.2 113.9 158.7 28.6 845.4   1885.2 1103.55 -755.9   I have to do the computation as follows newvar_2010=var1_2010*0.345+var2_2010*0.657+var3*0.768     i have to repeat it for all the remaining years in the same way  from 2011 to 2018. please suggest me a SAS code to do the calculation as mentioned above.    thanks in advance.    ... View more

Re: computation of industry share of each company

by Quartz | Level 8 in New SAS User
‎08-12-2019 01:37 AM
‎08-12-2019 01:37 AM
thank you Mr. KurtBremser. your code is useful to me in computing the industry share. thanks a lot . ... View more

Re: computation of industry share of each company

by Quartz | Level 8 in New SAS User
‎08-10-2019 06:42 AM
‎08-10-2019 06:42 AM
Dear KurtBremser  thanks for your prompt reply to my query.    your code is working, but it is generating only the industry total sales, but not the percentage.  please see the output Company Net_sales__2010 sum_sales percentage A R G L Ltd. 2329.6 44677.5   International Tractors Ltd. 14765.4 44677.5   Escorts Ltd. 27500.6 44677.5   Awachat Industries Ltd. 81.9 44677.5   Bagalkot Cement & Inds. Ltd. 525.6 150508.1   Ambuja Cements Ltd. 70714.6 150508.1   A C C Ltd. 79214.3 150508.1   Balaram Cements Ltd. 53.6 150508.1   Anand Agrochem India Ltd. 189.6 1002.8   Agauta Sugar & Chemicals Ltd. 264.5 1002.8   Anuraj Sugars Ltd. 548.7 1002.8   Arcuttipore Tea Co. Ltd. 29.9 6651.2   Apeejay Tea Ltd. 2998 6651.2   Alipurduar Tea Co. Ltd. 48.4 6651.2   A V Thomas & Co. Ltd. 3574.9 6651.2     please help me in solving this problem.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-28-2025 07:19 AM
Group Hubs for srikanthyadav44
View All
Likes given to
Likes from
View All
Quick links