[SOLVED] How to refer to or paste datasets into datalines in WPS (SAS)?

How to refer to or paste datasets into datalines in WPS (SAS)?

I am trying to learn SAS coding through WPS Workbench. I am confused about how if I have datasets e.g. height of humans, already, how do I refer or use these datasets in my code so I can begin to analyse it? Right now they are in separate windows (editor and dataset SAS7BDAT file). Sorry if this sounds confusing. I am quite confused.

Solution

Create a libref that points to the directory that contains the SAS7BDAT file(s). You can use any valid 8 character or less SAS name for your libref.

Then just reference the dataset using a two level dataset reference. Before the period is the libref you defined in the LIBNAME statement and after the period is the dataset (or member) name. That name should match the base name of the file with the SAS7BDAT extension.

So to run PROC MEANS on a file named c:\myfiles\mydata.sas7bdat you could use code like:

libname mydat 'c:\myfiles';
proc means data=mydat.mydata;
run;

This syntax works in real SAS and I assume that WPS will also support such simple code.