If I change the size to be 0.5 in data city_anno step, proc gmap doesn't produce a round dot for me.
data city_anno; set city2;
/* Convert degrees to radians */
x=atan(1)/45 * x * -1;
y=atan(1)/45 * y;
when='A'; xsys='2'; ysys='2'; hsys='3';
function='pie'; color='cx330099'; size=0.5;
style='psolid'; rotate=360;
annoflag=1;
run;
... View more
Below is my code. I don't know where it goes wrong. Two address points don't show up in the graph. Maybe I don't do gproject or annotation correctly. Any help is appreciated.
===============================================
data city1;
city='Milford'; state_cd='DE'; zip=19963; state=10;
output;
city='Hartly'; state_cd='DE'; zip=19953; state=10;
output;
run;
proc geocode zip
addressstatevar=state_cd
data=city1
out=city2;
run;
proc gproject deg
data=city2
out=city3;
id state;
run;
data city_anno;
set city3;
when='A';
xsys='3'; ysys='3';
function='label';
color='cx330099'; size=1.25; text='J';
position='5'; style='special';
run;
data de1;
set maps.states;
if state=10;
run;
title;
proc gproject
data=maps.states
out=de;
id state;
where state=10;
run;
pattern v=e;
proc gmap map = de
anno = city_anno;
id state;
choro state / nolegend;
run;
quit;
... View more
You are smarter and can read the SAS syntax page.
I tried several different combinations and nothing works. One of them is:
proc format library=work.mydataset fmtlib;
select $rank;
run;
... View more
Suppose this string is:
s ="Amy,Jeff,Paul,Mary"
I can get the first two words using Scan function twice:
w2 = scan(s,1,',')||scan(s,2,',');
Is there any single function call which can accomplish this?
... View more
Hmm...you still don't get what I mean.
Suppose:
Rank=1 => being formated as "Top 10"
Rnak=2 => being formated as "Top 20"
Rank=3 => being formated as "Top 30"
....
I want to find out this relationship/mapping.
... View more
I only have a SAS dataset, no original Catalog which created the user-defined formats used in the dataset. Isn't FMTLIB only applied for Catalog only?
Here is a more detailed description about my dataset:
The data looks like:
Student Rank
Tom Top 10
Mary Top 20
Joe Top 10
Nancy Top 30
Rank is a numeric variable, but associated with a user-defined format. That is why you see those strings Top 10, Top 20.. when viewing the dataset. I want to know what are the underlying numeric values corresponding to each string. That is what I meant by "decoding a format".
... View more
What is F10.4 format? I can't find any web page in SAS explaining this format.
Second, a dataset has user defined formats attached to some variables. How to "decode" these user defined formats?
Thanks in advance!
... View more
Input data is like this:
David, 10, 3, 20
Mary, 31, 2
....
Output SAS dataset is like this:
Name Score
David 10
David 3
David 20
Mary 31
Mary 2
.....
... View more
I am building a SPWA based web application. I want to add a download link to the web page for users to download the data to an Excel spreadsheet like "Donwload to Spreadsheet" link shown in the following Yahoo Historical Stock Price page:
http://finance.yahoo.com/q/hp?s=^GSPC
Any hints are appreciated!
... View more
