SAS Studio question: Uploaded Data File, But How To Then Access It?

[NKormanik]

Not sure this is the forum now for SAS Studio.  Point me in the right direction if not....

Decided to try out SAS Studio online.  Uploaded data file, and then attempted to run program.  Received error:

NOTE: The SAS System stopped processing this step because of errors.
 71         data=/home/nkormanik/sasuser.v94/combined
                 _
                 22
                 76
 ERROR 22-322: Expecting a name.  
 ERROR 76-322: Syntax error, statement will be ignored.

Any guidance greatly appreciated.

Nicholas Kormanik

[Tom]

Where is the rest of the program?

A lot of procedures have a option DATA=, but your posted code does not appear to be calling any procedure.

If the file is a SAS dataset (that is a file with an extension of sas7bdat) then you might be able to use a physical path like that if you put it in quotes.

proc means data="/home/nkormanik/sasuser.v94/combined.sas7bdat";
run;

But since it looks like you put the file into the folder that SASUSER libref should be pointing to you could just use the easier to type normal SAS syntax of a two level name.

proc means data=sasuser.combined;
run;

Note: Do not place files in the SASUSER folder, make another folder for you project data.   SASUSER is where SAS stores things like your PROFILE catalog where it keeps setting options you have made and you don't want to accidentally mess those up.  Plus if you happen to have more than one SAS session running at the same time then SASUSER libref will be read only.  Or if you run with the RSASUSER option set (which you should if you need to run multiple SAS sessions at the same time) then that libref will be readonly also.

[NKormanik]

@Tom  Bear in mind, this is the online SAS Studio for Academics.

The location of the SAS program I was attempting to run isn't the issue.  To get the program online, I clicked on the New Program icon, then hit Ctrl-V (after first copying it in Windows).  Easy peasy.

I uploaded my data file to the default location, wherever that was.

So, I tried to create a new library.  Then was able to move the data file into that new library.  At this very second the program is running.....

Phew!

[NKormanik]

Well, SAS Studio simply doesn't like me for some reason:

ERROR: The SAS System stopped processing this step because of insufficient memory.
 NOTE: There were 5000 observations read from the data set SAS_1.COMBINED.
 WARNING: The data set WORK.PREDICTED may be incomplete.  When this step was stopped there were 0 observations and 445 variables.
 NOTE: PROCEDURE LOGISTIC used (Total process time):
       real time           8:21.35
       user cpu time       8:18.07
       system cpu time     3.20 seconds
       memory              4062850.25k
       OS Memory           4113352.00k
       Timestamp           02/14/2022 07:35:29 AM
       Step Count                        42  Switch Count  10
       Page Faults                       0
       Page Reclaims                     1019520
       Page Swaps                        0
       Voluntary Context Switches        67
       Involuntary Context Switches      7283
       Block Input Operations            0
       Block Output Operations           328

I think I have to hold off on the 'interaction' terms....

[Kurt_Bremser · Accepted solution]

If you use a physical path, it must be enclosed in quotes and also contain the filename extension.

Since you put your file in the directory that serves as the SASUSER library, you can access it as

sasuser.combine

(without quotes)

[NKormanik]

Okay, having ditched the too-many interaction requests, things progressed smoothly.  (Who needs interaction effects anyway...)

Only one HUGE question now remains on this little venture:

How to interpret the results??

SAS Logistic Regression. 

Which variables of the 200 are keepers?

A boatload of tables and charts....  

No red highlights, "Here's the answer!"

Is there a particular current book you folks might recommend?

[Tom]

---

@Kurt_Bremser wrote:

If you use a physical path, it must be enclosed in quotes and also contain the filename extension.

Since you put your file in the directory that serves as the SASUSER library, you can access it as

sasuser.combine

(without quotes)

---

Correction:

If you use a physical path, it must be enclosed in quotes and also but does not need to contain the filename extension.

If running on Unix (like with SAS OnDemand) the actual name of the file, excluding the path but including the .sas7bdat extension, cannot use uppercase letters.

Example:

194   data class; set sashelp.class; run;

NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.CLASS has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds


195
196   data test;
197     set "%sysfunc(pathname(work))/class";
198   run;

NOTE: There were 19 observations read from the data set 
      C:\Users\...\AppData\Local\Temp\1\SAS Temporary Files\_TD1220_..._/class.
NOTE: The data set WORK.TEST has 19 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds