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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.