DATA Step, Macro, Functions and more

new row and colounm in table

Reply
Frequent Contributor
Posts: 76

new row and colounm in table

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

Super Contributor
Posts: 349

Re: new row and colounm in table

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

Frequent Contributor
Posts: 76

Re: new row and colounm in table

Dear Shiva,

How we do this by base sas and proc sql.

Thanks and Regards,

Bina

Super Contributor
Posts: 349

Re: new row and colounm in table

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

Ask a Question
Discussion stats
  • 3 replies
  • 143 views
  • 0 likes
  • 2 in conversation