Hi, I'm having trouble in getting the exact series plots that I want.  Particularly, I want add a refline at March 2020, but the plot only does not show Mar in 2020.  Here is the dataset that I made up and what I did to make the plots data input1; input monthlyyear :date9. amount type; format monthlyyear date9.; datalines; 01JAN2016 4 1 01FEB2016 6 3 01MAR2016 5 2 01APR2016 39 2 01MAY2016 49 1 01JUN2016 34 3 01JUL2016 49 2 01AUG2016 30 1 01SEP2016 30 2 01OCT2016 2 3 01NOV2016 34 3 01DEC2016 30 3 01JAN2017 56 2 01FEB2017 45 1 01MAR2017 45 1 01APR2017 34 2 01MAY2017 45 3 01JUN2017 45 2 01JUL2017 23 2 01AUG2017 26 1 01SEP2017 45 2 01OCT2017 35 1 01NOV2017 67 2 01DEC2017 20 3 01JAN2018 34 3 01FEB2018 56 2 01MAR2018 67 3 01APR2018 20 2 01MAY2018 29 3 01JUN2018 24 2 01JUL2018 49 2 01AUG2018 32 1 01SEP2018 27 1 01OCT2018 24 2 01NOV2018 28 3 01DEC2018 35 2 01JAN2019 45 3 01FEB2019 74 2 01MAR2019 73 1 01APR2019 83 1 01MAY2019 82 3 01JUN2019 85 2 01JUL2019 43 3 01AUG2019 82 2 01SEP2019 62 1 01OCT2019 74 3 01NOV2019 35 3 01DEC2019 65 3 01JAN2020 45 2 01FEB2020 4 2 01MAR2020 94 2 01APR2020 82 1 01MAY2020 84 2 01JUN2020 71 3 01JUL2020 32 3 01AUG2020 24 2 01SEP2020 74 2 01OCT2020 15 3 01NOV2020 34 2 01DEC2020 65 2 ; run; proc print data=input1; run; proc sgplot data=input1 ; title "graph for input1"; series x=monthlyyear y=amount /group=type lineattrs=(thickness=1); xaxis grid interval=month label="Month and Year"; yaxis grid valueshint label="Expenditure"; format MonthlyYear yymon7.; run; Here is the plots that I get. I want to add refline at Apr 2016, Jun 2017, Oct 2018, Aug 2019, and Mar 2020. Since Aug and Mar are not shown in the axis, I don't know how to add refline. I'm also wonder if I'm able to add short description on those reflines. In addition, I also want to make the three lines as different dashed so that when I print it out black and white, I'm able to distinguish which line is which.  Any suggestions is appreciated!!    ... View more

Hi, I have two datasets right now and I want to merge them. The thing is they have in different size and there are missing values when merging them. Any suggestions are appreciated. data return; input year month return; datalines; 2011 1 34 2011 2 33 2011 3 88 2011 4 67 2011 5 39 2011 6 45 2011 7 20 2011 8 29 2011 9 39 2011 10 23 2011 11 28 2011 12 38 ; run; data GDP; input year month gdp; datalines; 2011 1 345 2011 4 289 2011 7 378 2011 10 589 ; run; *this is what I did; data combine; merge return(in=ina) gdp(in=inb); by year month; if in a; output; run; data combine; set combine; if gdp=. then gdp=lag(gdp); run; this is what the output is: what I want for the output is: data want; input year month return gdp; datalines; 2011 1 34 345 2011 2 33 345 2011 3 88 345 2011 4 67 289 2011 5 39 289 2011 6 45 289 2011 7 20 378 2011 8 29 378 2011 9 39 378 2011 10 23 589 2011 11 28 589 2011 12 38 589 ; run; Basically, I want the gdp not missing and if it is missing, then gdp that month should equal to the gdp that quarter the month belongs to.  Thank you! ... View more

hi, I have dataset and I'm trying to get a plot from it. The dataset is something like below(not complete). Basically, the dataset I have contains 5 years of data and for each year, there are 12 months, and for each month, there are 3 types and each type has a spending. So one year has 36 rows. What I want for the plot is that the x-axis is the month of each year, the y-axis is the spending, but since there are three types, I also want separate lines for each type.   I'm trying to use proc sgplot, but I don't know how to make all five years spending show in one plot. I insert the plot I got from the code below. I know it is not correct since I intentionally make each type in both year gradually increase as month increases. In the final result, I only want the each year to show up instead of month like the photo I inserted. Any suggestions would be very helpful. Thank you!   data have; input year month type spending; datalines; 2015 1 1 22 2015 1 2 33 2015 1 3 34 2015 2 1 23 2015 2 2 34 2015 2 3 35 2015 3 1 24 2015 3 2 35 2015 3 3 36 2015 4 1 25 2015 4 2 36 2015 4 3 37 2016 1 1 18 2016 1 2 30 2016 1 3 40 2016 2 1 19 2016 2 2 31 2016 2 3 41 2016 3 1 20 2016 3 2 32 2016 3 3 42 2016 4 1 21 2016 4 2 33 2016 4 3 43 ; run; proc sgplot data=have; series x=month y=spending / group=type; run;     ... View more

Hi, I want to extract some rows in one dataset(inputdata1) based on information from another datasets(inputdata2).  inputdata1 has variables id and month1, and inputdata2 has id, month2, and cost. What I want to do is when it is the same id in inputdata1 and inputdata2, if month2 equals month1, then output. However, the total number of month for the same id is different in inputdata1 and inputdata2. And the size of these two datasets are different. I'm not sure if SAS is able to do what I want. I insert the codes below. The data want in the bottom is what I want when I have inputdata1 and inputdata2. The rest codes are my attempt, but it didn't output what I want. Any suggestions would be very appreciated!   data inputdata1; input id $ month1; datalines; 637 1 637 2 637 3 637 4 637 5 675 1 675 2 675 3 675 4 675 5 675 6 675 7 675 8 675 9 891 1 891 2 891 3 ; run; proc print data= inputdata1; run; data inputdata2; input id $ month2 sum; datalines; 637 3 28.9 637 7 34.7 675 1 34.6 675 4 35.7 891 9 33.4 ; run; proc print data= inputdata2; run; proc sort data=inputdata1 out=inputdata1; by id; run; proc sort data=inputdata2 out=inputdata2; by id; run; data combine; merge inputdata1 inputdata2; by id; if month1=month2; run; proc print data=combine; run; data want; input id $ month2 cost; datalines; 637 3 28.9 675 1 34.6 675 4 35.7 ;     ... View more

  Hi, I'm new to SAS and I'm trying to modify a dataset. basically, I want to add certain variables up if they have the same ID and the same mon and call it sum. A is the input dataset and B is the output dataset that I want. I'm not sure if SAS is able to do this.  Any tips would be appreciated! Thank you! data A; input id $ mon $ cost $; datalines; 111 01 11.34 112 02 3.56 112 02 4.98 112 03 5.88 114 04 7.89 ; run; data B; input id $ mon $ sum$; datalines; 111 01 11.34 112 02 8.54 112 03 5.88 114 04 7.89 ; run;   ... View more

hi, I now have two datasets(A and B), and I want a new datasets that combine these two based on what A has. C is the output dataset that I want. In C, I only want data(fam-id, pers-id, date) that have the same fam-id and pers-id in both A and B. A and B are in different size and for the same pair of fam-id and pers-id, A only has one row, but B may have multiple rows and I want multiple rows to show up in C. If a pair of fam-id and pers-id appears only in B but not in A, then it should not appear in C. I tried to use merge in the data step, but it kept giving me output that apart from what I want, it has rows that appear only in B(two rows with fam-id=115 in the following example). Any suggestions would be appreciated! Thank you!  A :                                  B:                                                         C: fam-id  pers-id                  fam-id   pers-id         date                     fam-id   pers-id   date   111     1112                      111       1112       01/02/2020                111       1112       01/02/2020    112      1124                     111       1112       03/25/2020                111       1112       03/25/2020   113      1132                     111       1112       07/08/2020                111       1112       07/08/2020   114      1145                     112       1124       05/30/2020                112       1124       05/30/2020                                            112       1124       03/26/2020                112       1124       03/26/2020                                            113       1132       02/24/2020                113       1132       02/24/2020                                            115       1156       04/07/2020                                            115       1156       05/06/2020 ... View more