topic To update SAS dataset in SAS Enterprise Guide

To update SAS dataset

Sourav_sas — Thu, 28 Dec 2017 09:13:57 GMT

I have one table already in the library. I need to update the table with some new rows or observation. May be the rows will be sometimes thousands of, or sometime only 10 rows. I can not delete the table from the library. I need easiest process to do this. There in the table there is a possibility also we can use special sign. also the length of some columns more than 100.

Please help me with this.

Thanks

Sourav

Re: To update SAS dataset

LinusH — Thu, 28 Dec 2017 10:04:36 GMT

Not sure what is the challenge is here. It seem like a normal data processing to me.

What have you tried, your thoughts so far?

Re: To update SAS dataset

Sourav_sas — Thu, 28 Dec 2017 11:20:55 GMT

Please tell me then how do I update the table, if I have 1000 new data to update in the table?

Re: To update SAS dataset

Astounding — Thu, 28 Dec 2017 11:33:14 GMT

You have left out some important information:

Are you always adding new rows, and never changing the existing rows?
Is the data set currently in sorted order? Is it important to keep it in sorted order?
Does your data set with the updates in it contain exactly the same variables, defined in exactly the same way as the original data?

Here's a simple program that might be appropriate, depending on how you answer those questions:

proc append data=new_rows base=have;

run;

Re: To update SAS dataset

LinusH — Thu, 28 Dec 2017 15:35:22 GMT

Forgive me, but it sounds like you have no idea of what you are doing.

Start by taking the SAS Programming 1 training, which will give you a foundation to stand on when it comes to manipulating data.