Is there a way to format currency in SAS 9.3 with the dollar sign and no decimals in a proc tabulate statement?  Thanks for your help! ... View more

  I am getting the error below for the attached data input statement and I am not sure what the problem is or how to fix it.  I am assuming it might have something to do with the ' .' for missing data?  Thanks for your help! 1811 Data MTcontywage ; 1812 input name $15. wage state county; 1813 format county z3. wage dollar10.2; 1814 Datalines; NOTE: LOST CARD. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8---- 1873 ; name= wage=. state=. county=. _ERROR_=1 _N_=58 NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.MTCONTYWAGE has 57 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 1873 ;   ... View more

  I am trying to figure out the best way to annotate or move my labels so they do not run into each other or county lines.  The label variable I am using is xtext which I created in MTMAP. I have tried if and then statements to move x or y but I was unsuccessful. It would also be nice to get some advice on how to splitting some of the longer labels. Thanks! data MTMap; length xtext $20.; merge MTcontycnt  MTCounties; if county=113 then delete; by county; xtext = cats(name)||' ('||cats(cnt)||')'; end; run; %annomac; %maplabel(MTCounties, MTMap, MTAnnotate, xtext, county, font='Arial', color=black, size=1.3)   legend1 noframe label=(h=2 f=arial '  '); title h=2 f=arial '  '; proc gmap data=MTMap map=MTMap density=2; id county; choro cnt / anno=mtannotate legend=legend1 Xsize=8in ysize=5in stretch; run; quit; ... View more

How can I format my percent in this proc freq?  I have tried every percent variable name I can think of  and non of them work. If "Percent" is printed in the table being generated, why is it telling me there is no percent variable?      PROC FREQ DATA=data ; TABLE Program*Award / nocol norow; label Program='Program Type'; label Award='Amount Awarded'; format award dollar10. Percent f5.1 ; RUN;     ... View more

Hello,    I was curious to see if anyone had advice on exporting a gmap.  I seem to have very inconsistent results regardless of which device I use.  I prefer EMF but am open to suggestions.  Plus EMF doesn't really seem to be compatible with some of my options.  I need a way to consistently produce a clear graph, the clearer the better!  Attached is my code.    Thank You!!       ... View more