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
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?
Please tell me then how do I update the table, if I have 1000 new data to update in the table?
You have left out some important information:
Here's a simple program that might be appropriate, depending on how you answer those questions:
proc append data=new_rows base=have;
run;
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.