No, I want to remove the first two digits and last two digits from "cusip" observations. Those notes were shown in log file. And the output dataset shows blank observations i.e. no observation at all. ... View more

Hi, I cannot attach the SAS file. So I have attached the CSV file. ... View more

I include the SAS file.I cannot attach the SAS file, but I have attached the CSV file. ... View more

Hi, After running your codes, more observations are shown in the "Final" dataset than the original dataset. How to address this issue? ... View more

Hi, It is not working and shows the following messages: NOTE: Numeric values have been converted to character values at the places given by:       (Line):(Column).       127:16 NOTE: Character values have been converted to numeric values at the places given by:       (Line):(Column).       127:9 ... View more

Hi again, I need to calculate ca at time t+1 as well. So, ca values at t-1, t and t+1. ... View more

Thanks. I will try the code and let you know. I did not read the documentation at this moment. Will you please send me the link? ... View more

Sometimes I need DIF1 only, and sometimes I need all three. So it's better to do for all three. I can do the DIF1 for one variable (according to your previous code). But now there are three variables (ca, cl and stdebt). ... View more

Ok, the following is my sample dataset. ca is current asset, cl is current liability and stdebt is short term debt. So I need to calculate the lca1, lca2, lca3 (which we already did before). Now need to calculate the difference between ca and lca1 .... (which is the change in ca between year 2004 and year 2003). In this way, need to same for cl and stdebt as well. In final output, observations for year 2003 and 2013 will have to be dropped. year   companyISIN     ca            cl             stdebt 2003 AN8068571086 10369000 6795000 1411000 2004 AN8068571086 7060000 4701000 716000 2005 AN8068571086 8554000 5515000 796000 2006 AN8068571086 9186000 6455000 1321000 2007 AN8068571086 11055000 7505000 1672000 2008 AN8068571086 12894000 8124000 1597000 2009 AN8068571086 13650000 7259000 1125000 2010 AN8068571086 18098000 10865000 2595000 2011 AN8068571086 20539000 10538000 1377000 2012 AN8068571086 24156000 12368000 2121000 2013 AN8068571086 26225000 13525000 2783000 2003 ANN6748L1027 117555 42087 8852 2004 ANN6748L1027 119830 33449 7468 2005 ANN6748L1027 175355 66052 12915 2006 ANN6748L1027 177348 46268 2586 2007 ANN6748L1027 192332 50215 8252 2008 ANN6748L1027 197199 53846 3759 2009 ANN6748L1027 209047 61461 3868 2010 ANN6748L1027 232885 62394 8450 2011 ANN6748L1027 312343 135418 14527 2012 ANN6748L1027 258057 52148 12 2013 ANN6748L1027 204018 48645 . 2003 BMG0129K1045 . . . 2004 BMG0129K1045 7935 5746 0 2005 BMG0129K1045 745097 553813 496757 2006 BMG0129K1045 65682 391042 185702 2007 BMG0129K1045 18503 1534434 945035 2008 BMG0129K1045 84108 799848 136738 2009 BMG0129K1045 145607 868804 170089 2010 BMG0129K1045 241772 1110606 302223 2011 BMG0129K1045 299168 1080563 247228 2012 BMG0129K1045 623842 1079469 281611 2013 BMG0129K1045 832675 602781 365325 ... View more

I also need to calculate the change in asset i.e. delta_asset = asset - lasset1. If I want to perform these operations (i.e. calculating lag then calculating the change) for more than one variable (say, asset is one variable, debt is another variable etc.) then what will be the code? ... View more

Thanks. Your code works. ... View more

Thanks. Your code works as well. But I also need to drop the observations of year 2003 and 2013. ... View more

Thanks. I also need to drop the observations of year 2003 and 2013. So will I just write the two following lines after "drop i c"?    if year = 2003 then delete;    if year = 2013 then delete; ... View more

Say, these are asset values of the companies at time t. I want to have asset values at t-1. This means, in year 2004, I want the asset value of year 2003. ... View more