Hello,   I am trying to skip certain dates on the x-axis, see code below. proc sgplot data=finaldata; vbar date; xaxis label='Event date' values=('10Dec2018'd to '01Jun2019'd by week); yaxis label='Number of events' values=(0 to 6 by 2) offsetmin=0; run;   Date has values:    10Dec2018 02Feb2019 05Feb2019 09Feb2019 22Feb2019 01Mar2019 11Mar2019 22May2019 25May2019   I want to skip the months with no values but still space it out by specified ticks   thanks in advance ... View more

Hello, community:   My team has encountered an unusual behavior with the SAS server. Only a few users can seem to have the Variable name output from proc freq, not a crosstab.    proc freq data=sashelp.birthwgt; tables race; run;   Appreciate the help.   ... View more

Hello, I am trying to convert a SAS dataset with nucleotide sequence to a fasta format. See sample FASTA formated file here:https://github.com/veg/hivtrace/blob/master/test/rsrc/TEST.FASTA   What I have is a table with two columns: ID Seq   What I need is to create a new line for the corresponding Seq value as : >ID1 Seq1 >ID2 Seq2   Any advise is much appreciated.   ... View more

  I am running to a couple of issue - 1) whitespace in gmap output 2) legend not maintaining proportion. The data am working with can be found https://gis.cdc.gov/grasp/fluview/main.html (Download data) And here is my code:   data label; retain flag 0 xsys ysys '2' hsys '3' when 'a' style 'swissb'; set maps.uscenter( drop=long lat); if ocean='Y' then do; position='6'; output; function='move'; flag=1; end; else if flag=1 then do; function='draw'; size=.5; flag=0; end; output; run;   pattern1 value=solid color=cx00C200; pattern2 value=solid color=cx5BF700; pattern3 value=solid color=cx8CF700; pattern4 value=solid color=cxBAF700; pattern5 value=solid color=cxE0F500; pattern6 value=solid color=cxF7DF00; pattern7 value=solid color=cxFCB100; pattern8 value=solid color=cxFC8200; pattern9 value=solid color=cxFA4F00; FILENAME plots "H:\"; goptions reset=all DEVICE=png xpixels=412 ypixels=168 transparency GSFNAME=plots GSFMODE=REPLACE NOFILEONLY; ods _all_ close; ods listing; pattern1 value=solid color=cx00C200; pattern2 value=solid color=cx5BF700; pattern3 value=solid color=cx8CF700; pattern4 value=solid color=cxBAF700; pattern5 value=solid color=cxE0F500; pattern6 value=solid color=cxF7DF00; pattern7 value=solid color=cxFCB100; pattern8 value=solid color=cxFC8200; pattern9 value=solid color=cxFA4F00; footnote1 justify=right ' Source: CDC Interactive fluview';   ods html; proc gmap data=flu1 map=maps.US ; id STATE; choro alevel / legend=legend discrete coutline=black annotate=label name="flumap"; legend label=("ILI Activity Level" position= Top height=3pct) value=( j=right h=1.0) across=1 down=9 mode=share position=(right inside);/*Format the legend*/ run; quit; ods listing close;   I used the sashelp.zipcode to get the State two digit abbreviation.   Thanks ... View more

I am having difficulty saving a number format in a report. I have reviewed the comments on https://communities.sas.com/t5/Base-SAS-Programming/CALL-SYMPUT-vs-CALL-SYMPUTX/td-p/377866 but I can't get the comma8.2 format to work.    Objective- Keep the comma, as in - 10,000, when I call the macro for saved numeric value to add to a report.     data _null_; set data; call symputx("val",Total,comma8.2); run;   -tried it also with vvaluex(Total,comma8.2), and didn't work. Thanks ... View more

Hello Community,   I am stuck trying to pass a temp value in a do loop. Here is what I am trying to achieve:   AGENCY SCORE A 68 A 78 B 62 C 61   Here is my code: ODS HTML; %MACRO CAR(AGENCY=); ODS html file="\\cchd.org\odsdfs$\ODSShared\Surveillance Reports and QA\Surveillance QA\&AGENCY..html" style=Seaside; ODS title "Contact FR-QC" ; ods escapechar = "~"; OPTIONS NODATE NONUMBER; option orientation=landscape; proc report data=TEST nofs center; where AGENCY="&AGENCY"; columns AGENCY SCORE; run; ODS html CLOSE; %MEND CAR; %CAR (AGENCY=A); /*Report for Agency A*/   The Agency list is dynamic and I want to generate the report by agency by looping the observations listed in AGENCY... Any insight is appreciated.     ... View more