Proc Sort identifies one of the duplicate records not both.   If you want to identify both using PROC SORT use the NOUNIQUEKEY option instead.   proc sort data=have nouniquekey out=want; by id subject; run; proc print data=want; run; ... View more

Marginally faster to eliminate the assignment statement ... other than that you're just missing a letter:   retain Date_recored "01Jan2015"d; format date_recored date9.; ... View more

As has been mentioned above structurally you can only have a column which is of character or numeric.  You can however do this in one step: data tab1;   input code; datalines; 1 2 3 4 5 ; run; data tab2;   input code $ name $; datalines; 1 John 5 Clara B Mike 4 Dave A Laura ; run; proc sql;   create table WANT as   select  put(CODE,1.) as CODE,           "" as NAME   from    TAB1   union all   select  *   from    TAB2; quit; ... View more

Hello - You may be able to take advantage of the MDY function (see: https://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000199044.htm). Basically you will need to read you current string (start_date), decompose it into month, day, year information - and use MDY to create the SAS date value (and apply a format later on so you can see the date in your preferred format). If month or day are missing then you can simply replace the values with 1 to create first day or month dates. For unformatted values (for example 40073)  RW9's tip can be applied I think. Hope I'm making sense. Thanks, Udo ... View more

You can try and subset the data set with a FIND() function and use the modifier that ignores case. ... View more

I doubt its changed much: 100% stacked bar chart in SAS’s SGPLOT | Heuristic Andrew http://blogs.sas.com/content/iml/2014/04/08/construct-a-stacked-bar-chart-in-sas-where-each-bar-equals-100.html EDIT: In the MORE LIKE THIS section of your question (right hand side) There's code specific to SAS 9.4 that uses G100 which is specific to SAS 9.4 and appears more efficient. ... View more

Stacked 100% tends to imply that you have a subgroup variable that would be indicated in the chart. What variable would that be? Sell doesn't make much sense in this case. I would look here: Support.sas.com and here: http://robslink.com/SAS/ to find something that looks like the result I wanted and use that as a model. ... View more