Extra comma at the end. 🙂   PROC SQL; CREATE TABLE in.AAAA as SELECT Client AS IDNumber, CIDNumber AS au_IDNumber, . as Emp, BN871, BN562, BN123, BN346, . as MT111, . as MT112, . as MT113, . as MT114, D_host, AXZ_host, TJD_AG FROM in.PME_SDC; QUIT; /*Now try*/ ... View more

You can provide the path here instated of only file name.   call system('/dev/user/sandeep/Sample.ksh');   ... View more

1. Sort the 2 datasets by account. 2. Merge the 2 datasets to create a single dataset by account. 3. In the Merge step subtract the related variables to get your result. e.g. fico_diff=fico_201701-fico_201712 ... View more

I have created one example macro as you can not share the macro code.   Suggestion: Please make sure the table descriptions get appended not replaced on repetitive call of the macro.   %macro find(tabname=); %put &tabname.; %mend find; data tablist; input tables:$20.; cards; account people list transaction amortization service ; run; proc sql noprint; select distinct '%find(tabname='||strip(tables)||')' into :runmacro separated by ';' from tablist; quit; &runmacro.; ... View more

/*This works*/ data have_gold; input Patient_ID:best12. Date1:mmddyy8. Date2:mmddyy8.; format date1 date2 date9.; datalines; 24 12/02/15 12/23/15 25 12/02/15 12/23/15 26 12/03/15 12/24/15 ; run; data have_log; input Patient_ID:best12. Date_of_Visit:mmddyy8. Form1:$10. Form2:$10. Form3:$10.; format Date_of_Visit date9.; datalines; 24 12/02/15 Yes No Yes 24 12/23/15 Yes Yes Yes 25 12/02/15 Yes No Yes 26 12/24/15 No Yes No ; run; proc transpose data=have_gold out=have_gold_trans(drop=_name_ rename=(col1=Date_of_Visit)); by Patient_ID; run; proc sort data=have_gold_trans; by Patient_ID Date_of_Visit; run; proc sort data=have_log; by Patient_ID Date_of_Visit; run; data want(drop=Form:); merge have_gold_trans(in=a) have_log(in=b); by Patient_ID Date_of_Visit; if a and not b then output; run; ... View more