Hello everyone!   I'm having a dataset in SAS which looks similar to the below picture one and I am trying to create the same graph in SAS with proc sgplot and vbar, however, I struggle to be able to choose the two columns for the bars. With the response and group command I can only choose one of each...   I also tried it with two vbars in one proc sgplot and the response being for one active cases and for the other passive cases, however, that did not work properly.   Is there any way how I can achieve creating the below graph? Or do I have to change my dataset first, if yes, how? I'd prefer to stay with proc sgplot, if possible. Any help is greatly appreciated 🙂 ... View more

Hi! I am having this sample datasets which contains values and their units (K stands for ten thousands, M for millions). My goal is to have a new table (want) that adds the zeros, depending on K or M, to the value column variables and shows the value as proper number. I tried it with the below code but it did not work (did not get an error either but it didn't change anything). In the end, the table want should ideally look like this (tips on how to remove the redudandant unit columns are also appreciated): "value 10000 15000 19000000 4000000" data example; input value unit$; datalines; 10 K 15 K 19 M 4 M ; run; data want; set example; if unit ="K" then value=value+000; else value=value+000000; run; Any ideas on how I could achieve that? Thanks already in advance! 🙂 ... View more