Thanks Reeza! no, x command is not enable yet. I am in process with admin to make it enable and waiting for same. I am assuming we have to edit objectspawner.bat file with           - allowxcmd command. but what is alternative if admin answer is no. can we still do samething? ... View more

never mind- i found it - have to edit "objectspawner.bat" file Thanks all! ... View more

Which file or files need to be updated in order to provide -allowxcmd command - i think have to do that... Thanks! ... View more

i cannot do following since i am using 9.1 and i think following task is not available in 9.1 - i think have to edit config file... Expand Server Manager -> SASAPP - > SASAPP - Logical Workspace Server . Right click on SASAPP - Workspace Server. Go to Options Tab -> Advanced Options -> Launch Properties - > Check Allow XCMD. ... View more

yes Tom - one semicolon was missing. but now i am getting error message saying that "insufficient authorization to access pipe. However, i have got your point so far in your code logic. have quick question - can you please enter comment to explain two line i mention below from your code...really appreciate your time....!!!   cmd = catx(' ',"copy &source"||file,dir);   infile cmd pipe filevar=cmd ; Thanks! ... View more

Hi Tom - i have created same test scenario in my environment as you suggested above and run only following code for test but i am getting an error message saying that "Statement is not valid or it is used out of proper order" at below ares. %let source=F:\ ; %let control_file=MASTER.USERS ; data files ;    /*"Statement is not valid or it is used out of proper order.*/   infile "dir /b &source\*.mdb" pipe ;    /*"Statement is not valid or it is used out of proper order.*/   length username $32 file $256 ;    /*"Statement is not valid or it is used out of proper order.*/   input ;   /*"Statement is not valid or it is used out of proper order.*/   file = _infile_;   /*"Statement is not valid or it is used out of proper order.*/   username = upcase(scan(file,1,'_')); run; proc sort data=files;   /*work.files,data doesn't exist.*/   by username; run; ... View more

Hi guys - i think i can do this and it will run query fast from bigger data.... proc dataset library=woo;        modify=test /*dataset*/;        index create age;        index create sex; quit; data xyz;     set test;     where age=20 or 50 and sex='m'; run; Thanks!!! ... View more

I am sorry Reeza i am new at SAS so sometime i don't know how to explain it...BUT i want get records for any null value in variable and then create index for that variable... thanks! ... View more

Thanks a lot Tom!!! ... View more

Thanks for your time Tom and sorry if you find question is not clear...BUT i want to copy actual mdb files created in'f:\woo to different share drives where they belongs, like Tom_db1.mdb file goes to "\\ny\shares" and Chris_db2.mdb files goes to "\\oh\shares")... /*i think we can avoid use of control table- but not sure*/ /*for me issue is we don't know how many mdb files will be created each wk but those mdb files creates according to the control table, whatever number of username are there - mdb files will be created - so lets say one wk - there are 20 mdb files created and for next week 45 mdb files will be created but all these mdb files need to be copied to appropriate share location/where it belongs to - and that is why i thought we can use control table to direct mdb files to appropriate location*/ if we don't use control table then i am thinking like, /*define path according to "location" variable from control table*/ %let ny=\\ny\shares %let oh=\\oh\shares %let va=\\va\shares /*then show something like that - just a thought */ if Tom_db1.mdb exist in folder "f:\woo" then copy "f:\woo\Tom_db1.mdb" to "&ny" if Chris_db2.mdb exist in folder "f:\woo" then copy "f:\woo\Chris_db2.mdb" to "&oh" Thanks Tom! ... View more

i don't know if we can embed control EG table with path somehow OR logic would be, if Tom_db1.mdb exist in "f:\woo" then copy f:\woo\Tom_db1.mdb to \\ny\shares if Chris_db2.mdb exist in "f:\woo" then copy f:\woo\Chris_db2.mdb to \\oh\shares if woo_db3.mdb exist in "f:\woo" then copy f:\woo\woo.mdb to \\va\shares Thanks! ... View more

Hi Tom - i think yes BUT, /*we have "username" (Tom, Chris, Woo) and "location" (NY, OH, VA) variables in control table*/ /*we don't have path in control table for users */ /*for NY we have path //ny/shares*/  *let's say TOM; /*for OH we have path //oh/shares*/  *for Chris; /*for VA we have path //va/shares*/   *for Woo; so we have to match username from control table and associated share drives that we mention in code... also -  we have like more than 10 mdb created for different share drives... Thanks Tom! ... View more

thanks for sharing it Chris - love it. i read out almost all different issue on follow up. But there are two things - Firstly - i am not sure how this will work for me because i have multiple mdb files and wants to copy to different share drive according to the "username" and "location"                 variables from EG table/dataset...i don't know how i can use this to write some macro or data/proc steps code... Secondly - "download copy file task" not allowed to install/download due to company policy - which is not your problem ...and i cannot change it 🙂 Let's see if someone can help me to build code... Thanks Again Chris... ... View more