Format of libname statement

[zibinkevingao]

Hi, friends 

  When I type libname statement, it gives me this problem

90 Options PS = 56 LS =78;

91 Libname stat480 '/folders/myshortcuts/S2/STAT480.sas';

ERROR: Library STAT480 is not in a valid format for access method RANDOM.

ERROR: Error in the LIBNAME statement.

How do I fix this problem. 

[SASKiwi · Accepted solution]

A LIBNAME should point to a directory containing SAS datasets. It looks like yours points to a SAS program. Something like this should work:

Libname stat480 '/folders/myshortcuts/S2/';

Use the FILENAME statement when you need to reference a specific file, or a directory for the purposes of reading or writing files that are not SAS data sets.

filename stat480 '/folders/myshortcuts/S2/'; 

/* include and run a program from the folder */ 
%include stat480(STAT480.sas); 

data stat;   
  /* read a CSV file from the folder*/   
  infile stat480(data.csv);   
  input v1 v2 ...; 
run;

Editor's note: Popular topic! We added a few more examples and documentation links.