About MikeZdeb

MikeZdeb · ‎07-09-2012

hi ... %annomac just allows you to use the SAS-supplied macros, like %centroid once you know the centroids, it's easy (sort of) to add multiple items take a look at Faking ArcGIS maps in SAS ... http://www.nesug.org/Proceedings/nesug11/gr/gr08.pdf

MikeZdeb · ‎07-09-2012

Hi ... a follow up to Robert's posting ... the %CENTROID macro requires a data set that's sorted according to the ID variable(s). So, finding the center of each county would require ... proc sort data=maps.counties out=mymap; by state county; run;

MikeZdeb · ‎07-09-2012

hi ... the original posting showed single characters and that's when COUNTC works you already have some replies that work (like CATS and SUM in SQL), here's another that does work with COUNTC in a data step proc format; value nn 9 ='1' other='0'; value $n '9'='1' other='0'; run; filename x dummy; data want; set have; file x; put (_numeric_) (nn.) (_character_) ($n.) @; nines = countc(_file_,'1'); put; run;

MikeZdeb · ‎07-09-2012

hi ... PICTURE formats work with numeric variables there have been several nice solutions posted that work with character data, here's another possibility ... data want; length b $10; set have; b =catt(a,substr('xxxxxxxxxx',1,9-length(a))); run; similar to Haikuo 's solution, but you should use a length statement when using the CAT functions given that the default length of the result is 200 if you really wanted a one statement solution that gives you a variable with a length of 10, you could get rid of the LENGTH statement and use a PUT function with the CATT result ... data want; set have; b = put(catt(a,substr('xxxxxxxxxx',1,9-length(a))),$10.); run;

MikeZdeb · ‎07-08-2012

hi ... here's another KML idea (produced with attached) https://maps.google.com/maps?q=http://www.albany.edu/~msz03/lll.kml

MikeZdeb · ‎07-08-2012

hi ... that's a SAS course book and the data sets for such courses are normally limited to those who take the course (and pay) that's different than the SAS Press books and SAS documentation example code and data for those books are available online ... http://support.sas.com/documentation/onlinedoc/code.samples.html there are also a number of data sets at ... http://support.sas.com/learn/statlibrary/statlib_eg4.1/top_data.htm (though it appears to me that the LIST DATA SETS link on that page only works with Internet Explorer, not with either Chrome or Firefox)

MikeZdeb · ‎07-07-2012

hi ... I assume you mean the color of the symbols that mark the zip locations sure, since they are added with annotate you can choose colors you'd have to make some decisions as to what you do when both males and females are in the same zip (third color?) attached is a screen capture showing the result of modified SAS code that uses color for gender, symbol size for number of friends (1, 2, 3+) and adds the number of males and females to the title tags ... just substitute the attached SAS code in the section that does the MASS map (the white stars on the lightly shaded background are a bit hard to see, but you can l=play with colors)

MikeZdeb · ‎07-07-2012

hi ... the more the merrier ... proc format; picture a low-high='0000000000' (fill='X'); run; data want; set have; b = put(input(a,7.),a.); run;

MikeZdeb · ‎07-06-2012

hi ... data have; value='xxasdxfg';output; value='xxxxqwerxxt';output; run; data want; set have; new = substr(value,verify(value,'x')); run; data have; x = '123456789'; run; data want; set have; x2 = substr(x,length(x)-3); run;

MikeZdeb · ‎07-06-2012

hi ... you should be able to use the attached SAS job it creates three maps: USA, New England, Massachusetts (this one is linked ... mouse over a STAR brings up info about location and friends) ps looks as if the X/Y location of the zip centroid for North Truro (02652) is a little off (in Cape Cod Bay)

MikeZdeb · ‎07-06-2012

hi ... using Linlin's data (assuming all you have are single digit numbers) ... you have a choice (_numeric_, _character_, _all_) ... data want; set have; num9 = countc(catt(of _numeric_),'9'); char9 = countc(catt(of _character_),'9'); all9 = countc(catt(of _all_),'9') run; num9 char9 all9 1 0 1 1 2 3 4 3 7 if all you have are numbers, just do the _numeric_ part Message was edited by: Mike Zdeb ... added "of _all_"

MikeZdeb · ‎07-06-2012

hi ... the SQL and SUMMARY solutions seem most "economical", but if you are going to sort, you can always sort again and take advantage of the default EQUALS option that maintains order withing sort groups ... proc sort data=have out=want; by case_number descending case_value; run; proc sort data=want nodupkey; by case_number; run;

MikeZdeb · ‎07-05-2012

Hi, thanks ... works like a charm. Time to learn more about the the SG PROCS and all extra stuff (e.g. how to direct output) that I understand in the "non SG world".

MikeZdeb · ‎07-05-2012

hi ... just curious, if I use this ... ods latex path="z:\"; ods graphics on / imagefmt=epsi imagename='plot'; proc sgplot data=sashelp.class; scatter x=height y=weight / group=sex; run; ods graphics off; ods latex close; I know where the EPS file is located, in folder Z:\ if I use the default LISTING destination (no path allowed), where does the EPS file go ods graphics on / imagefmt=epsi imagename='plot'; proc sgplot data=sashelp.class; scatter x=height y=weight / group=sex; run; ods graphics off;

MikeZdeb · ‎07-05-2012

hi ... there may be an easier way, but this will at least get postscript (there's no encapsulated postscript IMAGEFMT) there are free tools for PS to EPS conversion if you really need EPS ods latex path="z:\"; ods graphics on / imagefmt=ps imagename='plot'; proc sgplot data=sashelp.class; scatter x=height y=weight / group=sex; run; ods graphics off; ods latex close; from page 4 in ... Creating Statistical Graphics in SAS 9.2: What Every Statistical User Should Know

Online Status	Offline
Date Last Visited	‎06-28-2018 10:46 AM

Re: Create variables as per separators in string

Re: How to create sub-totals ?

Re: Running a function for each unique value

Re: Aggregating dataset by date, including missing dates

Re: Aggregating dataset by date, including missing dates

Re: Aggregating dataset by date, including missing dates

Re: Aggregating dataset by date, including missing dates

Re: How to write generic libname to multiple databases?

Re: delete/retein observations by frequency (n) of variables

Re: delete/retein observations by frequency (n) of variables

Re: is there simpler way to convert char flag to numeric number

Re: INPUT function requires a character argument

Re: Renaming all variables in a table

Re: Report on missing values of each coloumn

Re: Remove the last character of my string

Re: Proc GMap: Caption and custom legend

Re: Saving PROC GPLOT graph to folder

Re: re: Catx Function Error

How to calculate geodesic distance in SAS

Re: Basic Choro/Annotate Question

Re: Basic Choro/Annotate Question

Re: Horizontal count of number of variables that meet criteria in one ...

Re: how to create variable like this?

Re: How should I put the information on a map?

Re: need data sets???

Re: How should I put the information on a map?

Re: how to create variable like this?

Re: string operation

Re: How should I put the information on a map?

Re: Horizontal count of number of variables that meet criteria in one ...

Re: How to get one subset like this?

Re: How to get a file figurename.EPS with ODS GRAPHICS?

Re: How to get a file figurename.EPS with ODS GRAPHICS?

Re: How to get a file figurename.EPS with ODS GRAPHICS?