About katies

katies · ‎10-15-2019

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?

katies · ‎10-15-2019

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;

katies · ‎10-15-2019

How do I access a Microsoft Access database on a UNIX server? I tried using the ACCESS engine but no luck.

katies · ‎10-14-2019

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)

katies · ‎10-14-2019

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"

katies · ‎10-14-2019

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;

katies · ‎10-03-2019

I'm getting missing values from the datepart function, not asterisks.

katies · ‎10-03-2019

When I try to manipulate it, I end up with missing values or asterisks. E.g. datepart(InductDateActual); returns only missing values.

katies · ‎10-03-2019

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.);

Online Status	Offline
Date Last Visited	‎10-28-2019 01:19 PM

Schedule tasks on server

Encode password on UNIX server

Microsoft Access data to UNIX server

Re: Accessing Excel sheet in Enterprise 7.1

Re: Accessing Excel sheet in Enterprise 7.1

Accessing Excel sheet in Enterprise 7.1

Re: Changing numeric datetime to SAS datetime

Re: Changing numeric datetime to SAS datetime

Changing numeric datetime to SAS datetime

Schedule tasks on server

Encode password on UNIX server

Microsoft Access data to UNIX server

Re: Accessing Excel sheet in Enterprise 7.1

Re: Accessing Excel sheet in Enterprise 7.1

Accessing Excel sheet in Enterprise 7.1

Re: Changing numeric datetime to SAS datetime

Re: Changing numeric datetime to SAS datetime

Changing numeric datetime to SAS datetime