One of my response values is 90 and other one is 0.02 , in order to show that, I would like to use different colors for groups based on the legend color   title " "; ods listing style=listing; ods graphics / width=5in height=2.81in; ods graphics / reset=ALL outputfmt=PNG imagename="ByDilution"; ods pdf file="&graph_loc.Target_Bargraph_Exp5.pdf"; proc sgplot data=main_subset PCTLEVEL=GRAPH; format replicate $method.; styleattrs datacolors=(Blue red) datacontrastcolors=(Blue red); vbar Sample_name / response = Mapped_percent group=replicate groupdisplay = cluster nooutline Clusterwidth=1 datalabel stat=mean dataskin=pressed; xaxistable Sample_name / colorgroup=replicate ; xaxis display=(nolabel noticks) discreteorder=data FITPOLICY=ROTATE; yaxis label="% Reads"; keylegend /title='' noborder autooutline; run; ods pdf close;   ... View more

title " "; ods listing style=listing; ods graphics / width=5in height=2.81in; ods graphics / reset=ALL outputfmt=PNG imagename="ByDilution"; proc sgplot data=main_subset PCTLEVEL=GRAPH; vbar Sample_name / response = Ref_recovery_ group=replicate gspace=3 groupdisplay = cluster nooutline stat=mean dataskin=pressed; xaxis display=(nolabel noticks) discreteorder=data FITPOLICY=STAGGER; yaxis label="% Targeted Coverage";   error..   keylegend /title='' noborder autooutline; run; ... View more

When I am writing data to Excel using ODS Excel and Proc print.. Some of the data is wrapped to new line and automatic quotes are added to the data that is causing issues in the down stream analysis.. For ex:  "Social Awareness Analysis Report" "Final Percent Coverage of Analysis structure"   How can I handle the below solution in SAS instead of each time opening the Excel and fixing thousands of records. Google shows this solution... To find and replace new lines in Excel, you need to 1 2 3 4 : Select all the cells where you want to find and replace new lines. Press Ctrl+H to open the Find and Replace dialog box. In the Find what field, enter Ctrl+J. This will represent a new line character. In the Replace with field, enter the value that you want to replace new lines with, such as a comma, a space, or nothing. Click Replace All to apply the changes.  Thank you ... View more

I have about 300 excel files on server and need to read only 30 files with specific word ( For ex: \\temp\reach\*conc_v.xlsx ) and append them to create one big dataset. When I see them on windows, I cannot see their file extension .xlsx.   Also, I have to read the file name as first or last field so that I can concat to extract one piece of information from each file to use as title for my graph. Any thought or leads with examples?   Thank you ... View more

My code.. ods listing style=listing; ods graphics / width=5in height=2.81in; ods graphics / reset=ALL outputfmt=PNG imagename="K_GAD-Metag"; /* Size each graph 4in x 4in */ /*goptions hsize=4in vsize=4in;*/ proc sgplot data=main_subset PCTLEVEL=GRAPH; where Treatment_group='K_GAD-Metag'; vbar Sample_virus_name / response = Mapped_percent group=replicate groupdisplay = cluster nooutline stat=mean dataskin=pressed; xaxis display=(nolabel noticks) discreteorder=data FITPOLICY=STAGGER; yaxis label="% Target Reads" ; keylegend /title='' noborder autooutline; run; Thank you ... View more