AncaTilea Tracker

Re: Crosstab Dates

AncaTilea — Wed, 17 Jul 2019 19:18:49 GMT

Hi,

I am not quite sure I understand the output desired, by my friend and I have worked out this little code that might be helpful:

data have;
input id date $ 3-13 event ;
mydate = mdy(substr(date, 1,2),substr(date,4,2), substr(date,7,4));
format myDate date9.;
datalines;
1 11/23/2014 0
2 10/23/2014 0
2 11/23/2014 1
1 10/23/2016 1
;
run;
proc print;run;

proc report data = have;
column id event, (mydate);
define id/group;
define event/across;
define myDate/group;
run;

Re: why repeated observations??

AncaTilea — Wed, 07 Sep 2016 20:04:14 GMT

because it carries down from the information above...

You never told SAS to change the value...

Re: why repeated observations??

AncaTilea — Wed, 07 Sep 2016 19:56:32 GMT

Then do something like this:

data new ;
do i=1 to 10;
if mod(i,2)=0 then output;
end;
run;
proc print;run;

Re: why repeated observations??

AncaTilea — Wed, 07 Sep 2016 19:54:46 GMT

Hi.

if you go through the do-loop, you will see how values get assigned to out:

for i = 1, mod(i,2) = 0 is False, so out = .;

output this record;

for i = 2, mod(i,2) = 0 is true, so out = 2;

output this record;

for i = 3, mod(i,2) = 0 is False, so out = 2;

output this record;

for i = 4, mod(i,2) = 0 is true, so out = 4;

output this record;

if you want out to take a different value for the cases when mod(i,2) is false, then assign it.

Something like,

if mod(i,2) = 0 then out = i;else out = .;

I hope this helps.

Anca.

Re: Add rivers to US map

AncaTilea — Fri, 15 Apr 2016 12:41:49 GMT

@GraphGuy

Thank you!

You are an endless resource!

Anca.

Re: Add rivers to US map

AncaTilea — Sat, 19 Mar 2016 21:24:59 GMT

@ballardw, @Darrell_sasHi, thank you for your reply; I will give it a try. I used to be able to use this SAS community site, now I could barely find my post, so for the longest time I did not know I received an answer.

So thank you!

Add rivers to US map

AncaTilea — Fri, 11 Mar 2016 11:57:34 GMT

Dear community,

I would like to add (overlay?) US rivers on a US map.

I have followed thispost (Thank you!):

https://communities.sas.com/t5/SAS-GRAPH-and-ODS-Graphics/Add-water-areas-into-US-map/m-p/36815/highlight/true#M1157

At first I only took one state as example - Delaware,that only has three counties- I downloaded the Areawater and Edges files corresponding to the counties in Delaware.

I GPROJECT the X,Y coordinates from the Edge sfiles (and Areawater)....

Bottom line, my projected values for coordinates are multipple time larger than the SAS Counties data coordinates.

I am wondering if there has been any progress since the post I am using as resource.

Or,

is there a better/easier way to add water information on a US map?

Thank you!

Re: # of months between two date vars

AncaTilea — Tue, 14 Jul 2015 14:18:10 GMT

How about something like this:

data have;

informat date_col_1 mmddyy10. date_col_2 yymmn6.;

format date_col_1 mmddyy10. date_col_2 yymmn6.;

input ID date_col_1 date_col_2 total;

diff_mths = (date_col_1 - date_col_2)/30.25;

datalines;

1 1/3/2012 201203 5

1 1/3/2012 201204 7

1 1/3/2012 201205 3

2 10/5/2013 201201 1

2 10/5/2013 201202 12

3 3/4/2012 201301 11

3 3/4/2012 201305 4

3 3/4/2012 201401 5

3 3/4/2012 201403 10

;

run;

proc print;run;

Anca.

Re: ODS Tagsets ExcelXP Creating Multiple Workbooks

AncaTilea — Mon, 13 Jul 2015 13:16:32 GMT

Perhaps this discussion may help

Anca.

Re: Histogram with different fill colors beyond a specified point

AncaTilea — Mon, 03 Nov 2014 13:37:17 GMT

Hi.

AS soon as I posted my answer, I realized ...ehh, that's not a solution.

Well, here is something soooo tedious, but does what you want:

(this is going back to good ol' style: annotate!)

*--create an annotate dataset, that will force to color bins based on VERY specific values;

data boxColor;

length function style color $ 8 ;

xsys="3"; ysys="3";when = "a";

set sashelp.class;

%bar(32.7,7.89,42.5,88.2,red,1,solid);

%move(32.7,7.9);

%draw(32.7,88.2,black,1,.5);

%move(32.7,88.2);

%draw(42.5,88.2,black,1,.5);

%move(42.5,7.9);

%draw(42.5,88.2,blue,1,.5);

%bar(42.5,7.9,61.5,48,red,1,solid);

%move(42.5,7.9);

%draw(42.5,48,black,1,.5);

%move(42.5,48);

%draw(61.5,48,black,1,.5);

%bar(61.5,7.9,80.5,48,red,1,solid);

%move(61.5,7.9);

%draw(61.5,48,black,1,.5);

%move(61.5,48);

%draw(80.5,48,black,1,.5);

%bar(80.5,7.9,98.5,18,red,1,solid);

%move(80.5,7.9);

%draw(80.5,18,black,1,.5);

%move(80.5,18);

%draw(98.5,18,black,1,.5);

run;

%annomac;

ods graphics off;

proc univariate data = sashelp.class anno = boxColor;

var age;histogram age;

run;

Now let me know if you have questions.

Hopefully will find a more elegant solution

Anca.

Re: How to make columns in sas using proc sql

AncaTilea — Tue, 28 Oct 2014 11:20:37 GMT

Hi.

Here is a simple (probably not most efficient) way:

data in;

input A_id A_Amount A_Stage $ A_week $;

datalines;

1 2123 first wk_1

2 234324 first wk_1

3 232 first wk_1

4 1 first wk_1

5 1123 first wk_1

1 3242 second wk_2

2 324255 second wk_2

3 2342 second wk_2

4 4324 second wk_2

1 242424 third wk_3

2 43242 third wk_3

3 424 third wk_3

4 242 third wk_3

1 4 fourth wk_4

2 243 fourth wk_4

3 2 fourth wk_4

;

run;

proc sort data = in;by a_id;

proc transpose data = in out = want(drop = _name_) prefix = A_stage;

by a_id;

/*id a_stage;*/

var a_stage;

run;

proc transpose data = in out = want2(drop = _name_) prefix = A_week;

by a_id;

/*id a_week;*/

var a_week;

run;

proc transpose data = in out = want3(drop = _name_) prefix = A_amount;

by a_id;

/*id a_amount;*/

var a_amount;

run;

data really_want;

merge want:;

by a_id;

run;

Is this what you had in mind?

Best of luck,

Anca.

Re: Need help on substr and scan function

AncaTilea — Tue, 28 Oct 2014 11:00:17 GMT

How about this?;

data have;

input name $ 1- 22 Address1 $ 23 -48 Address2 $ 49 - 74;

datalines;

VALERIE C SANDMIRE 1302 ELLENWOOD DR MADISON WI 53714-1006

JONAH Z HAUGLEY 884 HUNTERS TRL SUN PRAIRIE WI 53590-2585

DOROTHY A GENSKE 700 DOUGLAS TRL MADISON WI 53716-2125

;

run;

data want;

set have;

zipcode = substr(scan(address2,-1," "),1,5);

state = scan(address2,-2, " ");

run;

I hope it helps,

good luck!

Anca.

Re: Histogram with different fill colors beyond a specified point

AncaTilea — Fri, 24 Oct 2014 12:39:54 GMT

Hi.

I don't know how to do this using PRC SGPANEL, but below is a code using PROC TEMPLATE + PROC SGRENDER:

*say you want to differentiate children older than 12;

*I created two variables out of AGE: age_below and age_above;

DATA HAVE;

SET SASHELP.CLASS;

IF AGE <= 12 THEN AGE_BELOW = AGE;

ELSE AGE_ABOVE = AGE;

RUN;

*tell SAS to save my graph in this location;

ODS LISTING GPATH = "GivePath";

*give a name to my graph;

ODS GRAPHICS/RESET IMAGENAME = "SPLIT_HIST";

*write the template to create the histogram with two colors;

*the first few lines are telling SAS how wide and long I want to graph, then gives some graph space preferences;

*notice the two histogram statements (which I overlay), one for the below variable, one for the above variable;

PROC TEMPLATE;

DEFINE STATGRAPH Hist2Colors;

BEGINGRAPH / DESIGNWIDTH=1074 DESIGNHEIGHT=724;

LAYOUT LATTICE / ROWDATARANGE=DATA COLUMNDATARANGE=DATA ROWGUTTER=10 COLUMNGUTTER=10;

LAYOUT OVERLAY / XAXISOPTS=( LABEL=('AGE'));

HISTOGRAM AGE_ABOVE / NAME='HISTOGRAM' BINWIDTH=1.0 FILLATTRS=GRAPHDATA1 OUTLINEATTRS=GRAPHDATA1;

HISTOGRAM AGE_BELOW / NAME='HISTOGRAM2' BINAXIS=FALSE BINWIDTH=1.0;

ENDLAYOUT;

ENDGRAPH;

END;

RUN;

*the sgrender procedure will render the template

PROC SGRENDER DATA=WORK.HAVE TEMPLATE=Hist2Colors;

RUN;

I hope it helps.

Best of luck!

Anca.

Re: Macro to decrease balances by a set monthly amount

AncaTilea — Tue, 21 Oct 2014 11:32:26 GMT

Hi,

How about this?

(NOTE: it is not a macro, but seems to take care of what you need, unless I completely misunderstood)

*start with account # and balance associated;

data have;

input account balance;

datalines;

1 1000

2 2000

3 3000

4 4000

5 6000

;

run;

*create 100 months;

data tmp;

set have;

do i = 1 to 100;

month = i;output;

end;drop i;

run;

%let monthlyPay = 60;

data want;

set tmp;

by account;

retain result 0;

if first.account then result = balance - &monthlyPay.;

else result = result - &monthlyPay.;

if result < 0 then result = 0;

run;

*make it wide ;

proc transpose data = want out = really_want (drop = _name_) prefix = mth;

by account;

id month;

var result;

run;

Best of luck,

Anca.

Re: How can I do this in SAS

AncaTilea — Mon, 28 Jul 2014 17:58:21 GMT

How about this?

assuming your example data set is named have;

data want;

set have;

by id;

if eof1 = 0 then set have (firstobs = 1 keep = state rename = (state = start)) end = eof1;

else start = .;

if eof1 = 0 then set have (firstobs = 2 keep = state years

rename = (state = end years = time)) end = eof1;

else end= .;

if last.id then delete;

run;

I hope it helps.

Anca.

Re: How can I do this in SAS

AncaTilea — Mon, 28 Jul 2014 16:18:13 GMT

Your initial data structure is rather confusing.

Your initial data has 6 rows for ID 100002 and 3 rows for 100004.

What is the logic that makes the last row for each ID go away in the data you want?

I can see that for the 'time' variable you are simply bringing up the 'years' variable values, but not if it's zero?

Provide a bit more detail.

Anca.

Re: SGRENDER DiscreteLegend values

AncaTilea — Tue, 22 Jul 2014 13:48:36 GMT

Thanks Sanjay!

Re: SGRENDER DiscreteLegend values

AncaTilea — Tue, 22 Jul 2014 12:50:43 GMT

PERFECTION!

THANK YOU!

US Territories Map

AncaTilea — Fri, 18 Jul 2014 16:10:19 GMT

Hi,

Can SAS (9.3) PROC GMAP create a US map INCLUDING the Territories?

*FAKE DATA;

DATA DSET;

INPUT STATECODE $ RATE;

STATE = STFIPS(STATECODE);

DATALINES;

AK 91.2

AL 102.2

AR 115.1

AZ 131.5

CA 138.1

CO 151.5

CT 163.3

DC 178.5

DE 197.0

FL 218.4

GA 237.0

HI 257.4

IA 276.2

ID 287.1

IL 306.4

IN 302.6

KS 321.5

KY 337.5

LA 353.7

MA 363.0

MD 367.5

ME 373.8

MI 373.9

MN 375.0

MO 375.7

MS 378.2

MT 386.0

NC 377.9

ND 374.3

NE 378.4

NH 371.3

NJ 357.1

NM 252.6

NV 271.5

NY 287.5

OH 303.7

OK 313.0

OR 317.5

PA 323.8

PR 323.9

RI 325.0

SC 325.7

SD 328.2

TN 336.0

TX 327.9

UT 324.3

VA 328.4

VT 321.3

WA 307.1

WI 292.8

WV 278.5

WY 264.2

FM 328.4

GU 321.3

MH 307.1

MP 292.8

PW 278.5

PR 264.2

VI 264.2

;

RUN;

PROC GMAP DATA = DSET MAP = MAPS.US ALL GOUT = WORK.GRAPHS;

ID STATE;

CHORO RATE/NAME = "MAP" DISCRETE COUTLINE = GRAYAA noLEGENDSTATISTIC = MEAN DES = '';

RUN;QUIT;

Re: SGRENDER DiscreteLegend values

AncaTilea — Thu, 17 Jul 2014 15:32:58 GMT

Sanjay,

I was afraid I may have to use the attr maps - which I used once for a very specific example.

Do you think you could provide some example code?

Thank you.

Anca.