{"id":3955,"date":"2023-07-14T12:53:49","date_gmt":"2023-07-14T12:53:49","guid":{"rendered":"https:\/\/statorials.org\/ko\/sas-proc-sql-%e1%84%8b%e1%85%a5%e1%86%b8%e1%84%83%e1%85%a6%e1%84%8b%e1%85%b5%e1%84%90%e1%85%b3\/"},"modified":"2023-07-14T12:53:49","modified_gmt":"2023-07-14T12:53:49","slug":"sas-proc-sql-%e1%84%8b%e1%85%a5%e1%86%b8%e1%84%83%e1%85%a6%e1%84%8b%e1%85%b5%e1%84%90%e1%85%b3","status":"publish","type":"post","link":"https:\/\/statorials.org\/ko\/sas-proc-sql-%e1%84%8b%e1%85%a5%e1%86%b8%e1%84%83%e1%85%a6%e1%84%8b%e1%85%b5%e1%84%90%e1%85%b3\/","title":{"rendered":"Sas: proc sql\uc5d0\uc11c update\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"

<\/p>\n

\n

SAS\uc758 PROC SQL<\/strong> \uc5d0\uc11c UPDATE<\/strong> \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uc138\ud2b8\uc5d0 \uc788\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \uc5f4 \uac12\uc744 \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\uc2e4\uc81c\ub85c UPDATE<\/strong> \ubb38\uc744 \uc0ac\uc6a9\ud558\ub294 \uac00\uc7a5 \uc77c\ubc18\uc801\uc778 \ubc29\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n

\ubc29\ubc95 1: \uc870\uac74\uc5d0 \ub530\ub77c \uc5f4\uc758 \uac12 \uc5c5\ub370\uc774\ud2b8<\/strong><\/span><\/p>\n

 proc sql<\/span> ;\n    update<\/span> my_data\n    set<\/span> var1='new_value'\n    where<\/span> var1='old_value';\nquit<\/span> ;<\/strong><\/span><\/pre>\n
 \ubc29\ubc95 2: \uc5ec\ub7ec \uc870\uac74\uc5d0 \ub530\ub77c \uc5f4\uc758 \uac12 \uc5c5\ub370\uc774\ud2b8<\/strong><\/span><\/p>\n
 proc sql<\/span> ;\n    update<\/span> my_data\n    set<\/span> var1 = \n    case when var1> 25<\/span> then 100<\/span>\n    when var1> 20<\/span> then 50<\/span>\n    else 0<\/span>\n    end;\nquit<\/span> ;<\/strong><\/span><\/pre>\n
 \ub2e4\uc74c \uc608\uc5d0\uc11c\ub294 SAS\uc758 \ub2e4\uc74c \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c \uc2e4\uc81c\ub85c \uac01 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/span> <\/p>\n
 \/*create dataset*\/\n<\/span>data<\/span> my_data;\n    input<\/span> team $position $points;\n    datalines<\/span> ;\nA Guard 22\nA Guard 20\nA Guard 30\nA Forward 14\nA Forward 11\nB Guard 12\nB Guard 22\nB Forward 30\nB Forward 9\nB Forward 12\nB Forward 25\n;\nrun<\/span> ;\n\n\/*view dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;<\/strong><\/span> <\/pre>\n
\"\"<\/p>\n
 \uc608\uc2dc 1: \uc870\uac74\uc5d0 \ub530\ub77c \uc5f4\uc758 \uac12 \uc5c5\ub370\uc774\ud2b8<\/strong><\/span><\/h2>\n
 PROC SQL<\/strong> \uc5d0\uc11c \ub2e4\uc74c UPDATE<\/strong> \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac01 \ud300 \uc5f4 \uac12\uc744 “Atlanta”\ub85c \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uae30\uc874 \uac12\uc740 “A”\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/span> <\/p>\n
 \/*update values in team column where team is equal to 'A'*\/\nproc sql<\/span> ;\n    update<\/span> my_data\n    set<\/span> team='Atlanta'\n    where<\/span> team='A';\nquit<\/span> ;\n\n\/*view updated dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;<\/span><\/span><\/strong> <\/pre>\n
\"\"<\/p>\n
 \uc774\uc804\uc5d0 “A”\uc640 \uac19\uc558\ub358 \ud300 \uc5f4\uc758 \uac01 \uac12\uc740 \uc774\uc81c “Atlanta”\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
 \ud300 \uc5f4\uc5d0\uc11c “A”\uc640 \uac19\uc9c0 \uc54a\uc740 \ubaa8\ub4e0 \uac12\uc740 \ubcc0\uacbd\ub418\uc9c0 \uc54a\uace0 \uadf8\ub300\ub85c \uc720\uc9c0\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
 \uc608\uc2dc 2: \uc5ec\ub7ec \uc870\uac74\uc5d0 \ub530\ub77c \uc5f4\uc758 \uac12 \uc5c5\ub370\uc774\ud2b8<\/strong><\/span><\/h2>\n
 PROC SQL<\/strong> \uc5d0\uc11c \ub2e4\uc74c UPDATE<\/strong> \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc5ec\ub7ec \uc870\uac74\uc5d0 \ub530\ub77c \ud3ec\uc778\ud2b8 \uc5f4\uc758 \uac01 \uac12\uc744 \uc5c5\ub370\uc774\ud2b8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span> <\/p>\n
 \/*update values in points column based on multiple conditions*\/\nproc sql<\/span> ;\n    update<\/span> my_data\n    set<\/span> points = \n    case when points> 25<\/span> then 100<\/span>\n    when points> 20<\/span> then 50<\/span>\n    else 0<\/span>\n    end;\nquit<\/span> ;\n\n\/*view updated dataset*\/\n<\/span>proc print<\/span> data<\/span> =my_data;<\/span><\/span><\/strong> <\/pre>\n
\"\"<\/p>\n
 CASE WHEN<\/strong> \ubb38\uacfc \ud568\uaed8 UPDATE<\/strong> \ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud3ec\uc778\ud2b8 \uc5f4\uc758 \uac12\uc744 \uc5c5\ub370\uc774\ud2b8\ud588\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n
 \ud2b9\ud788:<\/span><\/p>\n