new row and colounm in table

[Ashwini]

How we know a new  rows and columns  add in a existing data set by base coding,proc sql and di studio.

Thanks and Regards,

Ashwini

[shivas]

Hi,

In SAS DI you can use status handling in job properties to know number of records before and number of records after.

Thanks,

Shiva

[Ashwini]

Dear Shiva,

How we do this by base sas and proc sql.

Thanks and Regards,

Bina

[shivas]

Hi,

You can use proc compare in Base sas.

data one;

input no;

cards;

2

3

4

;

run;

data two;set one;

if no=2 then delete;

x=22;

run;

proc compare base=one compare=two out=load_check_result outbase outcomp outnoequal ;

run;

Thanks,

Shiva