Hi!   I am trying to get a bar chart that shows me the number of gold silver and bronze medals by three countries.   My dataset currently looks like this:   Country_Name Medal Count China Gold 38 China Silver 28 China Bronze 22 GB Gold 29 GB Silver 17 GB Bronze 19 US Gold 46 US Silver 28 US Bronze 29   My code is:   proc sgpanel data= medal; panelby Medal / layout=columnlattice onepanel sort = (descformat) colheaderpos=bottom rows=1 novarname noborder; vbar Country_Name / group=Country_Name response=count stat=sum group=Country_Name nostatlabel; colaxis display= none; rowaxis grid; run;   This code works and I have attached the output to this message. However, i need my chart to show Gold, Silver, then Bronze. Right now, it shows Silver, Gold, Bronze. Any help on this would be appreciated!   Also is there a way to do this using proc gchart? My code for it doesn't seem to be working:   PROC GCHART DATA=medal; VBAR Country_Name/GROUP=medal subgroup = Country_Name; *MAXIS=AXIS1 AXIS=AXIS2; RUN; QUIT;   Thank you!     ... View more

Hi, my data currently looks like this:   Country----Gold-----Silver------Bronze US---------10---------12--------------15 China-------15--------10-------------4 GB----------7---------4-------------12     I want it to look like this:   Country------Medal-------Count US----------Gold------------X US---------Silver------------Y US----------Bronze---------Z China China China     An so on and so forth. the reason for this is that I need to make 1 bar chart for the 3 different countries with each of the 3 medal counts.   I tried using proc transpose but it seems I am doing something wrong. here is my code:   PROC TRANSPOSE DATA=olympics OUT=medal; ID Country_Name; var gold silver bronze; RUN;   Any help would be appreciated ... View more

I am trying to do something along the lines of if Varibles A, B, C, or D contain values less then 200 then Y (new variable) = 1, if none of them contain values or if all their values are above 200 then Y = 0.  What I have right now is :   Data dtanl.hivcancerdta; set dtanl.hivcancerdta; IF cd4_cnt1 < . THEN lowcd4 = 0; IF cd4_cnt2 < . THEN lowcd4 = 0; IF cd4 cnt3 < . THEN lowcd4 = 0; IF cd4_cnt4 < . THEN lowcd4 = 0; IF cd4_cnt1 < 200 THEN lowcd4 = 1; IF cd4_cnt2 < 200 THEN lowcd4 = 1; IF cd4 cnt3 < 200 THEN lowcd4 = 1; IF cd4_cnt4 < 200 THEN lowcd4 = 1; ELSE lowcd4 = 0; RUN;   Its ugly and isn't working. Is there a better way to do this. I tried looking online and some options use do statements but I dont have much experience with it. Any help would be appreciated. ... View more

Hi,   Was wondering if there was a less tedious way to write my below code: Essentially I am trying to say that if the anti retroviral therapy they have is type 3, 4, 5, etc the they are using a combination ART (ie. 2). What I have below works, but is there an easier way to write this out?   DATA dtanl.hivcancerdta; set dtanl.hivcancerdta; IF arv1_d1 = . THEN arvtype = .; ELSE IF arv1_d1 = 3 THEN arvtype = 2; ELSE IF arv1_d1 = 4 THEN arvtype = 2; ELSE IF arv1_d1 = 5 THEN arvtype = 2; ELSE IF arv1_d1 = 11 THEN arvtype = 2; ELSE IF arv1_d1 = 14 THEN arvtype = 2; ELSE IF arv1_d1 = 42 THEN arvtype = 2; ELSE IF arv1_d1 = 44 THEN arvtype = 2; ELSE IF arv1_d1 = 45 THEN arvtype = 2; RUN;   Thank you! ... View more

Hi, I am trying to create a 2x2 table and gather chisq. However, my treatment variable is by default showing up as 2 then 1 but i wanted it in ascending (1 then 2). My response variable is outputting correctly (1 then 0).   Here is my code:   PROC SORT data = dtanl.hivcancerdta; by descending cancer; RUN;   PROC FREQ data = dtanl.hivcancerdta order = data; TABLE alcoh*cancer / chisq riskdiff or; WHERE alcoh ^= 9; RUN;   My output is:   Any information on what i am doing wrong would be appreciated!   Thanks! ... View more