I have a SAS program scheduled to run daily on my local machine. But the laptop is a loaner and I want the program to continue to run at scheduled times when I no longer have access to it. I'm running SAS on a UNIX server. Can I set the task to run on the server?
... View more
I want to encode my password for a database and use it in a libname statement on another library. I'm using the code below, but I'm having trouble with the filepath portion. How do I write to a file that is not accessible to everyone on the server. filename pwfile 'filepath';
proc pwencode in='password';
run;
... View more
It looks like the filepath could be the problem. I tried accessing the data with a proc import step, but got an error saying Physical file does not exist, server-name/C:/Users/username/Desktop/filename.xlsx How do I set the filepath so that SAS references a file on my desktop, not a file on the server? Proc import datafile="C:/Users/username/Desktop/filename.xlsx"
dbms=xlsx
out=outpath;
Run; I also tried using the import data wizard to import the file to one of my libraries but got an error saying that Excel needed to be installed to access it (even though Excel is installed on my computer and I can access it there without an issue)
... View more
When I open the MYLIB library, there are no sheets there. Could the problem be the filepath I'm specifying? I'm using a UNIX server and accessing a file on my Desktop with the filepath: "C:\Users\username\Desktop\filename.xlsx"
... View more
How do I access an Excel sheet in SAS Enterprise 7.1? I'm using the code below. The log says that the libname was successfully assigned, but the proc contents step gives me an error that says, "File mylib.sheetname.DATA does not exist." libname mylib XLSX "file-path.xlsx";
Proc contents data=mylib.sheetname;
Run;
... View more
I'm using an Access database that generates a 16-digit date time (e.g. 30May2019 0:00:00.0000). SAS imports this as a numeric field with format datetime16. How do I change it to a SAS datetime? I'm trying the code below, but I end up with a numeric field, not a date. Induct1=Input(put(InductDateActual,datetime16.), datetime16.);
... View more