Hi SAS experts,   I am trying to build a series plot in sgplot using X axis as year and week. when I build the graph in excel it returns a X axis label like this:  But in SAS it is not possible to read the X Axis  The data is organized like this:  Data Cars; input year $ week $ Small_Size $ Mid_Size $ Large_Size $ Van $ ; cards; 2018 1 10 15 23 16 2018 2 12 11 28 18 2018 3 15 19 17 11 ; run; Data Cars; set cars; YearWeek=catx(' ',Year,Week); run; Data Cars; set cars; format YearWeek $7.; run;       And the SAS codes for the graph that I am using is this: ods graphics on /       width=10 in       outputfmt=gif       imagemap=on       imagename="Cars"       border=off;   PROC SGPLOT DATA = Cars;  SERIES X = YearWeek Y = Small_Size;  SERIES X = YearWeek Y = Mid_Size;  SERIES X = YearWeek Y = Large_Size;  SERIES X = YearWeek Y = Van;  XAXIS TYPE = DISCRETE GRID;  YAXIS LABEL = 'Number of cars' GRID VALUES = (5 TO 40 BY 1);  TITLE 'Sales by type';  run;     Any suggestion how I could control the X axis to look some how like the one I am getting in excel?   Thank very much! ... View more

Hello SAS Experts,   I want to create a new ID sequence to help to identify a current user for when more than one information is introduced for the same "ID_Number". Bellow are 3 tables and the different information can be found in the column "RealState". The DataSample1 is the original. In that, the "ID_Number" 5678 has two different entries for "RealState". I would like to manipulate this and have a new information composed by letter helping to differentiate. The DataSample2 and DataSample3 are what I am looking for. Can be one or other. In DataSample2 a letter is added to the "ID_NUmber".  In DataSample3 a new column call "sequence" is created with a letter. In both situation when more than one observation in "RealState"  is entered for the same "ID_Number" different letters was applied.   DATA DataSample1;   InPUT ID_Number $ State $ Age RealState $; DATALINES; 4456 NC 55 House 5678 SC 43 House 5678 SC 43 Building 4321 CA 67 Farm 9876 FL 43 Gym ;   DATA DataSample2;   InPUT ID_Number $ State $ Age RealState $; DATALINES; 4456A NC 55 House 5678A SC 43 House 5678B SC 43 Building 4321A CA 67 Farm 9876A FL 43 Gym ; DATA DataSample3;   InPUT ID_Number $ State $ Age RealState $ Sequence $; DATALINES; 4456 NC 55 House A 5678 SC 43 House A 5678 SC 43 Building B 4321 CA 67 Farm A 9876 FL 43 Gym A ; ... View more

Hi experts!!   For the data below I want to keep only the pieces of information where the Size(column) is equal to Compact, Medium_SUV, and Medium_size. Any thoughts how I can do that?    data Cars;   input Type $ Size $  Colour $;   datalines; Car Medium_size Yellow Car Small_size Blue Car Small_SUV White Car Compact White Car Large_SUV Blue Car Medium_SUV Gray   run; ... View more

From the data bellow I want to count the number of brown trucks sold per week. The week should start on Monday and finish on Sunday. How can I do this?   data CarsSold; input Observation Data model$ color$; cards; 1 1152017 truck  brown 2 1162017 truck  gray 3 1172017 car white 4 1182017 car yellow 5 1192017 truck  brown 6 11102017 truck  brown 7 11112017 car black 8 11122017 car black 9 11132017 truck  gray 10 11142017 truck  brown 11 11152017 car white 12 11162017 car white 13 11172017 truck  gray 14 11182017 truck  gray 15 11192017 car yellow run; ... View more