Hi everyone, Previous, when using SAS,  we can have pass through to run the query in Oracle, this process is quite smooth. However, due to a special nature of safe environment, I have to run all the codes in SAS only.   It runs incredibly slow now, even for a small set for data b.    Here is the code, and I will put some labels.  I did some searches, but frankly not sure which will be the best approach like index( in this case will > than 34% unique labels) /hash?).        I tried:     1) data step to extract all related data, then join; take too long and too much spaces;     2) use subquery, not by join.   use filter as ---- label in (select distinct label in att.list_low5_&c_year), run quite slow as well.   Any recommendation from advanced users?  thank you very much.        proc sql; create table att.total_list_&p_year as select distinct a.label, num, datepart(dt) as dt from hynp.flat a                                              (*********************  data in Oracle, not sortable, 80 millions records each year) inner join att.list_low5_&c_year b                     (******************* records from thousands to up to 4millions,  this macro run ten circles) on a.label = b.label where dt >= &s_date and dt <='31Mar2019'd and prov = .. and tp = .. and pec = .. and pnum ^= .. and cd < .. and vcd not in (.....) and vloc not in (....) and tm not between ... and ... and tm not in (...) and num not in (...) order by a.label,dt desc, num; quit; ... View more

Hi everyone, I got hundreds of file need to unzip. There are two major problems;   1, input:   right now, 'input;' does not work, only work when you specify the variables and length and format, this causes lots of trouble, as we have to re-define all the variables and format. Especially when dealing with different table, it's a disaster.        I hope to have a simple command to universally treat input; 2, Any way to unzip a batch of files?  Got hundreds, batch by batch and I don't want to do it one by one.   Thanks. ... View more