topic Re: Referencing file stored under SAS Content (SAS Viya) in SAS Programming

Referencing file stored under SAS Content (SAS Viya)

jins — Wed, 01 Jun 2022 20:02:37 GMT

Working on a script in SAS VIYA and want to refer a sas7bdat file stored under SAS Content > Public. Not sure how to find the path and I tried using FILESRVC option but it runs and the log says 1 observation and 0 variables.

filename jjj filesrvc folderpath='/Public';

data mydata;

infile jjj('xxxxx');

input;

run;

Re: Referencing file stored under SAS Content (SAS Viya)

BrunoMueller — Thu, 02 Jun 2022 10:04:07 GMT

A sas7bdat file is a SAS data set. In oder to access it one needs a SAS libref pointing to the directory where this file is stored. A LIBNAME statement can not point to a folder in SAS Content. So you need to make a binary copy of the file. see the code below for an example. Please be aware that the value used for LRECL= must be big enough to accommodate the size of the file.

/*
 * make a binary copy of the file from SAS Content
 * to the directory the work library is pointing to
 */

%let lrecl= %eval(1024 * 1024 * 1024 -1 );
options msglevel=i;

filename src filesrvc folderpath='/Public' name="cars.sas7bdat" recfm=n lrecl=&lrecl;

filename dest "%sysfunc(pathname(work))/newcars.sas7bdat" recfm=n lrecl=&lrecl;

data _null_;
  rc = fcopy("src", "dest");
run;
data newcars2;
  set work.newcars;
run;

Re: Referencing file stored under SAS Content (SAS Viya)

Tom — Thu, 02 Jun 2022 14:43:58 GMT

?? Why should you have to set a large LRECL? Why would it matter with RECFM=N?

I have had no trouble just use RECFM=F LRECL=512 as a default way to get SAS to copy binary files.

Does that not work in this case?

Re: Referencing file stored under SAS Content (SAS Viya)

jins — Fri, 03 Jun 2022 20:50:27 GMT

i tried this and this seems to work. thanks!

Re: Referencing file stored under SAS Content (SAS Viya)

jins — Fri, 03 Jun 2022 20:51:11 GMT

thanks for the explaining this.

Re: Referencing file stored under SAS Content (SAS Viya)

BrunoMueller — Mon, 06 Jun 2022 10:20:10 GMT

Thanks for the tip, I can confirm it works with your options very well. Advantage you do not have to care about the size of the file.

Re: Referencing file stored under SAS Content (SAS Viya)

jins — Wed, 08 Jun 2022 15:49:41 GMT

I had a follow-up question.

If I have to create an external CSS stylesheet (.css or .txt) in HTML form, where should I save this .txt file and how should I refer this?

<head>

I tried saving in the work location but it does not seem to work. Any thoughts on how you would approach this in SAS Viya 3.5?