I am trying to display the labels on my bar graph with n and percent combined. Using SAS support community I was able to locate this solution: https://communities.sas.com/t5/SAS-Programming/Making-a-grouped-bar-chart-with-both-count-and-percent-in/m-p/521667    The solution works great the problem is when the percent are transposed the values are not coming out as they should. I also have several observation  and some percent's get numeric values with many decimal places (1.6198704104) when I would like 1.6.    My data is as follows: data bar; infile datalines dlm=','; input Country $ Q1_2022_n Q1_2022_pct Q2_2023_n Q2_2023_pct num_change pct_change; datalines; Australia,30, 1.6, 33, 1.8, 3, 0.2 Belgium, 8, 0.4, 11, 0.6, 3, 0.2 Canada, 160, 8.7, 157, 8.7, -3, 0.0 ; run;   So for the first line when the variables are combined I would like 30(1.6), 33(1.8) and 3(0.2)  instead  I get 30(10.8), 33(11.8) and 1.8(11.6). My code so far is below.   data bar; infile datalines dlm=','; length country $10.; input Country $ Q1_2022_n Q1_2022_pct Q2_2023_n Q2_2023_pct num_change pct_change; datalines; Australia,30, 1.6, 33, 1.8, 3, 0.2 Belgium, 8, 0.4, 11, 0.6, 3, 0.2 Canada, 160, 8.7, 157, 8.7, -3, 0.0 Netherlands, 79, 4.3, 79, 4.4, 0, 0.1 ; run; proc sort data = bar; by country; run; proc transpose data=bar out=bar_long(rename=(_NAME_=Group COL1=value)); by country; run; proc sql; create table bar_cat as select *, cats(value, "(", put(value/(sum(value)), percent10.1), ")") as datalabel from bar_long group by Group; quit; Any assistance would be great. Thanks in advance.  ... View more

Has anybody ever worked with .outbound files ? If so, can files with this file type be imported into sas? ... View more

I have reviewed all of the topics in this community and on the web and I am still unable to add superscript to my footnotes or titles. Any help woild be greatly appreciated. Below please find my test code:    data have; infile datalines; input year 4. pats_stage1_3 pats_total 3. ; datalines; 1999 150 300 2000 112 369 2001 236 426 2002 121 400 2003 330 520 2004 280 500 ; run; ods graphics on; ods escapechar= '^'; ods excel file='/home/luvscandy270.xlsx' options(sheet_name="test" embedded_titles="yes" embedded_footnotes="yes" TITLE_FOOTNOTE_NOBREAK="yes"); proc sgplot data=have noborder; title 'TEST ^{super (b)}'; series x=year y=pats_stage1_3 / legendlabel="Male" lineattrs=(color=blue thickness=3) markers markerattrs = (symbol = circlefilled color = blue size=10); series x=year y=pats_total / legendlabel="Female" lineattrs=(color=green thickness=3) markers markerattrs = (symbol = circlefilled color = green size=10); xaxis label='Test' discreteorder=data fitpolicy=rotatethin valuesrotate=vertical ; yaxis label = 'Test' values=(0 to 600 by 100) valueattrs=(family=arial size=10pt ) minor grid ; reg x=year y=pats_stage1_3 / nomarkers lineattrs=(color=blue pattern=dash) legendlabel='Regr. stage 1-3'; reg x=year y=pats_total / nomarkers lineattrs=(color=green pattern=dash) legendlabel='Regr. total'; keylegend / location=inside position=top title="" valueattrs=(size=7pt family=arial) outerpad=(top=0.2cm) border; footnote1 h=5pt justify=l 'Test ^{super (b)}'; footnote2 h=5pt justify=l 'Test 2'; run; ods excel close;    ... View more

Hello,  I need some help and I'm not sure where to begin. I have two datasets: Dataset One last_name  first name  DOB address  City State  Zip  Billy  Bob  8/15/1979 702 Park Avenue St.  Wilmington  NC  57896 Will Jr. King  5/11/1993 55556 Martin Lane  Charlotte  NC  12589   And dataset two last_name  first name  DOB address  City State  Zip  Billy  Bob  8/15/1979 702 Park Avenue St.  Wilmington  NC  57896 Will  King  5/11/1993 55556 Martin Ln.  Charlotte  NC  12589   I would like to match on dob, and the first 9 characters of the address since the Street could be spelled Street or St. etc.  What I am trying to achieve is to find duplicates in the two datasets where the name maybe different by matching on dob and street address. For instance, Will, King is in the both datasets but dataset one has him listed as Will Jr., King. Then I would like to output all instances where  the DOB and address match but there is a possibility that the name maybe different.  ... View more