Dear Community, I am working on a panel graph using proc sgpanel. My x-axis variables is "Years". The series line I use is currently a solid line drawn using the code: (lineattrs=(pattern=solid thickness=2).   However, when there is a data gap where data for two or more years is missing, I would like to have a dashed line.  In other words, in each panel cell, I would like there to be a solid line but when there are missing data for more than two years, I would like the part of the line that goes from the last data point to the next data point to be dashed. I hope this is understandable, if not, I will try to explain further.      Is it possible to do this in a sgpanel graph? In this case, how can it be done?  Any advice would be helpful.   Best regards, Karoline ... View more

Hi SAS community,   I am wondering if someone could help me with the following issue. I have a dataset that looks something like this:   Year      Company        Substance              Value 2011      Max                A                             2.3 2012      Max               B                              4.3 2013      Max               C                              6.8 2014      Max               A                               7.4   How do I create, in a datastep, one new row with the year 2010 and Company Max but where substance and value is empty?    Thank you very much for any help!   Kind regards, Karoline   ... View more

Dear SAS Community, I am having an issue with SAS that I have not experienced before when multiplying two variables. When I conduct the following calculation:    data dataset_2; Ser_Occ=_FREQ_*Ntot; set dataset_1; run;   I get this result:  I do not understand why the values of the resulting new varibale "Ser_Occ" are shifted one row down. That is, the result of the calculation of row 1, is displayed in row 2, and so on. I would like to get the result of the calculation in the same row. I would be very grateful for some feedback from you on why SAS studio does this and how to get the values in the same row? Could it for example have to do with the settings or the underlying format of _FREQ_ which was computed using proc summary statement?    Best regards, Karoline ... View more