H,i
i am running EG SAS remotly and i want to import/export files from /to my PC . How do i do that?
i found something online:
proc export data=work.temp outfile='Y:\WCR\test.xlsx' dbms=accesscs port=.. server=myserver;
but how do i find which port i need to use and also myserver would be the windows server right? Can i get that info from my system.
Please anyone
thx
It sounds like with EG in a server set up. This means that SAS is no longer on your computer and ALL programs are essentially 'rsubmit' to the server by default. You MAY have the option to run locally, if so you'll see a drop down to switch beside the RUN button that allows you to specify where your process is working. You can only work locally or on the server and not back and forth like you may have previously done.
You need to upload your Excel files to a server location and then use PROC IMPORT with the files on the server OR use the point and click interface to import the files into your programs. It does make it hard to streamline processes. If you had access to X command or DDE those are likely gone as well. If your'e using the newest EG version, the copy files task should be installed to move your files onto the server.
You're better off asking a colleague for instructions because set ups vary so you need to know how your system is set up.
In general, you should be able to use the GUI import/export in EG.
If you want to do it using a program you should upload/move the excel file to the server first, because the server won't see your local drive. Unless you're running EG locally, but i suspect you're on a server.
thanks Reeza for the answer
All my co workers are using and been using pc sas and now we are all switching to EG and none of us has a clue how to get import and export files from and back to PC
So anyhting like signon/resubmit.... wont work here the way it works when u accessing unix from pc remotly?
Thsi might be a silly question but i dont have much knowledge about it
It sounds like with EG in a server set up. This means that SAS is no longer on your computer and ALL programs are essentially 'rsubmit' to the server by default. You MAY have the option to run locally, if so you'll see a drop down to switch beside the RUN button that allows you to specify where your process is working. You can only work locally or on the server and not back and forth like you may have previously done.
You need to upload your Excel files to a server location and then use PROC IMPORT with the files on the server OR use the point and click interface to import the files into your programs. It does make it hard to streamline processes. If you had access to X command or DDE those are likely gone as well. If your'e using the newest EG version, the copy files task should be installed to move your files onto the server.
You can download and use the COPY task, you may need administrative privileges.
Regarding X privileges, it depends on what you're trying to do. You can determine folder listings and files using FINFO functions. There's a macro inside the SAS 9.4 appendix that shows how. I think it will still work on your system if you're a few versions behind.
You can download and use the COPY task, you may need administrative privileges.
Regarding X privileges, it depends on what you're trying to do. You can determine folder listings and files using FINFO functions. There's a macro inside the SAS 9.4 appendix that shows how. I think it will still work on your system if you're a few versions behind.
If the server has access to the shared drive this is possible. If it doesn't have access then it's likely not possible.
You can look at several SAS functions to create the directory.
http://blogs.sas.com/content/sasdummy/2013/07/02/use-dlcreatedir-to-create-folders/
Another option is DCREATE() function to create directories. Again, these all require the server to have access to the shared drive.
this is really helpful
thanks Reeza
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.
Ready to level-up your skills? Choose your own adventure.