Create a SAS dataset

tasha89tp — Mon, 12 Dec 2016 04:05:19 GMT

So, I imported the file:

PROC IMPORT DATAFILE = 'C:\Users\...xlsx' DBMS = XLSX OUT = general

I need to make two datasets from general (gss1 and gss2) both consisting of 8 variables when general has 20.

How do you create a dataset with certain variables from an excel file after you proc import datafile?

Re: Create a SAS dataset

Reeza — Mon, 12 Dec 2016 04:39:43 GMT

You use the KEEP statement.

See below where two datasets are created, one with Name/Age/Sex and second with Name/Weight/Height.

When you create the datasets, it's likely you'll want a common variable between the two so you can map back to records if required.

data class1;
set sashelp.class;

keep name age sex;
run;

data class2;
set sashelp.class;
keep name weight height;
run;