About AAWTomHanks

hhchenfx · ‎03-19-2018

Thanks a lot. A bit shorter. HHCFX data want; set have; retain grp 1; if mod(n,100)=0 then grp+1; run;

FreelanceReinh · ‎05-13-2016

Hi @AAWTomHanks, Try this: %LET TIME = %SYSFUNC(TIME(), b8601tm9.3);

RW9 · ‎04-04-2016

Hi, Thats fundamentally against the purpose of a CSV file. A CSV file is defined as a text file, with one row or fewer of column headers, with subsequent records detailing the data of those columns, delimited by a comma. To that effeect if I was to recieve your described file I would reject it, and I would be surprised if anyone willingly accepts it as such. Export each data strcuture to its own file - you would need to document this in any data transfer agreement document anyways. There are other options out there if you need to ship data as flat file but with structure, JSON and XML can both be used to contain multiple different structures within one file. The question you have to ask is wether its worth the effort, most of the time just create one CSV file per dataset is simplest.

AAWTomHanks · ‎11-10-2015

Ok great thank you. You got me on the right path.

MikeZdeb · ‎08-08-2015

Hi, for some help, take a look at ... From Shapefiles to Maps Via PROC MAPIMPORT and PROC GMAP http://www.lexjansen.com/nesug/nesug11/gr/gr11.pdf Creating ZIP Code-Level Maps with SAS® http://support.sas.com/resources/papers/proceedings13/214-2013.pdf Wow! You Did That Map with SAS/GRAPH®? http://support.sas.com/resources/papers/proceedings09/215-2009.pdf (or send a note to me ... msz03@albany.edu ... if you run into a problem)

GraphGuy · ‎11-14-2014

I don't think there's an option to force the legend levels to start at zero, but you could probably insert a 'fake' item into your data (that doesn't match any real map areas), and give it a value of zero. But when I care about the legend ranges (or 'buckets' as they are sometimes called), I usually take full control, and create a new variable, and then a user-defined format to make the text in the legend show up the way I want, such as ... proc format; value winefmt 1 = '0 to .2' 2 = '.2 to .3' 3 = '.3 to .4' 4 = '.4 to .5' 5 = 'over .5' ; run; data my_data (drop=all decile); set my_data (where=(state_name^='District of Columbia')); format wine_bucket winefmt.; if wine<=.2 then wine_bucket=1; else if wine<=.3 then wine_bucket=2; else if wine<=.4 then wine_bucket=3; else if wine<=.5 then wine_bucket=4; else wine_bucket=5; run;

Anotherdream · ‎10-21-2013

You could also specify the value "guessingrows=32000". That will make SAS look at the first 32,000 rows of data to guess the type instead of the first 8. If you can't be guaranteed that the text occurs in the first 32000 rows, then I would suggest not using proc import from an excel file (frankly I suggest this anyways. Excel is just an awful data storage program).

Ksharp · ‎05-14-2013

Plz check documentation firstly .

GraphGuy · ‎10-09-2012

There's no built-in gmap feature to do that (wish there was!) One work-around is to create an annotate data set that draws a thick/dark county outline, and then overlay that onto the zipcode map. Here's an example that shows how to annotate a state outline onto a county map (this example/technique is described in detail in the book SAS/Graph: Beyond the Basics, in Example 12): http://robslink.com/SAS/book/example12.htm http://robslink.com/SAS/book/example12_info.htm

AAWTomHanks · ‎08-23-2012

Ok thanks I appreciate the help.

DanielSantos · ‎08-10-2012

Try this. %let _MAX=10000; data z; set x; by NAME; drop _:; * loose temp vars; if first.NAME then _SUM=0; * reset sum var; _SUM+MONEY; *sum; if _SUM gt &_MAX then do; * is it maxed?; NEW_COL=MONEY-mod(_SUM,&_MAX); _SUM=&_MAX; * max sum; end; else NEW_COL=MONEY; run; Cheers from Portugal.

Alpay · ‎06-08-2012

Do ADATE and DDATE fields have time parts? Line 2 has ADATE of 03/08/2011 same value as DDATE of Line 1. In that case, (RESUBMIT > DDATE) criteria won't be true. Instead, Line 3 and 4 would be returmed. I have run your code with addition of Line numbers from a and b. PROC SQL; CREATE TABLE RESUBMITS AS SELECT *, B.LINE as LINE_B, (RESUBMIT-DDATE) as RESUBMIT_DAYS FROM A(KEEP=LINE PV FV NAME DDATE SUM) a, A(KEEP=LINE PV FV NAME ADATE RENAME=(ADATE=RESUBMIT)) b WHERE a.NAME=b.NAME AND a.FV=b.FV AND a.PV=b.PV HAVING ((RESUBMIT > DDATE) AND (RESUBMIT-DDATE < 30)); QUIT; LINE NAME DDATE FV PV SUM RESUBMIT LINE_B RESUBMIT_DAYS 1 NEW 8-Mar-11 1 2 7979.5 18-Mar-11 4 10 1 NEW 8-Mar-11 1 2 7979.5 13-Mar-11 3 5 2 NEW 13-Mar-11 1 2 6403.19 7-Apr-11 5 25 2 NEW 13-Mar-11 1 2 6403.19 18-Mar-11 4 5 3 NEW 18-Mar-11 1 2 5378.48 7-Apr-11 5 20 4 NEW 6-Apr-11 1 2 28029.58 7-Apr-11 5 1

MikeZdeb · ‎05-22-2012

Hi ... #1 you could try jittering (offset the points), lots of references including ... http://support.sas.com/kb/24/923.html #2 or how about just using a different size symbol (or different symbols) that varies in size (or type) by the number of whatever at any given location. #3 or, I assume you add symbols to a map with annotate. If' I'm correct, the POSITION variable has 15 distinct values for any set of x/y coordinates. So maybe just varying the value of POSITION will allow you to avoid overlap

Ksharp · ‎05-03-2012

Do you have to use SQL ? I think proc means is better . proc means data=have nway noprint; class pc CODE; var JAN2010--DEC2011; output out=want max= /autoname; run; Ksharp

MikeZdeb · ‎05-01-2012

hi ... I'm never quite sure what I'll get with MIDPOINTS, that said ... I'm using V9.3 and you can add the RANGE option to show the actual low-high values (results of using MIDPOINTS) in the legend, otherwise you get the midpoints using the data set and graphics options from my previous post ... title h=3 'LEGEND WITH RANGES (BASED ON MIDPOINTS 2.5e5 1e6 2.75e6 4e6 8e6)' ls=2; proc gmap map=maps.us data=uspop; id state; choro pop / midpoints=(2.5e5 1e6 2.75e6 4e6 8e6) range coutline=grayaa; format pop comma10.; run; quit;

Online Status	Offline
Date Last Visited	‎05-04-2018 11:58 AM

Re: Creating a Column That Groups Data Every n Rows

Creating a Column That Groups Data Every n Rows

Date Macro Help

Export Multiple Datasets into one DLM/CSV file

Re: Find a Central Zip for a Cluster of Zips

Find a Central Zip for a Cluster of Zips

Re: NJ Zip Map

NJ Zip Map

Re: Help Drawing Radius Circles

Help Drawing Radius Circles

Make A Quicker Legend

Re: Creating a Column That Groups Data Every n Rows

Re: Date Macro Help

Re: Export Multiple Datasets into one DLM/CSV file

Re: Find a Central Zip for a Cluster of Zips

Re: NJ Zip Map

Re: Help Drawing Radius Circles

Re: Import Excel and Make a Column with Dates a Character Column

Re: Change a Dates Format

Re: One County with Zips Map

Re: Scroll Overs for a Map

Re: Cap a Numeric Column

Re: Proc SQL Help Dealing with Resubmits

Re: Loop Needed

Re: Macro in Proc Sql Statement

Re: Make A Quicker Legend