Document says about the locking of SAS dataset, but I need to lock the SAS program code file. I use proc datasets to read, write access and it is very helpful. Special thank to Raveena,SASKiwi ,polingjw ,Doc@Duke ,darrylovia ,twocanbazza . I learned many things from you while I am trying to find the solution for my question.. I appreciate your help... ... View more

Can you send me the link or SUGi paper ?? I dont see any password protection option? ... View more

I tried doing that but any one can change the settings again. Thanks anyway.. ... View more

Make sure Table1 is first then Table2 in the merge statement.. if you dont use ina and inb.... data table1; infile cards; input var1 $ var2 @@; cards; a 1 b 2 c 3 d 4 ; data table2; infile cards; input var1 $ var2 @@; cards; b 5 c 6 ; data x; merge table1 (in=ina) table2 (in=inb); by var1; if ina; run; this is similar to SQL left join.. ... View more

Another way.. Make sure to sort the two tables before merge .. but for this case they are already sorted so no sorting is done.. data table1; infile cards; input var1 $ var2 @@; cards; a 1 b 2 c 3 d 4 ; data table2; infile cards; input var1 $ var2 @@; cards; b 5 c 6 ; data x; merge table1 table2; by var1; run; ... View more

data x; length currentID$ 15.; input CurrentID$; cards; A119966-A85 A119966-B85 A121065-A31 A123206-A18 A123206-B18 ; run; data y; set x; new = substr(CurrentID,2,12); run; ... View more

There should not be any period after the name of the macro.. like &UID not &UID. Where you need to use period after &CUT in the below example. C:\ ...\&CUT..xls ... View more

OR this should do it.. I think this should work.. %macro cnt_inv(tbl=, vr=, st=, part= , ds=); PROC SQL; create table &tbl. as select count(*) as &vr. from &ds. where com in (&st. , &part.) group by userid ; quit; %mend cnt_inv; ... View more

%macro cnt_inv(tbl=, vr=, st=, part= , ds=); PROC SQL; create table &tbl. as select count(*) as &vr. from &ds. where com in ( (&st.) , (&part.) )group by userid ; quit; %mend cnt_inv; ... View more

t Message was edited by: Ravi Mantripragada ... View more

Thats interesting.. Let me work on it.. Message was edited by: Ravi Mantripragada ... View more