If "total" is supposed to be the value for the missing university type then place a value or at least say so.   One way: proc format; value $misstype (default=15) ' ' = 'Total'; run; proc sgplot data=students; series x=name y=col1/ group= type_college datalabel; format type_college $misstype. ; run; You will find in the long run that you will much better off using actual date values instead of things that hold dates such like your delai_dec20 because there are going to be times that you need to order the values and these will not sort correctly at all.   Graphing anything with a missing value is pretty much a problem to begin with. Much better off to supply an actual value so you know where it belongs on the graph.   Details about KEYLEND and style options to control appearance are left to you.   @Child79 wrote: Hello, Here is my dataset. I have two categorical variables (type_college and name) and a numeric variable (COL1). I don't know how to plot on the same graph the evolution curves of COL1 according to name for each type_college.     data students; infile datalines dlm=',' dsd; informat type_college $15. name $15. ; input type_college name $ COL1 ; datalines; College private,delai_dec20,1.5 College private,delai_juin21,3.6 College private,delai_dec21,4.4 College private,delai_sep22,47.6 College public,delai_dec20,5.3 College public,delai_juin21,6 College public,delai_dec21,14.4 College public,delai_sep22,14.4 University,delai_dec20,11.1 University,delai_juin21,14.3 University,delai_dec21,14 University,delai_sep22,17.1 ,delai_dec20,5.6 ,delai_juin21,7.1 ,delai_dec21,12 ,delai_sep22,18.1 ; here is exactly what I want for result.   Thanks.   ... View more

Sorry for errors. I wanted to use a small dummy dataset to represent the database I'm working with. I did not expect a value of "University private". It should just be "University". Thanks for correcting me. This is the good dataset. data students; infile datalines dlm=',' dsd; informat type_college $15. name $15. ; input type_college name $ COL1 ; datalines; College private,delai_dec20,1.5 College private,delai_juin21,3.6 College private,delai_dec21,4.4 College private,delai_sep22,47.6 College public,delai_dec20,5.3 College public,delai_juin21,6 College public,delai_dec21,14.4 College public,delai_sep22,14.4 University,delai_dec20,11.1 University,delai_juin21,14.3 University,delai_dec21,14 University,delai_sep22,17.1 ,delai_dec20,5.6 ,delai_juin21,7.1 ,delai_dec21,12 ,delai_sep22,18.1 ; Please can you explain me how to draw a curve of evolution of col1 according to the name for each type_college. On the abscissa axis, I have the name appeared in this order ( delai_dec20 , delai_juin21,delai_dec21,delai_sep22). Here is a picture of I want. Thanks in advance.   ... View more

Thanks for solution. It works correctly. ... View more

Thank you for your reply. I have summarized the problem. Otherwise I work with a big data where I will have three variables of respective alphanumeric, numeric and binary types. And I want to write a program that will output me that every time my data changes a table in the same format as in the word document. ... View more