topic Re: Hash table to Data step or proc SQL in SAS Programming

Hash table to Data step or proc SQL

sasuser1031 — Tue, 01 Oct 2019 13:44:40 GMT

Can somebody help me to convert this code to Data Step or Proc SQL?

SAS code:

data cd;
set ab (rename=(x_ID=ID x_num=num x_year=year));
history_path = 0;
if _n_ = 1 then do;
length x_ID $9 x_num $3 x_year $4;
declare hash vertices(dataset: 'work.ab');
rc = vertices.definekey('x_ID', 'x_num', 'x_year');
rc = vertices.definedata('history');
rc = vertices.definedone();
call missing(x_ID, x_num, x_year, history);

length last_ID $9 last_num $3;
declare hash edges(dataset: 'work.ac', multidata: 'yes');
rc = edges.definekey('x_ID', 'x_num', 'x_year');
rc = edges.definedata('last_ID', 'last_num');
rc = edges.definedone();
call missing(last_ID, last_num);

end;

run;

Re: Hash table to Data step or proc SQL

SASKiwi — Mon, 30 Sep 2019 21:07:26 GMT

Was this program working and now it isn't? If so have you tried increasing SAS's MEMSIZE option to provide more memory?

Re: Hash table to Data step or proc SQL

sasuser1031 — Tue, 01 Oct 2019 12:42:51 GMT

How to increase MEMSIZE?

Re: Hash table to Data step or proc SQL

Tom — Tue, 01 Oct 2019 17:31:08 GMT

That data step does not appear to be using the HASH objects at all. Why not just remove that part of the code?

data cd;
set ab (rename=(x_ID=ID x_num=num x_year=year));
history_path = 0;
run;

Re: Hash table to Data step or proc SQL

hashman — Tue, 01 Oct 2019 19:23:38 GMT

@sasuser1031:

What do you mean by "convert this code to Data Step" if it's already a DATA step?

As far as conversion to SQL goes, what's the purpose of the program? The only thing it currently does is load two data sets into two hash tables at _N_=1 and read the data from AB without processing the data in any way.

Kind regards

Paul D.