Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
idiq
Starting Member
2 Posts |
 Posted - 2010-08-17 : 14:26:44
|
| Hi all,I am VERY VERY new to programming in general, and working with SAS. I am writing a small program in SQL and was hoping to get some guidance. Here is what's going on:-There is a master table with hundreds of rows, and multiple fields-SOME rows and specifically SOME fields need to be updated in master-ALL data in the update table replaces only SOME data in master-An Excel sheet with the update data exists-Each row has a unique identifier (e.g. 1200, 1201, 1202)I've imported the Excel sheet data into SAS as a Table.Can you suggest the best functions to execute this? I don't want anyone to write the code for me, but since I have no clue what functions exist (or do what) I'm just looking for help as to which would be best for this.Something where:-On conflict Table_Master and Table_update, Table_update wins,-On conflict Table_Master data replaced by table_update data,I've been investigating the CASE and UPDATE functions. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
idiq
Starting Member
2 Posts |
Posted - 2010-08-17 : 14:48:59
|
| Whoops, I just did a Google query on SQL Forum and this came up... See how new I am to programming? I just know I can use the SQL Language in SAS to execute programs, and I'd rather code in that than in SAS (I believe SQL usage > SAS usage). Thanks... |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-08-17 : 16:24:29
|
The SAS language is far from SQL Server syntax. SAS have their own syntax.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
|
|
|
|
|
SQL in SAS, Program Check