Hi,
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;
run;
data Zcom; set Zmatrix ;
keep stat_year fmbcom;
run;
=======================
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
Hi,
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.
--Q.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.