topic Re: Autoexec in SAS Studio

Autoexec

tomcarey — Tue, 15 Aug 2017 05:49:28 GMT

I'm trying to assign a library at startup, so added the following to the autoexec file:

%let path=/folders/myfolders/;
libname orion "/folders/myfolders/";
run;

However the autoexec doesnt seem to run upon startup in SAS studio University Edition, are there any startup logs I can look at?

After startup, if I go to Edit autoexec file and select run, then the library is assigned.

Note: I'm a newbee so it's probably something stupid.

Re: Autoexec

Shmuel — Tue, 15 Aug 2017 06:16:31 GMT

I'm using SAS UE.

Change your code to:

%let path=/folders/shortcuts/myfolders/;
libname orion "/folders/shortcuts/myfolders/";

Re: Autoexec

Reeza — Tue, 15 Aug 2017 14:56:35 GMT

@Shmuel Thats only necessary if you've incorrectly created the myfolders for some reason.

@tomcarey How does it not work? Is the library not assigned? Note that what you're doing there is creating a macro variable that's not used and assigning a library. If this is for one of the courses I think the path should be longer and have the course folder name as well.

Re: Autoexec

Shmuel — Tue, 15 Aug 2017 15:19:48 GMT

@Reeza, using linux, I have defined the directory as:

~/SASUniversityEdition/myfolders

did I miss anything ?

Re: Autoexec

Reeza — Tue, 15 Aug 2017 15:21:32 GMT

Is it all lower case in your computer as well? And did you set the shared path to SASUE or myfolders?

Re: Autoexec

tomcarey — Wed, 16 Aug 2017 03:09:55 GMT

thanks for the responses.

I bring up SAS studio from scratch (including starting the Oracle VM VirtualBox), then I select a program that the teacher gave us,

it is listed in the right hand side of SAS Studio and lives in the myfolders directory on my server.

I try to run the prgram but it does not work.

I then go to Edit Autoexec file, select run, (it runs successfully) then I go back and re-run the program and this time it runs.

So I'm guessing the autoexec did not run, or am i missing something?

Here is one of the sampels I tried:

/********************************************************************/
 /* This program uses an INFILE statement to read a raw data file.   */
 /* The INFILE statement includes a full path for Microsoft Windows. */
 /*                                                                  */
 /* For UNIX or SAS onDemand:                                        */
 /*      Replace  the INFILE statement with the following statement: */
 /*               infile "&path/newemps.csv" dlm=',';                */
 /*                                                                  */
 /* For  z/OS:                                                       */
 /*      Replace  the INFILE statement with the following statement: */
 /*               infile "&path..rawdata(newemps)" dlm=',';          */
 /********************************************************************/

daat work.newsalesemps;
	length First_Name $ 12 
          Last_Name $ 18 Job_Title $ 25;
   infile "&path\newemps.csv" dlm=',';   
   input First_Name $ Last_Name $  
         Job_Title $ Salary;
run;

proc print data=work.newsalesemps
run;

proc means data=work.newsalesemps average min;
   var Salary;
run;

thanks

Re: Autoexec

tomcarey — Wed, 16 Aug 2017 03:17:30 GMT

yes lower case, shared path set to myfolders

Re: Autoexec

Shmuel — Wed, 16 Aug 2017 04:44:55 GMT

You have just two lines in your AUTOEXEC.

Check, immediate after entering SAS Studio, by:

1) %PUT PATH = &path; >>> check the log. What do you see ?

Have you got a message that macro variable PATH is not resolved?

2) On left you have Libraries. Expand it - is there a library named ORION ?

Re: Autoexec

tomcarey — Thu, 17 Aug 2017 02:42:31 GMT

Here is what I get - it shows PATH as blank:
62 %PUT PATH = &path;
PATH =

Yes there is a library called ORION.
The commands work when run from the Autoexec run dialog, so I assume they would break if they couldn't find Orion. However, the PATH variable being blank may be the clue. I'll investigate that further.
THanks

Re: Autoexec

Shmuel — Thu, 17 Aug 2017 04:25:18 GMT

Try adding %GLOBAL PATH; in the autoexec - line before the %LET

and check again after entering a new session.

Does it help?

Re: Autoexec

tomcarey — Sat, 19 Aug 2017 14:42:34 GMT

Hi Shmuel,
Unfortunately that also did not work.
Is there any logs I can look at to try and find out what's happening?
thanks

Re: Autoexec

Shmuel — Sat, 19 Aug 2017 15:32:35 GMT

I'm using SAS UE in linux. After checking several options I found:

1) You are right, %LET PATH doesn't work

2) Changing the macro variable to ROOT or MYPATH (and probably ant other valid name) did work.

It seems that sas studio uses PATH for its own needs when launching a new session

and then resets it.