@Akshaya_1397 wrote: Hi all, I have two completely different datasets. Dataset1 -clm has variables counterparty,id,name Dataset2-gsl has variable splr_name,relid,phn   Now I need to compare the counterparty name in clm and splr_name in gsl in  New dataset and report the not matching ones.   Can anyone please help me on this. Can I simply use proc compare or is there any other way . It is not clear what you mean by "compare" and "not matching". Proc Compare is a observation by observation comparison by default. So is likely not the tool unless the data sets are expected to have the same number (or at least pretty close) of observations with similar values.   Do want just properties of the variables such as length, format and label? Or values that appear in one data set but not the other? This code will create two data sets with one observation of each value that appears in one data set but not the other. I think the names of the sets explain the contents. Obviously untested as we do not have your data sets. proc sql; create table in_clm_not_gsl as select distinct counterparty as value from clm except select distinct splr_name as value from gsl ; create table in_gsl_not_clm as select distinct splr_name as value from gsl except select distinct counterparty as value from clm ; quit; Warning: These are equal comparisons. So if your variable is character case differences will be reported as "BOB" is not the same as "Bob". ... View more

@mariopellegrini - I don't think there is an ideal number for everyone. I usually try a few different values, like 1,000, 2,000, 5,000, 10,000, 15,000, 20,000 to see which gives the best performance. We currently use 10,000 for most of our loads and that works well. There is no point using a larger number than the number of rows you are appending though. ... View more

You can also do it the "lazy way" using the noDSMFERR option:    data table_1 table_2 table_3 table_7; length value $10.; input value; datalines; aaa bbb ; run; data table_22 table_11; length value $10.; input value; datalines; aa bb ; run; data table_112 table_897; length value $10.; input value; datalines; a b c ; run; option noDSNFERR; data final ; set table_1-table_9 table_10-table_99 table_100-table_999 /* ... add more if needed */ indsname=in; indsname=in; /* <- this variable keeps data set name */ run; option DSNFERR; All the best  Bart ... View more

@dht115 wrote: Still comma became period when I tried to import the file.    What does that mean?   Are you in some location where the convention is to use comma as the decimal point and period as the thousands group separators? ... View more

I copied your comment and sent it to the administrator with SAS log file and he was able to do it right this time! Thank you! ... View more

data Treatment1; format Subject $4. Visit $10. Visit_date date10. NextCycleManuallyAdded $3.; input Subject $8. Visit $12. Visit_date MMDDYY10. NextCycleManuallyAdded $5.; cards; A001 Screening 10/27/2021 Yes A001 cycle1 12/1/2021 Yes A001 cycle2 1/17/2022 Yes A001 cycle3 2/28/2022 Yes A001 cycle4 4/19/2022 Yes A001 cycle5 5/30/2022 Yes A001 cycle6 7/11/2022 Yes A001 cycle7 8/22/2022 Yes A001 cycle8 10/3/2022 Yes A001 cycle9 11/17/2022 Yes A001 cycle10 1/2/2023 Yes A001 cycle11 2/15/2023 Yes A001 cycle12 3/27/2023 Yes A002 Screening 11/22/2022 Yes A002 cycle1 1/14/2023 Yes A002 cycle2 2/28/2023 Yes A003 Screening 9/30/2022 Yes A003 cycle1 11/2/2022 Yes A003 cycle2 11/23/2022 Yes A003 cycle3 1/2/2023 No A003 EOT 1/9/2023 A004 Screening 9/1/2022 Yes A005 cycle1 9/23/2022 Yes A005 cycle2 10/31/2022 No A005 EOT 11/2/2022 ; run; proc sort data = Treatment; by subject descending visit_date; run; data Treatment2; set Treatment; format NextCyle _TempNextCyle $3.; retain _TempNextCyle; by Subject; select; when(first.Subject and Visit eq 'EOT' ) do; NextCyle = ''; _TempNextCyle = 'No';end; when(first.Subject) do; NextCyle = 'Yes'; _TempNextCyle = 'Yes';end; otherwise do; NextCyle = _TempNextCyle; _TempNextCyle = 'Yes';end; end; /* select; when(NextCyle eq NextCycleManuallyAdded) CorrectResult = 1; otherwise CorrectResult = 0; end; */ drop _: ; run; proc sort data = Treatment2; by subject visit_date; run; ... View more