topic Re: new row and colounm in table in SAS Programming

new row and colounm in table

Ashwini — Wed, 13 Jun 2012 06:12:38 GMT

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 — Wed, 13 Jun 2012 06:33:20 GMT

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 — Wed, 13 Jun 2012 08:17:21 GMT

Dear Shiva,

How we do this by base sas and proc sql.

Thanks and Regards,

Bina

shivas — Wed, 13 Jun 2012 09:16:28 GMT

Hi,

You can use proc compare in Base sas.

data one;

input no;

cards;

;

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