Punxsutawney Tracker

Re: Hash object's replace method doesn't seem to be working.

Punxsutawney — Fri, 14 Aug 2015 18:46:41 GMT

WOW. That fixed it. I only had to change the key to prov_id. Thanks very much. I really appreciate this.

Hash object's replace method doesn't seem to be working.

Punxsutawney — Fri, 14 Aug 2015 16:08:09 GMT

Hello Everyone,

In the code below, the replace method isn't doing what it should be doing. In fact, when I take that statement out of the code it returns the same results. Can someone please look at this and help me out? Thanks.

Note: there are no errors of any kind returned.

data final;

if 0 then set mbr prov;

declare hash h_prov (dataset: 'prov');

declare hiter i_prov ('h_prov');

h_prov.definekey (all: 'yes');

h_prov.definedata (all: 'yes');

h_prov.definedone();

do until (eof);

set mbr end = eof;

rc = i_prov.first();

do while (rc = 0);

if mbr_ped_ind eq 'Y' then

do;

if prov_ped_ind eq 'Y' and members lt &capacity then

do;

gdist = geodist(mbr_lat, mbr_lon, prov_lat, prov_lon, 'M');

if gdist le &dist_limit1 then

do;

members + 1;

h_prov.replace();

mbr_id = dw_mbr_key;

pcp_id = npi_id;

output;

leave;

end;

else if gdist le &dist_limit2 then

do;

members + 1;

h_prov.replace();

mbr_id = dw_mbr_key;

pcp_id = npi_id;

output;

leave;

end;

else if gdist le &dist_limit3 then

do;

members + 1;

h_prov.replace();

mbr_id = dw_mbr_key;

pcp_id = npi_id;

output;

leave;

end;

run;

Re: Macro resolution and %IF-%Then %Else statements

Punxsutawney — Fri, 14 Aug 2015 15:49:42 GMT

Thanks.

Re: Macro resolution and %IF-%Then %Else statements

Punxsutawney — Thu, 13 Aug 2015 18:10:49 GMT

I figured it out myself. I only needed to put the condition inside the function %sysevalf. Thanks.

Macro resolution and %IF-%Then %Else statements

Punxsutawney — Thu, 13 Aug 2015 17:25:55 GMT

SYMBOLGEN: Macro variable MBR_PED_IND resolves to N

MLOGIC(RUNNER): %IF condition &mbr_ped_ind eq Y is FALSE

SYMBOLGEN: Macro variable GDIST resolves to 319.6732

SYMBOLGEN: Macro variable DIST_LIMIT1 resolves to 10

MLOGIC(RUNNER): %IF condition &gdist le &dist_limit1 is FALSE

SYMBOLGEN: Macro variable GDIST resolves to 319.6732

SYMBOLGEN: Macro variable DIST_LIMIT2 resolves to 20

MLOGIC(RUNNER): %IF condition &gdist le &dist_limit2 is FALSE

SYMBOLGEN: Macro variable GDIST resolves to 319.6732

SYMBOLGEN: Macro variable DIST_LIMIT3 resolves to 30

MLOGIC(RUNNER): %IF condition &gdist le &dist_limit3 is FALSE

SYMBOLGEN: Macro variable MBR_PED_IND resolves to Y

MLOGIC(RUNNER): %IF condition &mbr_ped_ind eq Y is TRUE

SYMBOLGEN: Macro variable GDIST resolves to 171.732

SYMBOLGEN: Macro variable DIST_LIMIT1 resolves to 10

MLOGIC(RUNNER): %IF condition &gdist le &dist_limit1 is FALSE

SYMBOLGEN: Macro variable GDIST resolves to 171.732

SYMBOLGEN: Macro variable DIST_LIMIT2 resolves to 20

MLOGIC(RUNNER): %IF condition &gdist le &dist_limit2 is TRUE

The first block worked fined. However, in the second block especially in the colored portion, the condition evaluates to TRUE instead of FALSE. Clearly 171.20 is NOT less than 20. Can someone help with what's going on here? Thanks.

Re: (Proc SQL or Data step) with macros

Punxsutawney — Thu, 13 Aug 2015 17:13:22 GMT

Hi,

Thanks for the reply. I meant library as a place that stores books, etc. Sorry about the confusion.

Member list

mbr_id zipcode

1 12134

2 12315

3 14235

Library list

lib_id zipcode capacity

15 12541 40

18 14521 45

21 13214 43

Don't worry about optimization. So what I want to do is assign a library ID to each of these members based on first capacity of the library (max capacity is 46) and distance.

I hope this helps. Thanks.

(Proc SQL or Data step) with macros

Punxsutawney — Thu, 13 Aug 2015 13:17:47 GMT

I have 2 sets of data with no common variable. One is a list of library members while the other is a list of libraries. Now, for each member, I want to assign the member to a library (and only one library) based on conditions like library capacity, calculated distance between the library and member, etc. The library capacity should be updated (as in reduced by 1) for the particular library after each assignment of a member to it. I am currently stuck at this and will appreciate any help or ideas. Thanks.