topic SAS and WPS - Code works in SAS but not WPS in SAS Programming

SAS and WPS - Code works in SAS but not WPS

atulsingh — Wed, 26 Jul 2017 22:54:38 GMT

i am trying to run the below code in WPS server but it's not working. However, in SAS studio the code is running sucessfully. Please help me running it on WPS.

The error file is attached below.

Re: BASE SAS

RW9 — Wed, 26 Jul 2017 13:35:04 GMT

Well, from that error it is telling you that refname- a file reference - either has not been set, does not exist, or the system does not have access to the file. Fix the filref to point to a valid area/file to which the system has access to.

Re: BASE SAS

atulsingh — Wed, 26 Jul 2017 13:44:42 GMT

I don't know, how to provide reference to external files in wps.

Re: BASE SAS

RW9 — Wed, 26 Jul 2017 13:54:45 GMT

You will need to consult the manual on WPS as I don't use that, however you should be able to do it in the code there with a

fileref rename "<path to file>/<filename>";

http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#n07buc7sg08fdrn1c1jmmr8hl78r.htm

Re: BASE SAS

Kurt_Bremser — Wed, 26 Jul 2017 13:55:04 GMT

Use the filename statement, just as you do in SAS. That is very basic SAS syntax.

Re: BASE SAS

Reeza — Wed, 26 Jul 2017 15:23:08 GMT

WPS reads the file the same way SAS does. In datafile parameter include the full path to your file on your server. Note that your server likely can't see your desktop and any files on your local drive.