Hello all,
I am trying to replicate the attached SAS query in Impala. Basically, I want to pull all the observations from a dataset having a key variable "ID". Is there a way to replicate the same query using proc sql or may be in Impala.
data want;
if _n_=1 then do;
declare hash m(dataset:"keyvariable");
m.definekey('ID');
m.definedone();
end;
set have;
if m.find()=0;
run;
Thanks for your help,
Tom
How many values in the table keyvariable?
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.