{"id":4578,"date":"2023-07-09T23:45:28","date_gmt":"2023-07-09T23:45:28","guid":{"rendered":"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/"},"modified":"2023-07-09T23:45:28","modified_gmt":"2023-07-09T23:45:28","slug":"sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/","title":{"rendered":"Sas\uff1a\u5982\u4f55\u5728 proc sql \u4e2d\u4f7f\u7528 order by"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">\u60a8\u53ef\u4ee5\u4f7f\u7528 SAS \u4e2d<strong>PROC SQL<\/strong>\u4e2d\u7684<b>ORDER BY<\/b>\u8bed\u53e5\u6839\u636e\u4e00\u4e2a\u6216\u591a\u4e2a\u53d8\u91cf\u7684\u503c\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002<\/span><\/p>\n<p><span style=\"color: #000000;\">\u4ee5\u4e0b\u662f\u5728\u5b9e\u8df5\u4e2d\u4f7f\u7528<strong>ORDER BY<\/strong>\u8bed\u53e5\u7684\u4e09\u79cd\u5e38\u89c1\u65b9\u6cd5\uff1a<\/span><\/p>\n<p><span style=\"color: #000000;\"><strong>\u65b9\u6cd5 1\uff1a\u6309\u9012\u589e\u53d8\u91cf\u6392\u5e8f<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by value in team column*\/<\/span>\nproc sql<\/span> <span style=\"color: #000000;\">;\n   <\/span><span style=\"color: #3366ff;\">select<\/span> <span style=\"color: #000000;\">*\n   <\/span><span style=\"color: #3366ff;\">from<\/span> <span style=\"color: #000000;\">my_data\n   <\/span><span style=\"color: #3366ff;\">order by<\/span> <span style=\"color: #000000;\">team<\/span> <span style=\"color: #000000;\">;\n<\/span><span style=\"color: #800080;\">quit<\/span> <span style=\"color: #000000;\">;<\/span><\/strong><\/span><\/pre>\n<p><span style=\"color: #000000;\"><strong>\u65b9\u6cd5 2\uff1a\u6309\u9012\u51cf\u53d8\u91cf\u6392\u5e8f<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in descending order by value in team column*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span><\/pre>\n<p><span style=\"color: #000000;\"><strong>\u65b9\u6cd53\uff1a\u6309\u591a\u4e2a\u53d8\u91cf\u6392\u5e8f<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by team, then descending order by points*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team, points <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span><\/pre>\n<p><span style=\"color: #000000;\">\u4ee5\u4e0b\u793a\u4f8b\u5c55\u793a\u4e86\u5982\u4f55\u5728 SAS \u4e2d\u7684\u4ee5\u4e0b\u6570\u636e\u96c6\uff08\u5305\u542b\u6709\u5173\u5404\u79cd\u7bee\u7403\u8fd0\u52a8\u5458\u7684\u4fe1\u606f\uff09\u7684\u5b9e\u8df5\u4e2d\u4f7f\u7528\u6bcf\u79cd\u65b9\u6cd5\uff1a<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008000;\">\/*create dataset*\/\n<\/span><span style=\"color: #800080;\">data<\/span> my_data;\n    <span style=\"color: #3366ff;\">input<\/span> team $position $points assists;\n    <span style=\"color: #3366ff;\">datalines<\/span> ;\nA Guard 14 4\nB Guard 22 6\nB Guard 24 9\nA Forward 13 8\nC Forward 13 9\nA Guard 10 5\nB Guard 24 4\nC Guard 22 6\nD Forward 34 2\nD Forward 15 5\nB Forward 23 5\nB Guard 10 4\n;\n<span style=\"color: #800080;\">run<\/span> ;\n\n<span style=\"color: #008000;\">\/*view dataset*\/\n<\/span><span style=\"color: #800080;\">proc print<\/span> <span style=\"color: #3366ff;\">data<\/span> =my_data;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35716 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par1.png\" alt=\"\" width=\"306\" height=\"349\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h2><strong>\u793a\u4f8b 1\uff1a<span style=\"color: #000000;\">\u6309\u9012\u589e\u53d8\u91cf\u6392\u5e8f<\/span><\/strong><\/h2>\n<p><span style=\"color: #000000;\">\u4ee5\u4e0b\u4ee3\u7801\u663e\u793a\u5982\u4f55\u6839\u636e<strong>\u56e2\u961f<\/strong>\u5217\u503c\u6309\u5347\u5e8f\u8fd4\u56de\u6570\u636e\u96c6\u4e2d\u7684\u6bcf\u4e00\u884c\uff1a<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by value in team column*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35717 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par2.png\" alt=\"\" width=\"260\" height=\"357\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p><span style=\"color: #000000;\">\u8bf7\u6ce8\u610f\uff0c\u7ed3\u679c\u6309<strong>Team<\/strong>\u5217\u4e2d\u7684\u503c\u5347\u5e8f\u663e\u793a\u3002<\/span><\/p>\n<h2><strong>\u793a\u4f8b 2\uff1a<span style=\"color: #000000;\">\u6309\u9012\u51cf\u53d8\u91cf\u6392\u5e8f<\/span><\/strong><\/h2>\n<p><span style=\"color: #000000;\">\u4ee5\u4e0b\u4ee3\u7801\u663e\u793a\u5982\u4f55\u6839\u636e<strong>\u56e2\u961f<\/strong>\u5217\u503c\u6309\u964d\u5e8f\u8fd4\u56de\u6570\u636e\u96c6\u4e2d\u7684\u6bcf\u4e00\u884c\uff1a<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in descending order by value in team column*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35718 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par3.png\" alt=\"\" width=\"261\" height=\"365\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p><span style=\"color: #000000;\">\u8bf7\u6ce8\u610f\uff0c\u7ed3\u679c\u6839\u636e<strong>Team<\/strong>\u5217\u4e2d\u7684\u503c\u6309\u964d\u5e8f\u663e\u793a\u3002<\/span><\/p>\n<h2><strong>\u793a\u4f8b 3\uff1a<span style=\"color: #000000;\">\u6309\u591a\u4e2a\u53d8\u91cf\u6392\u5e8f<\/span><\/strong><\/h2>\n<p><span style=\"color: #000000;\">\u4ee5\u4e0b\u4ee3\u7801\u663e\u793a\u5982\u4f55\u9996\u5148\u6309<strong>\u56e2\u961f<\/strong>\u5347\u5e8f\u8fd4\u56de\u6570\u636e\u96c6\u4e2d\u7684\u6bcf\u4e00\u884c\uff0c\u7136\u540e\u6309<strong>\u70b9\u6570<\/strong>\u964d\u5e8f\u8fd4\u56de\uff1a<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #800080;\"><span style=\"color: #008000;\">\/*display results in ascending order by team, then descending order by points*\/<\/span>\nproc sql<\/span> ;\n   <span style=\"color: #3366ff;\">select<\/span> *\n   <span style=\"color: #3366ff;\">from<\/span> my_data\n   <span style=\"color: #3366ff;\">order by<\/span> team, points <span style=\"color: #3366ff;\">desc<\/span> ;\n<span style=\"color: #800080;\">quit<\/span> ;<\/strong><\/span> <\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-35719 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par4.png\" alt=\"\" width=\"247\" height=\"340\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p><span style=\"color: #000000;\">\u8bf7\u6ce8\u610f\uff0c\u7ed3\u679c\u9996\u5148\u6309<strong>\u7403\u961f<\/strong>\u5347\u5e8f\u663e\u793a\uff0c\u7136\u540e\u6309<strong>\u5206\u6570<\/strong>\u964d\u5e8f\u663e\u793a\u3002<\/span><\/p>\n<h2><span style=\"color: #000000;\"><strong>\u5176\u4ed6\u8d44\u6e90<\/strong><\/span><\/h2>\n<p><span style=\"color: #000000;\">\u4ee5\u4e0b\u6559\u7a0b\u89e3\u91ca\u4e86\u5982\u4f55\u5728 SAS \u4e2d\u6267\u884c\u5176\u4ed6\u5e38\u89c1\u4efb\u52a1\uff1a<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/cn\/sas-proc-sql-\u8054\u5408\/\" target=\"_blank\" rel=\"noopener\">SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 UNION<\/a><br \/> <a href=\"https:\/\/statorials.org\/cn\/sas-proc-sql-\u9664\u5916\/\" target=\"_blank\" rel=\"noopener\">SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 EXCEPT<\/a><br \/> <a href=\"https:\/\/statorials.org\/cn\/sas-proc-sql-in-\u4e2d\/\" target=\"_blank\" rel=\"noopener\">SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 IN \u8fd0\u7b97\u7b26<\/a><br \/><a href=\"https:\/\/statorials.org\/cn\/sas-proc-sql-\u6216\/\" target=\"_blank\" rel=\"noopener\">SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 WHERE \u8fd0\u7b97\u7b26<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u60a8\u53ef\u4ee5\u4f7f\u7528 SAS \u4e2dPROC SQL\u4e2d\u7684ORDER BY\u8bed\u53e5\u6839\u636e\u4e00\u4e2a\u6216\u591a\u4e2a\u53d8\u91cf\u7684\u503c\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002 \u4ee5\u4e0b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4578","post","type-post","status-publish","format-standard","hentry","category-11"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY - Statorials<\/title>\n<meta name=\"description\" content=\"\u672c\u6559\u7a0b\u901a\u8fc7\u51e0\u4e2a\u793a\u4f8b\u8bf4\u660e\u5982\u4f55\u5728 SAS \u7684 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY \u8bed\u53e5\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/cn\/sas-proc-sql-\u6392\u5e8f\u4f9d\u636e\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY - Statorials\" \/>\n<meta property=\"og:description\" content=\"\u672c\u6559\u7a0b\u901a\u8fc7\u51e0\u4e2a\u793a\u4f8b\u8bf4\u660e\u5982\u4f55\u5728 SAS \u7684 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY \u8bed\u53e5\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/cn\/sas-proc-sql-\u6392\u5e8f\u4f9d\u636e\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-09T23:45:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par1.png\" \/>\n<meta name=\"author\" content=\"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/\",\"url\":\"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/\",\"name\":\"SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/cn\/#website\"},\"datePublished\":\"2023-07-09T23:45:28+00:00\",\"dateModified\":\"2023-07-09T23:45:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/cn\/#\/schema\/person\/124e4e5b7c9f8dc0f1f95cc8c1db3261\"},\"description\":\"\u672c\u6559\u7a0b\u901a\u8fc7\u51e0\u4e2a\u793a\u4f8b\u8bf4\u660e\u5982\u4f55\u5728 SAS \u7684 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY \u8bed\u53e5\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u5bb6\",\"item\":\"https:\/\/statorials.org\/cn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sas\uff1a\u5982\u4f55\u5728 proc sql \u4e2d\u4f7f\u7528 order by\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/cn\/#website\",\"url\":\"https:\/\/statorials.org\/cn\/\",\"name\":\"Statorials\",\"description\":\"\u60a8\u7684\u7edf\u8ba1\u7d20\u517b\u6307\u5357\uff01\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/cn\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/cn\/#\/schema\/person\/124e4e5b7c9f8dc0f1f95cc8c1db3261\",\"name\":\"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/statorials.org\/cn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/statorials.org\/cn\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"https:\/\/statorials.org\/cn\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a\"},\"description\":\"\u5927\u5bb6\u597d\uff0c\u6211\u662f\u672c\u6770\u660e\uff0c\u4e00\u4f4d\u9000\u4f11\u7684\u7edf\u8ba1\u5b66\u6559\u6388\uff0c\u540e\u6765\u6210\u4e3a Statorials \u7684\u70ed\u5fc3\u6559\u5e08\u3002 \u51ed\u501f\u5728\u7edf\u8ba1\u9886\u57df\u7684\u4e30\u5bcc\u7ecf\u9a8c\u548c\u4e13\u4e1a\u77e5\u8bc6\uff0c\u6211\u6e34\u671b\u5206\u4eab\u6211\u7684\u77e5\u8bc6\uff0c\u901a\u8fc7 Statorials \u589e\u5f3a\u5b66\u751f\u7684\u80fd\u529b\u3002\u4e86\u89e3\u66f4\u591a\",\"sameAs\":[\"https:\/\/statorials.org\/cn\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY - Statorials","description":"\u672c\u6559\u7a0b\u901a\u8fc7\u51e0\u4e2a\u793a\u4f8b\u8bf4\u660e\u5982\u4f55\u5728 SAS \u7684 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY \u8bed\u53e5\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/cn\/sas-proc-sql-\u6392\u5e8f\u4f9d\u636e\/","og_locale":"zh_CN","og_type":"article","og_title":"SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY - Statorials","og_description":"\u672c\u6559\u7a0b\u901a\u8fc7\u51e0\u4e2a\u793a\u4f8b\u8bf4\u660e\u5982\u4f55\u5728 SAS \u7684 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY \u8bed\u53e5\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002","og_url":"https:\/\/statorials.org\/cn\/sas-proc-sql-\u6392\u5e8f\u4f9d\u636e\/","og_site_name":"Statorials","article_published_time":"2023-07-09T23:45:28+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/commande-par1.png"}],"author":"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/","url":"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/","name":"SAS\uff1a\u5982\u4f55\u5728 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/cn\/#website"},"datePublished":"2023-07-09T23:45:28+00:00","dateModified":"2023-07-09T23:45:28+00:00","author":{"@id":"https:\/\/statorials.org\/cn\/#\/schema\/person\/124e4e5b7c9f8dc0f1f95cc8c1db3261"},"description":"\u672c\u6559\u7a0b\u901a\u8fc7\u51e0\u4e2a\u793a\u4f8b\u8bf4\u660e\u5982\u4f55\u5728 SAS \u7684 PROC SQL \u4e2d\u4f7f\u7528 ORDER BY \u8bed\u53e5\u5bf9\u67e5\u8be2\u7ed3\u679c\u8fdb\u884c\u6392\u5e8f\u3002","breadcrumb":{"@id":"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/cn\/sas-proc-sql-%e6%8e%92%e5%ba%8f%e4%be%9d%e6%8d%ae\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u5bb6","item":"https:\/\/statorials.org\/cn\/"},{"@type":"ListItem","position":2,"name":"Sas\uff1a\u5982\u4f55\u5728 proc sql \u4e2d\u4f7f\u7528 order by"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/cn\/#website","url":"https:\/\/statorials.org\/cn\/","name":"Statorials","description":"\u60a8\u7684\u7edf\u8ba1\u7d20\u517b\u6307\u5357\uff01","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/cn\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/statorials.org\/cn\/#\/schema\/person\/124e4e5b7c9f8dc0f1f95cc8c1db3261","name":"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/statorials.org\/cn\/#\/schema\/person\/image\/","url":"https:\/\/statorials.org\/cn\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"https:\/\/statorials.org\/cn\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"\u672c\u6770\u660e\u00b7\u5b89\u5fb7\u68ee\u535a"},"description":"\u5927\u5bb6\u597d\uff0c\u6211\u662f\u672c\u6770\u660e\uff0c\u4e00\u4f4d\u9000\u4f11\u7684\u7edf\u8ba1\u5b66\u6559\u6388\uff0c\u540e\u6765\u6210\u4e3a Statorials \u7684\u70ed\u5fc3\u6559\u5e08\u3002 \u51ed\u501f\u5728\u7edf\u8ba1\u9886\u57df\u7684\u4e30\u5bcc\u7ecf\u9a8c\u548c\u4e13\u4e1a\u77e5\u8bc6\uff0c\u6211\u6e34\u671b\u5206\u4eab\u6211\u7684\u77e5\u8bc6\uff0c\u901a\u8fc7 Statorials \u589e\u5f3a\u5b66\u751f\u7684\u80fd\u529b\u3002\u4e86\u89e3\u66f4\u591a","sameAs":["https:\/\/statorials.org\/cn"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/posts\/4578","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/comments?post=4578"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/posts\/4578\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/media?parent=4578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/categories?post=4578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/cn\/wp-json\/wp\/v2\/tags?post=4578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}