It was coding that I inherited. I was able to figure it out and get the table reworked. ... View more

I was able to figure it out and rework the table. Thank you. ... View more

The student id appears once in each file. The hard part is that I don't want to take the student out of the retention until after they have graduated. This is a report that looks at retention in a major over a 5 year period. ... View more

The number is a dollar amount so if I round it I will lose the cents. How do I deal with that? ... View more

I like the stars with the zip codes, but how can I add my points with the stars. I have the following code so how can I incorporate the two?   options nomlogic nomprint symbolgen nodate nonumber cleanup; libname ora oracle dbprompt=yes path="irdb"; libname enroll "P:\Research\RESEARCH2\Internal\Ad_Hoc\data requests\Bus_Project"; libname pathout "C:\Geocode\Data"; proc import out=student_list datafile="P:\Research\RESEARCH2\Internal\Ad_Hoc\data requests\Bus_Project\bus_students_2015_2.xlsx" dbms=excel replace; sheet="bus_students_2015"; run; proc sort data=student_list; by pidm; run; data student_list (keep=pidm address city state zip2); set student_list; by pidm; if street_address_1 ~=' '; address = street_address_1; zip2=input(substr(zip,1,5),5.0); if 21000<= zip2 <= 21099; run; data student_list; set student_list; by pidm; zip=zip2; run; proc geocode method=street data=student_list out=work.geocoded lookupstreet=pathout.usm attributevar=(TRACT); run; data anno; set work.geocoded(rename=state=stname); retain xsys ysys '2' when 'a'; function='label'; style='special'; text='J'; color='blue'; size=2; /* convert the X and Y values from degrees to radians to match the map data set */ x=atan(1)/45 * x; y=atan(1)/45 * y; /* adjust the hemisphere for the longitude to match the map data set */ x=-x; run; data harford; set maps.county; if state=24 and county=25; run; /* combine annotate data set with unprojected map data */ data all; set harford anno; run;   /* project the data */ proc gproject data=all out=allp dupok; id state county; run;   /* separate the annotate and map data sets */ data map anno; set allp; if when='a' then output anno; else output map; run;   /* set the map patterns to be empty */ pattern1 v=me c=black r=99; Goptions reset=all border; ods listing close; ods html body="bus_map.html"; title1 "Map of Bus Riders within Harford County"; footnote1 j=r "2015 Bus Riders"; proc gmap data=map map=map; id state county; choro state / anno=anno nolegend; run; quit; ods html close; ods listing; ... View more

I like the stars included with the map, but how do I add my data points along with the zip code stars to my map.     ... View more