topic Re: How to write Hash coding instead of update statement in SAS Programming

How to write Hash coding instead of update statement

Siva_Harish — Tue, 23 Mar 2021 08:19:43 GMT

Hello Community,

I have a query which looks like below,it is taking a more than an hour to update the dataset ds .

can anyone help me to write a hash code to run fast ?

 proc sql;
 update lib.ds as us
 set name=( select name from sashelp.class as g
							   where us.type= g.name
	where us.name in ( select weight from sashelp.cars)
          and us.name is null;
 quit;

Re: How to write Hash coding instead of update statement

Kurt_Bremser — Tue, 23 Mar 2021 09:13:50 GMT

Please supply example data (data steps with datalines) for the involved datasets.

With the SASHELP datasets you use, your conditions make no sense.

Re: How to write Hash coding instead of update statement

ballardw — Tue, 23 Mar 2021 16:59:37 GMT

@Siva_Harish wrote:

Hello Community,

I have a query which looks like below,it is taking a more than an hour to update the dataset ds .

can anyone help me to write a hash code to run fast ?
 proc sql;
 update lib.ds as us
 set name=( select name from sashelp.class as g
							   where us.type= g.name
	where us.name in ( select weight from sashelp.cars)
          and us.name is null;
 quit;

Your example code has unbalanced quotes so I would not expect it to run at all.

Provide actual code. If your data set or variable names are "sensitive" then replace those bits with nonsense strings.

How many records are involved in these sets? Are they actually native SAS data sets or are you connecting to another DBMS?