BookmarkSubscribeRSS Feed
Calcite | Level 5


I would like my data to be stored in an imlstore that I have provided the link for:

libname sqldb ODBC dsn='sqlBLS' schema=IO2012;

libname imlstore 'C:\Users\hze1\Desktop\SAS\BLSData';

/*Read in 177x177 transaction matrix and 1x177 value added row*/

data Zmatrix;set sqldb.nominaluse_FMB_2012;

if FMBcom ne 196;/*FMBcom 196 is value added*/

drop c196;/*c196 is final demand*/

proc sort;by stat_year FMBcom;


data Zcom; set Zmatrix ;

keep stat_year fmbcom;



data Zmatrix and Zcom are storing in work directory which is different from the imlstore directory.

I realized that if I use imlstore.Zmatrix will go to my imlstore directory, is there any way to skip the imlstore.Zmatrix and jsut use the Zmatrix and have the data at imlstore.

Thank you

Super User


Check out the user= system option.

It allows you to specify that datasets with one-level names be written to a permanent directoy instead of work, e.g.:

297  options user="d:\junk";
298  data x; x=1;run;
NOTE: The data set USER.X has 1 observations and 1 variables.


BASUG is hosting free webinars Next up: Don Henderson presenting on using hash functions (not hash tables!) to segment data on June 12. Register now at the Boston Area SAS Users Group event page:


Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2 in conversation