Hello experts, Is it possible to have a sas studio on mobile: wrining and running sas program Thank you ... View more

Hello experts, I have used the solution  below given from the esteemed advisor Tom, it works well, but I have a matter with a big data, the exporting take more than 15 minutes for 3000,000 observations, I would like to have less than 2 minutes, is it possible ? Thank to @Tom and @ll other members    https://communities.sas.com/t5/Base-SAS-Programming/Exporting-a-sas-data-set-into-txt/m-p/314405#M68468 data _null_; file log ; set test(obs=1) test; length __name $32 __length 8 __value $200 ; do while (1=1); call vnext(__name); if lowcase(__name)='__name' then leave; if _n_=1 then __value = __name ; else __value = quote(strip(vvaluex(__name))); __length=lengthn(__value); put __value $varying200. __length ';' @ ; end; put; run;   ... View more

Hello experts, Please, I want to optimise the sas sql query, for the hundred of variables and more than 3 000 000 observations. when I do like below, but , it will take more than 10 minutes   proc sql;  create table toto as select v1 as w1, v2, case ...when ... else as v3,   /* many cases conditions of case are used */... ... .., vn from ( select * from dat1 where y1='O' and f1 ne 'E') as M1 left join beta as M2 on M1.id=M2.id left join omega as M3 on M2.tr=M3.tr; quit; I think using merge with dataset ? will be more faster ?   ... View more