Hi,   Could anyone please help me how to get all file names and and modification date from linux directory using windows is quit simple: filename xl pipe 'dir /T:W "c:\test\*.xlsx"' but '*' signth for linux is not working: filename xl pipe 'ls -r "/test/*.xlsx"'   Another problem is what variable names should I put in input statment to get just filename and last modification date.   data want; format moddate datetime20.; infile xl; input fname (?) $char50. moddate (?) 8.; run;     ... View more

Hi, is there a way to make if statement more efficient? I ve got about 80 mln obs with over 80 if statments in loop, processing this dataset takes couple of hours? Belowe you will find scrap of the code:   %Macro test(x_date) data want; set have; %do i=3 %to 12 %by 3; if datepart(date)>=intnx('month', "&x_date"d,%eval(-&i+1), 'B') and datepart(data_danych)<=intnx('month', "&x_date"d,0,'E') and kod_3 = '1001' then do; var1_&i.m=round(amount*exch_rete,0.01); end; else if datepart(date)>=intnx('month', "&x_date"d,%eval(-&i+1), 'B') and datepart(data_danych)<=intnx('month', "&x_date"d,0,'E') and kod_3 = '1201' then do; var2_w_UP_&i.m=round(amount*exch_rate,0.01); end; else if datepart(date)>=intnx('month', "&x_date"d,%eval(-&i+1), 'B') and datepart(data_danych)<=intnx('month', "&x_date"d,0,'E') and kod_3 in ('1041','1241') then do; var3_&i.m=round(amount*exch_rate,0.01); end; ........ %end; run; %mend; test(31AUG2017);       Thank you. ... View more

Hello,     What might be the reason  sas do not the run Macro with Pass Throught while the same statment out of macro is working properly.   for instance:     %Macro GEN(x_date); %let Krok=&sysmacroname; %let sql_x_d=%sysfunc(putn("&x_date"d, YYMMDD.)); %let sql_x_date=%unquote(%str(%'&sql_x_d%')); %macro_start; %do i=1 %to 12; %if &i<12 %then %do; %let a=1; %end; %else %do; %let a=0; %end; proc sql; connect to oracle (user=pass password=pass path=pass); create table proc19_1 as select * from connection to oracle (select time_stamp id_cst id_trans ofer_kg rate_kg from hd.customers where time_stampt between last_day(add_months(to_date(&sql_x_date),%eval(-&i)))-&a and last_day(add_months(to_date(&sql_x_date),%eval(-&i+1))) disconnect from oracle; quit; %proc19_1; %end; %mend;   Thank you.   ... View more

Could anyone please tell me how to write perl regex which contains prefix or not + 9 number string which can contain only 5 reps of single number. I can not find constraint for replication. I use perl regular expression in sas data regexp; if _n_=1 then pattern=prxparse("~^(48|0|48|0048|)+[1-9]{1}+[0-9]{8}~o"); retain pattern; set new; if prxmatch(pattern,nr_tel) then flg=1; else flg=0;run; Thank you. ... View more

Hi,   can I disable adding rows in which some variables are missing into  my dataset?   Thanks ... View more

Hello,   I would be gratefull if anyone could tell me what is best and most efficient way for left join same size 20 datasets with about 2 mln obs and nearly 50 obs in each.   I found in some articles that the best way for left join are Hash tables if the left datasets are smaller, but what if all of them are same size?     Thank you. ... View more