Hello everybody; I decide to run a regression based on decile of data. suppose that I have firm, date and price variables. So I want to make decile by average price of each firm. For instance, the 10th decile has firms with the highest average price and first decile has firms with the lowest average price and so on.   How can I make this decile? How can I run this regression?   Thanks in advance. ... View more

Hello everybody; I want to convert the gregorian date to solar Hijri calendar (Iranian calendars - Wikipedia, the free encyclopedia). I found a program in previous posts which was written by @art297 and it is awesome to convert solar Hijri to Gregorian calendar as shown below:     data ctrl (keep=fmtname type start label); informat gdates $31.; infile cards dlm=','; input _pyear $ gdates &; retain fmtname 'pdate' type 'j'; leap=index(_pyear,'*'); pyear=input(compress(_pyear,'*'),12.); bday=input(scan(gdates,1,'.'),12.); byear=input(scan(gdates,3),12.); bmonth=3; if _n_ eq 1 then label=mdy(bmonth,bday,byear)-1; do pmonth=1 to 12; if pmonth le 6 then eday=31; else if pmonth le 11 then eday=30; else if leap then eday=30; else eday=29; do pday=1 to eday; label+1; start=catx('-',pyear,put(pmonth,z2.),put(pday,z2.)); output; end; end; cards; 1354*,21. March 1975 – 20. March 1976 1355,21. March 1976 – 20. March 1977 1356,21. March 1977 – 20. March 1978 1357,21. March 1978 – 20. March 1979 1358*,21. March 1979 – 20. March 1980 1359,21. March 1980 – 20. March 1981 1360,21. March 1981 – 20. March 1982 1361,21. March 1982 – 20. March 1983 1362*,21. March 1983 – 20. March 1984 1363,21. March 1984 – 20. March 1985 1364,21. March 1985 – 20. March 1986 1365,21. March 1986 – 20. March 1987 1366*,21. March 1987 – 20. March 1988 1367,21. March 1988 – 20. March 1989 1368,21. March 1989 – 20. March 1990 1369,21. March 1990 – 20. March 1991 1370*,21. March 1991 – 20. March 1992 1371,21. March 1992 – 20. March 1993 1372,21. March 1993 – 20. March 1994 1373,21. March 1994 – 20. March 1995 1374,21. March 1995 – 19. March 1996 1375*,20. March 1996 – 20. March 1997 1376,21. March 1997 – 20. March 1998 1377,21. March 1998 – 20. March 1999 1378,21. March 1999 – 19. March 2000 1379*,20. March 2000 – 20. March 2001 1380,21. March 2001 – 20. March 2002 1381,21. March 2002 – 20. March 2003 1382,21. March 2003 – 19. March 2004 1383*,20. March 2004 – 20. March 2005 1384,21. March 2005 – 20. March 2006 1385,21. March 2006 – 20. March 2007 1386,21. March 2007 – 19. March 2008 1387*,20. March 2008 – 20. March 2009 1388,21. March 2009 – 20. March 2010 1389,21. March 2010 – 20. March 2011 1390,21. March 2011 – 19. March 2012 1391*,20. March 2012 – 20. March 2013 1392,21. March 2013 – 20. March 2014 1393,21. March 2014 – 20. March 2015 1394,21. March 2015 – 19. March 2016 1395*,20. March 2016 – 20. March 2017 1396,21. March 2017 – 20. March 2018 1397,21. March 2018 – 20. March 2019 1398,21. March 2019 – 19. March 2020 1399*,20. March 2020 – 20. March 2021 1400,21. March 2021 – 20. March 2022 1401,21. March 2022 – 20. March 2023 1402,21. March 2023 – 19. March 2024 1403*,20. March 2024 – 20. March 2025 1404,21. March 2025 – 20. March 2026 1405,21. March 2026 – 20. March 2027 1406,21. March 2027 – 19. March 2028 1407,20. March 2028 – 19. March 2029 1408*,20. March 2029 – 20. March 2030 1409,21. March 2030 – 20. March 2031 1410,21. March 2031 – 19. March 2032 1411,20. March 2032 – 19. March 2033 1412*,20. March 2033 – 20. March 2034 1413,21. March 2034 – 20. March 2035 1414,21. March 2035 – 19. March 2036 1415,20. March 2036 – 19. March 2037 1416*,20. March 2037 – 20. March 2038 1417,21. March 2038 – 20. March 2039 1418,21. March 2039 – 19. March 2040 1419,20. March 2040 – 19. March 2041 ; proc format library=work cntlin=ctrl; run;     Here is a sample of my data:   data WORK.SAMPLEDATA_1; infile datalines dsd truncover; input TRD_EVENT_TM:$24. TRD_STCK_CD:$15. TRD_PR:32. TRD_TUROVR:13. TRD_EVENT_DT:DATE9.; format TRD_TUROVR 13. TRD_EVENT_DT DATE9.; label TRD_EVENT_TM="TRD_EVENT_TM" TRD_STCK_CD="TRD_STCK_CD" TRD_PR="TRD_PR" TRD_TUROVR="TRD_TUROVR"; datalines4; 12:19:35,IKCQ1,1,100,24MAR2008 12:28:01,ALBZ1,1537,10000,26MAR2008 13:13:44,ALBZ1,1567,10,12MAY2009 12:20:38,AZAB1,683,10000,14JUL2011 13:13:44,AZAB1,695,10,11OCT2013 09:14:57,BALI1,850,9260,23MAR2008 09:15:06,BALI1,850,2000,25APR2008 09:15:14,BALI1,850,10000,14JUN2009 09:15:24,BALI1,850,6000,18JUL2010 09:29:27,BALI1,850,10000,11SEP2011 12:28:00,BALI1,850,10000,20OCT2012 12:28:07,BALI1,850,10000,24NOV2012 13:13:44,BALI1,865,10,26NOV2012 09:38:04,BANK1,1164,10729,13AUG2008 11:24:44,BANK1,1148,2000,15JAN2009 11:24:46,BANK1,1147,1575,19MAR2009 12:10:34,BANK1,1147,5000,17MAY2010 12:10:34,BANK1,1147,3425,22AUG2012 12:14:55,BANK1,1141,41575,24AUG2013 12:14:55,BANK1,1141,8425,24OCT2013 ;;;;     Now, I need a program to reverse this procedure and convert Gregorian to Solar Hijri calendar. Would anybody please tell me how can I do that? Thanks in advance. ... View more

Hello everybody How can I change my output (like axis labels in a chart) to Persian in SAS 9.4. Here are some features of my softwares:     NOTE: SAS (r) Proprietary Software 9.4 (TS1M3) NOTE: This session is executing on the X64_8PRO platform. NOTE: Additional host information: X64_8PRO WIN 6.2.9200 Workstation Thanks in advance.   ... View more

Hello everybody; I want to run panel regression with fix effect. So, I run the program below, but it doesn't work.   proc sort data=Sampledata_adjvol out=Sampledata_adjvol2; by TRD_STCK_CD TRD_EVENT_ROUFOR; run; proc panel data = Sampledata_adjvol2; model adjusted_volume_5 = TRD_EVENT_ROUFOR / fixone; id TRD_STCK_CD TRD_EVENT_ROUFOR; run; The error is: ERROR: The data set WORK.SAMPLEDATA_ADJVOL2 is not sorted in ascending sequence with respect to the time series ID. The current time period has TRD_EVENT_ROUFOR=9:30:00 and the previous time period has TRD_EVENT_ROUFOR=9:30:00 in cross section TRD_STCK_CD=ABAD1. Here is a sample of my data: data WORK.SAMPLEDATA_ADJVOL; infile datalines dsd truncover; input TRD_STCK_CD:$15. TRD_EVENT_DT:DATE9. TRD_EVENT_ROUFOR:TIME8. adjusted_volume_5:32.; format TRD_EVENT_DT DATE9. TRD_EVENT_ROUFOR TIME8.; datalines4; ABAD1,20MAY2008,9:30:00, ABAD1,20MAY2008,9:30:00, ABAD1,20MAY2008,9:30:00,0.1236593933 ABAD1,21MAY2008,9:30:00,0.5277625684 ABAD1,09JUL2008,9:30:00,0.0061432698 ABAD1,21JUL2008,10:30:00,2.4368321201 ABAD1,15OCT2008,10:30:00, ABAD1,15OCT2008,10:30:00, ABAD1,15OCT2008,11:00:00,0.1097571838 ABAD1,29APR2009,11:00:00,0.0274242661 SDFA1,20MAY2008,9:30:00, SDFA1,20MAY2008,9:30:00, SDFA1,20MAY2008,9:30:00,0.0236593933 SDFA1,21MAY2008,9:30:00,0.3277625684 SDFA1,09JUL2008,9:30:00,0.0061432698 SDFA1,21JUL2008,10:30:00,1.4368321201 SDFA1,15OCT2008,10:30:00, SDFA1,15OCT2008,11:00:00,0.2097571838 SDFA1,29APR2009,11:00:00,0.0174242661 VAED2,20MAY2008,9:30:00, VAED2,20MAY2008,9:30:00,0.0236593933 VAED2,21MAY2008,9:30:00,0.3277625684 VAED2,15OCT2008,11:00:00,0.2097571838 VAED2,29APR2009,11:00:00,0.0174242661 ;;;; How can I fix that? Thanks in advance. ... View more

Hello everybody; Please, consider the following sample: name date value a 2001.01.01 2 a 2001.01.02 3 a 2001.02.01 1 a 2001.03.05 4 b 2001.01.04 1 b 2001.01.15 4 b 2001.01.21 2 b 2001.01.22 3 b 2001.03.04 2 b 2001.03.07 5 b 2001.04.01 4 c 2001.02.05 2 c 2001.02.10 1 c 2001.02.11 2 c 2001.02.17 2 c 2001.03.10 1 c 2001.04.03 2 c 2001.05.09 3   Now, I want to remove observations of first month for each name variable. So, the final table is: name date value a 2001.02.01 1 a 2001.03.05 4 b 2001.03.04 2 b 2001.03.07 5 b 2001.04.01 4 c 2001.03.10 1 c 2001.04.03 2 c 2001.05.09 3   How can I do this?   Thanks in advance. ... View more