Yeah. I believe you SAS is too old to recognize the Hash Method ha.output() .
And : is not a macro vaiable. It is a mistake of SAS Forum .
You need
Change
multidata:'y'
into
m.....a : 'y'
Copy the LOG here ,running under SAS University Edition .
Good Luck.
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
51
52 data have(rename=(old=from contract=to));
53 contract='1';old='';output;
54 contract='2';old='1';output;
55 contract='x';old='';output;
56 contract='a';old='';output;
57 contract='3';old='2';output;
58 contract='y';old='';output;
59 contract='b';old='a';output;
60 contract='4';old='3';output;
61 contract='z';old='';output;
62 contract='5';old='4';output;
63 contract='c';old='b';output;
64 contract='d';old='c';output;
65 run;
NOTE: The data set WORK.HAVE has 12 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
66
67
68
69 data full;
70 set have end=last;
71 if _n_ eq 1 then do;
72 declare hash h();
73 h.definekey('node');
74 h.definedata('node');
75 h.definedone();
76 end;
77 output;
78 node=from; h.replace();
79 from=to; to=node;
80 output;
81 node=from; h.replace();
82 if last then h.output(dataset:'node(where=(node is not missing))');
83 drop node;
84 run;
NOTE: The data set WORK.NODE has 12 observations and 1 variables.
NOTE: There were 12 observations read from the data set WORK.HAVE.
NOTE: The data set WORK.FULL has 24 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.04 seconds
85
86
87 data want(keep=node household);
88 declare hash ha(ordered:'a');
89 declare hiter hi('ha');
90 ha.definekey('count');
91 ha.definedata('last');
92 ha.definedone();
93 declare hash _ha(hashexp: 20);
94 _ha.definekey('key');
95 _ha.definedone();
96
97 if 0 then set full;
98 declare hash from_to(dataset:'full(where=(from is not missing and to is not missing))',hashexp:20,multidata:'y');
99 from_to.definekey('from');
100 from_to.definedata('to');
101 from_to.definedone();
102
103 if 0 then set node;
104 declare hash no(dataset:'node');
105 declare hiter hi_no('no');
106 no.definekey('node');
107 no.definedata('node');
108 no.definedone();
109
110
111 do while(hi_no.next()=0);
112 household+1; output;
113 count=1;
114 key=node;_ha.add();
115 last=node;ha.add();
116 rc=hi.first();
117 do while(rc=0);
118 from=last;rx=from_to.find();
119 do while(rx=0);
120 key=to;ry=_ha.check();
121 if ry ne 0 then do;
122 node=to;output;rr=no.remove(key:node);
123 key=to;_ha.add();
124 count+1;
125 last=to;ha.add();
126 end;
127 rx=from_to.find_next();
128 end;
129 rc=hi.next();
130 end;
131 ha.clear();_ha.clear();
132 end;
133 stop;
134 run;
NOTE: There were 14 observations read from the data set WORK.FULL.
WHERE (from is not null) and (to is not null);
NOTE: There were 12 observations read from the data set WORK.NODE.
NOTE: The data set WORK.WANT has 12 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds
135
136 proc print;run;
NOTE: There were 12 observations read from the data set WORK.WANT.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds
137
138 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
148
How to Concatenate Values
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
-
3974 views
-
0 likes
-
-
