Hello! I$\text{'}$m very beginner in SAS and need help to load and create data set in program. I$\text{'}$m working in SAS OnDemand for Academics. So I have big file in xls and in cvs formats, loaded in my SAS files folder. So my codes

$*$Reading data in;

Proc import datafile $=\text{'}/$home$/$XXXXXXXXXX$.$csv$\text{'}$

out$=$mydata dbms$=$csv replace;

getnames$=$no;

run;

$*$print the data to the screen to see if they are okay;

proc print data$=$ mydata;

run;

and what I got :

SAS ${?}^{o+}$ Studio

SAS Programmer

Sign Out

Server Files and Folders

Tasks and Utilities

Snippets

Libraries

$$ My Libraries

File Shortcuts

CODE LOG RESULTS OUTPUT DATA

Table: WORK.MYDATA grad$|$ View: Column names grad $$ S$5|$ Filter: $($none$)$

$\backslash$table$[[$Columns$,,$Total rows: $3110$ Total columns: $65,,$Rows $1-100,\backslash$table$[[=>1$

now I need to create new data set by sorting only specific states and variables.

Could you help me with codes and how to save my new data set?

Thank you!