After running following code, the defaulted work directory changed to
"user".
how can I change back it to "work" again?
Thanks.
Jeff
OPTIONS NONOTES NOSOURCE NOSOURCE2;
*option mprint mlogic symbolgen;
%let dir=M:\Users\JP\PM\PM_RF;
%let datasetdir=M:\Users\JP\PM\Participation Study;
%let testids=51,52,53;
%let client = ABB;
%let Period=RF;
%let SvcMths=2;
libname orig "&datasetdir.\datasets";
libname user "&dir.\userInputs";
*libname ret 'N:\PM\Participation Study\Results';
*libname extn odbc uid=&SYSUSERID dsn=mhcdatawh_dev schema=dbo
readbuff=5000;
*
proc* *datasets* lib=user kill;
*
run*;
*
proc* *datasets* lib=work kill;
*
run*;
/*Open definition file*/
options noxwait noxsync;
x '"C:\Program Files\Microsoft Office\Office12\excel.exe"';
*
data* _null_;
x=sleep(*5*);
*
run*;
*;
/* open Excel workbook */
/*"N:\PM\PM_RF\CSVs\definitionT.csv" */
*;
filename ddecmd dde 'excel|system';
*
data* _null_;
file ddecmd;
put "[FILE-OPEN(""&dir.\CSVs\definition.xls"")]";
*
run*;
*;
/* specify desired Excel worksheet cell range */
*;
filename xlin DDE "excel|&dir.\CSVs\[definition.xls]definition!r2c1:r500c3";
*
run*;
*;
/* read Excel files using DDE into SAS data set*/
*;
*
data* user.rfs_labels_all;
infile xlin dlm='09'x notab missover dsd;
informat id *8.* type $20. label $200.;
input id type label;
format id *8.* type $8. label $200.;
*
run*;
*;
/* close Excel workbook and close Excel */
*
data* _null_;
file ddecmd;
put "[FILE-CLOSE(""&dir.\CSVs\definition.xls"")]";
put '[QUIT()]';
*
run*;
/*********************************************
*********************************************
*********************************************/
/*Open codesetmap excel file*/
x '"C:\Program Files\Microsoft Office\Office12\excel.exe"';
*
data* _null_;
x=sleep(*5*);
*
run*;
*;
/* open Excel workbook */
/*"N:\PM\PM_RF\CSVs\definitionT.csv" */
*;
filename ddecmd dde 'excel|system';
*
data* _null_;
file ddecmd;
put "[FILE-OPEN(""&dir.\CSVs\codemap.xls"")]";
*
run*;
*;
/* specify desired Excel worksheet cell range */
*;
filename xlin DDE "excel|&dir.\CSVs\[codemap.xls]codemap!r2c1:r3000c4";
*
run*;
*;
/* read Excel files using DDE into SAS data set*/
*;
*
data* user.codesetmaps_all;
infile xlin dlm='09'x notab missover dsd;
informat id *8.* codesetvalue $20. codeid *8.* codetypecd *8.*;
input id codesetvalue codeid codetypecd;
format id *8.* codesetvalue $20. codeid *8.* codetypecd *8.* ;
*
run*;
*;
/* close Excel workbook and close Excel */
*
data* _null_;
file ddecmd;
put "[FILE-CLOSE(""&dir.\CSVs\codemap.xls"")]";
put '[QUIT()]';
*
run*;
/*For program test and debug*/
*
data* user.rfs_labels (where=(id in (&testids.))); *(where=(id^=.));*;
set user.rfs_labels_all;
*
run*;
*
data* user.codesetmaps (where=(id in (&testids.)));* (where=(id^=.));*;
set user.codesetmaps_all;
*
run*;
/*
proc import out=user.ClaimHitsDriver
datafile = "N:\HI_Analytics\Projects\NCQA_DM_Test\NCQA
Codes\HEDISHitsDriver.txt"
dbms=tab replace; getnames=yes;
run;
proc sql;
create table work.HitsDriver as
select distinct CodeTypeCd, ColumnName1, ColumnName2, ColumnName3
from user.ClaimHitsDriver;
quit;
*/
*
%macro*