sql - Can I modify an existing SAS dataset without creating a temporary file? -
In addition to the statement
Related questions: If I have a Since 2 people already post it, this is not a valid answer: If you do this, then the SAS creates a temporary file and after the completion of the data changes the original lib.dsn. If you interfere with this kind of data phase, there will be an error in the log, but the original dataset will remain unchanged. modify statement, there are other ways to modify the contents of the SAS dataset (i.e. Changing values, or adding or removing rows or columns) that does not include no to create a temporary file in work and then replace the entire original file?
proc sql with a
create table
statements statement, all targeting In the same table, SAS will overwrite the output table several times at the end, or is it smart enough to write all in one pass? Let's say I'm not connected to any other DBMS.
data lib.dsn; Set lib.dsn; / * Insert logic here * / /;
Update lines with PROC SQL; UPDATE
Delete with PROC SQL; DELETE
Add PROC APPEND or
with PROC SQL; INSERT
Comments
Post a Comment