Copy excel workbook to new folder in Unix using SAS -

-

i attempting copy excel workbook 1 directory using sas code. have found many suggestions online, none seem work me. folders these files saved in windows folders, our sas server unix server path names must translated. need use macro in destination folder , path names have spaces in between names.

so far simplified paths without spaces or macros , have tried:

data _null_; rc=system('copy /sasdata/win_shares/corpfs01/global/data/evicore/test/workbook.xlsx /sasdata/win_shares/corpfs01/global/data/evicore/test2/workbook.xlsx'); put rc; run;

and 

x 'copy '/sasdata/win_shares/corpfs01/global/data/evicore/test/workbook.xlsx' '/sasdata/win_shares/corpfs01/global/data/evicore/test2/test2'';

where /sasdata/win_shares/corpfs01/global/ path connects our windows r: drive.

i have tried various versions of these codes adding , deleting quotation marks around path names, none seem work. top code giving me return code of 127, if helpful.

get command work unix shell first. note unix command copy files cp , not copy. if filenames include embedded spaces need add quotes shell knows space part of filename.

cp \  "/sasdata/win_shares/corpfs01/global/data/evicore/test/workbook.xlsx" \  "/sasdata/win_shares/corpfs01/global/data/evicore/test2/workbook.xlsx"

then try implement using sas code. when running commands sas helps run them using data step , pipe engine on infile statement. can read response os might send using input statement.

data _null_;   infile  'cp  "/sasdata/win_shares/corpfs01/global/data/evicore/test/workbook.xlsx"  "/sasdata/win_shares/corpfs01/global/data/evicore/test2/workbook.xlsx" ' pipe;   input;   put _infile_; run;

or in case since copying between sub directory of common root node make code shorter issue 2 unix commands. can use semi-colon ; separate them.

data _null_;   infile  'cd "/sasdata/win_shares/corpfs01/global/data/evicore" ;cp "test/workbook.xlsx" "test2/workbook.xlsx" ' pipe;   input;   put _infile_; run;

Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more