Hello, I want to understand starting position parameter in find function. data test; xyz='She sells seashells? Yes, she does.'; startposexp=-22; whereisShe_ineg22=find(xyz,'She','i',startposexp); put whereisShe_ineg22=; run; In this example  whereisShe_ineg22=14 , Why? As i understand, because the start position is negative, we start at the end of the string and count 22 places, and get the character s. Then the function start search to left, and to right. Why?  please see  https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p00ab6ey29t2i8n1ihel88tqtga9.htm&docsetVersion=3.1&locale=en    Thank you ... View more

Hello, I need help. I want to download data from the next url :  eurocontrol   How can I do it? Thank you ... View more

Hello guys, I want to use macro variables inside the put statement. When I use numbers it works perfectly, but when I replace numbers with macro variables, it doesn't work.   filename DDEcmds  dde 'excel|system';   data _null_; file DDEcmds; put '[select("R2C%sysevalf(&id+3):R100C%sysevalf(&id+3)")]'; put '[Format.Number("#,##0")]';     run; ... View more

I want to keep all observation(after merging  tb1 and tbl2 ), but drop from it all observations that exist in tbl3. the code is used is as follows: proc sql; create table tbl4 vas select t1.* from tbl1 t1 right join tbl2 t2 on t1.x1=t2.x1 and t1.x2=t2.x2 and t1.x3=t2.x3 where t1.x1 not in(select x1 from tbl3) and t1.x2 in(select x2 from tbl3) and t1.x3 in(select x3 from tbl3) order by x1, x2, x3 ; quit;   What is wrong? ... View more