{"id":11826,"date":"2018-03-28T05:53:49","date_gmt":"2018-03-28T00:23:49","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=11826"},"modified":"2021-05-09T13:16:39","modified_gmt":"2021-05-09T07:46:39","slug":"splitting-and-subsetting-datasets-in-sas","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/","title":{"rendered":"Splitting and Subsetting Datasets in SAS – A Brief Guide of 7 Mins!"},"content":{"rendered":"

Now, we will be learning how we can extract some part of our dataset for our use by using statements like IF, WHERE, DROP and KEEP.<\/p>\n

These statements when applied to the dataset, help us extract variables and observations of our interest only. Here, we will study what is subsetting datasets in SAS, SAS split dataset by variable and SAS split dataset by observations; SAS subsetting WHERE statement &\u00a0IF Statement.<\/p>\n

Subsetting Datasets in SAS<\/h2>\n

We come across different types of datasets in SAS<\/strong> and many times we would want to have only a part of the dataset that may be useful. Let’s say we want dates after 1\/04\/2011 only, all dates before this are not of our interest.<\/p>\n

Then, the feature, subsetting datasets in SAS, helps us extract only that data which is relevant to us, thereby improving our analysis. Subsetting can be achieved by extracting either columns or rows(observations) of our choice.<\/p>\n

SAS Subsetting Variables<\/h3>\n

You can create a new dataset with only a subset of the\u00a0variables\u00a0<\/strong>in the original dataset using a\u00a0keep\u00a0or\u00a0drop\u00a0statement.<\/p>\n

\"Subsetting<\/a><\/p>\n

Suppose you want to print just three of the variables in this data set: study id, age, and height.<\/p>\n

data\u00a0one;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 input\u00a0studyid name $ sex $ age weight height;\r\ncards;\r\n1\u00a0    \u00a0Carol\u00a0    \u00a0f\u00a0  \u00a022\u00a0    120\u00a0 \u00a0 64\r\n6\u00a0 \u00a0 \u00a0 Julie\u00a0 \u00a0   f\u00a0 \u00a0\u00a055\u00a0 \u00a0  125\u00a0 \u00a0 63\r\n2\u00a0 \u00a0   Joe\u00a0 \u00a0 \u00a0 \u00a0 m    34     130    68\r\n7\u00a0 \u00a0   Kelsey\u00a0 \u00a0 \u00a0f    43     130    64\r\n4\u00a0     Ann\u00a0 \u00a0 \u00a0 \u00a0 f    29     .      65\r\n11\u00a0 \u00a0  Tracee\u00a0 \u00a0 \u00a0f    21     110     .\r\n9\u00a0 \u00a0   Bob\u00a0 \u00a0 \u00a0 \u00a0 m    32     155    71\r\n3\u00a0 \u00a0   Ed\u00a0 \u00a0 \u00a0 \u00a0 \u00a0m    40     120    69\r\n8\u00a0 \u00a0 \u00a0 Karl\u00a0 \u00a0 \u00a0 \u00a0m    35     160    68\r\n10\u00a0 \u00a0 \u00a0Gayla\u00a0 \u00a0 \u00a0 f    40     130    68\r\n5\u00a0 \u00a0   John\u00a0 \u00a0 \u00a0 \u00a0m    17     175    73\r\nrun;<\/pre>\n
i. Using ‘var’<\/h4>\n
You can do this by specifying the variables in the\u00a0VAR\u00a0statement in proc print.<\/p>\n
proc print\u00a0data=one;\r\n\u00a0\u00a0 var\u00a0studyid age height;\r\nrun;<\/pre>\n
ii. Using\u00a0‘keep’<\/h4>\n
Another way to do this is to use a\u00a0keep\u00a0statement to create a new dataset only with the selected variables.<\/p>\n
data\u00a0two;\r\nset\u00a0one;\r\nkeep\u00a0studyid age height;\r\nproc print;\r\nrun;<\/pre>\n
iii. Using\u00a0‘drop’<\/h4>\n
Yet another way to do this is to use a drop statement to drop the other variables from your new data set.<\/p>\n
data\u00a0three;\r\nset\u00a0one;\r\ndrop\u00a0name sex weight;\r\nproc print;\r\nrun;<\/pre>\n
These will all produce the same output:<\/p>\n
\"Output<\/a><\/p>\n
SAS Subsetting Observations<\/h3>\n
You can create a new dataset with only a subset of the\u00a0observations\u00a0<\/strong>in the original data set using an\u00a0IF\u00a0or\u00a0WHERE\u00a0statement.<\/p>\n
To create a new data set that only includes a subset of observations from an existing data set, use a\u00a0SET statement along with a subsetting\u00a0IF statement.<\/p>\n
The\u00a0SET statement creates a duplicate of the original data step and the\u00a0IF statement selects only the observations that meet the\u00a0IF statement requirement.<\/p>\n
The\u00a0WHERE statement can be used similarly in a data step.<\/p>\n
\"Subsetting<\/a><\/p>\n
i. Using IF Statement<\/h4>\n
Example:-<\/strong><\/p>\n
There is a data set called abc, assume it is a SAS data set with 76 boys and 48 girls.<\/p>\n
First, we will select only girls, i.e., those with sex=2<\/p>\n
data\u00a0abc;\r\n\u00a0\u00a0\u00a0 set\u00a0pbkid;\r\n\u00a0\u00a0\u00a0\u00a0 if\u00a0sex=2;\r\nrun;\r\nproc means\u00a0data=abc;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 var\u00a0iq;\r\nrun;<\/pre>\n
\"Output<\/a><\/p>\n
Next, we will select only boys, those with sex=1, using a WHERE statement, and produce their mean IQ score:<\/p>\n
data\u00a0abc;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 set\u00a0pbkid;\r\n\u00a0\u00a0\u00a0\u00a0 where\u00a0sex=1;\r\nrun;\r\nproc means\u00a0data=abc;\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var\u00a0iq;\r\nrun;<\/pre>\n
\"Output<\/a><\/p>\n
ii. Using WHERE Statement<\/h4>\n
In the above example, to produce statistics on a subset of our observations only, we created a subset dataset using an\u00a0IF (or\u00a0WHERE) statement in the data step and then applied the proc.<\/p>\n
Similarly, we can use a\u00a0where\u00a0statement directly in the proc as shown below:<\/p>\n
proc means\u00a0data=abc;\r\nvar\u00a0iq;\r\nwhere sex =\u00a01;\r\ntitle1\u00a0'MALE (1) IQ SCORES';\r\nrun;\r\nproc means\u00a0data=abc;\r\nvar\u00a0iq;\r\nwhere sex=2;\r\ntitle1\u00a0'FEMALE (2) IQ SCORES';\r\nrun;<\/pre>\n
Summary<\/h2>\n
We learned the subsetting datasets in SAS, statements that can be used to extract variables of our interest and statements that can be used to extract observations of our interest. Hope you understood it clearly.<\/p>\n
If you have any queries related to the tutorial, feel free to ask in the comment section below. Awaiting for your reply!<\/p>\n","protected":false},"excerpt":{"rendered":"
Now, we will be learning how we can extract some part of our dataset for our use by using statements like IF, WHERE, DROP and KEEP. These statements when applied to the dataset, help...<\/p>\n","protected":false},"author":6,"featured_media":11968,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[12281,12282,13203,13963],"class_list":["post-11826","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sas","tag-sas-subsetting-observations","tag-sas-subsetting-variables","tag-splitting-datasets-in-sas","tag-subsetting-datasets-in-sas"],"yoast_head":"\nSplitting and Subsetting Datasets in SAS - A Brief Guide of 7 Mins! - DataFlair<\/title>\n<meta name=\"description\" content=\"Splitting and Subsetting Datasets in SAS tutorial covers SAS Subsetting variables and SAS Subsetting observation using different statements. Check for free!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Splitting and Subsetting Datasets in SAS - A Brief Guide of 7 Mins! - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Splitting and Subsetting Datasets in SAS tutorial covers SAS Subsetting variables and SAS Subsetting observation using different statements. Check for free!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-28T00:23:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:46:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sub-setting-datasets-in-SAS-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Splitting and Subsetting Datasets in SAS - A Brief Guide of 7 Mins! - DataFlair","description":"Splitting and Subsetting Datasets in SAS tutorial covers SAS Subsetting variables and SAS Subsetting observation using different statements. Check for free!","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:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/","og_locale":"en_US","og_type":"article","og_title":"Splitting and Subsetting Datasets in SAS - A Brief Guide of 7 Mins! - DataFlair","og_description":"Splitting and Subsetting Datasets in SAS tutorial covers SAS Subsetting variables and SAS Subsetting observation using different statements. Check for free!","og_url":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-28T00:23:49+00:00","article_modified_time":"2021-05-09T07:46:39+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sub-setting-datasets-in-SAS-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Splitting and Subsetting Datasets in SAS – A Brief Guide of 7 Mins!","datePublished":"2018-03-28T00:23:49+00:00","dateModified":"2021-05-09T07:46:39+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/"},"wordCount":541,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sub-setting-datasets-in-SAS-01.jpg","keywords":["SAS Subsetting Observations","SAS Subsetting Variables","Splitting Datasets in SAS","Subsetting Datasets in SAS"],"articleSection":["SAS Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/","url":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/","name":"Splitting and Subsetting Datasets in SAS - A Brief Guide of 7 Mins! - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sub-setting-datasets-in-SAS-01.jpg","datePublished":"2018-03-28T00:23:49+00:00","dateModified":"2021-05-09T07:46:39+00:00","description":"Splitting and Subsetting Datasets in SAS tutorial covers SAS Subsetting variables and SAS Subsetting observation using different statements. Check for free!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sub-setting-datasets-in-SAS-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Sub-setting-datasets-in-SAS-01.jpg","width":1200,"height":628,"caption":"Subsetting Datasets in SAS"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/splitting-and-subsetting-datasets-in-sas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sas\/"},{"@type":"ListItem","position":3,"name":"Splitting and Subsetting Datasets in SAS – A Brief Guide of 7 Mins!"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=11826"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11826\/revisions"}],"predecessor-version":[{"id":93363,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11826\/revisions\/93363"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/11968"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=11826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=11826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=11826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}