Hi ,   I have two Datasets with Groups . Data1 has DIX in group1 and Data2 has DIX in group2 so we are not missing data . How do i do sorting so that i can say both DIX and PTE are present in both Data1 and Data2 and they are not missing      Data1   Policy_num Group1 Group2 100 DIX PTE         Data2   Policy_num Group1 Group2 100 PTE DIX   Can anyone please help  ... View more

Hi ,   I am running below query but I get an ERROR Lock not available . Can anyone please help .    libname mylib  'serverY\DATA\TEST';   PROC SQL ; CONNECT TO ODBC (DATAsrc=XXXX USER = XXX PASSWORD = XXX); CREATE TABLE mylib.Apple AS  SELECT * FROM CONNECTION TO ODBC   ( Select account,       member from database.table d ); quit; NOTE : Table mylib.Apple created with 100 rows and 20 columns data mylib.Apple; SET mylib.Apple; RUN; ERROR: A lock is not available from mylib.Apple   Thank you ... View more

Hi , I have  a dataset  Test1 which has these columns Placebo,RBC,WBC,Weight,Number.Another Dataset Test2 which looks like below. In Dataset Test2 I have taken list of items I need to check in Data Test1 whether they exist or not .  And for the match ones i need to create Test3 which will have common variables which are in both Test1 and Test2 dataset using below code i am able to check all the variables Test2 List Freq RBC Count WBC Treatment Placebo Other,Race,Weight   proc contents data=test1  out=sdetail (keep=name varnum); run; proc sql;  create table Test3 as   select List,Freq    ,(upcase(List) in (select upcase(name) from sdetail)) as var1    ,(upcase(Freq) in (select upcase(name) from sdetail)) as var2   from test2 create  table  Test7 as   select List , Freq from test3   where var1=1 and var2=1  ;  quit; But I am able to check Count,Treatment RBC,WBC in test2 whether they are in test1 but how can i check when variables in Freq seperated by commas using above code like other,Race,Weight Can anyone please help Thank you ... View more