This is not a repost.
Basically I want to create a file on the server. I tried creating teh file on my C drive and it works fine. But how do I change the code to create a file on the server?
When I tried replacing C drive with the server address, it gives an error:
Physical file does not exist, C:\serveraddr\test.sa_2010_08_04.sas. I am not sure why it points to the C drive? I thought because I am tetsing on PC SAS , it must be pointing to C drive, so I used a ' rsubmit %dbcon' statement before and after, but it still did not work.
data _null_;
set mydata.schd end=eof;
file "C:/test.sa_&dt..sas" lrecl=2000;