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

jins · Posted 06-01-2022 04:02 PM

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;

BrunoMueller · Posted 06-02-2022 06:04 AM

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;

Tom · Posted 06-02-2022 10:43 AM

?? 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?

jins · Posted 06-03-2022 04:50 PM

i tried this and this seems to work. thanks!

BrunoMueller · Posted 06-06-2022 06:19 AM

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.

jins · Posted 06-08-2022 11:49 AM

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?

jins · Posted 06-03-2022 04:51 PM

thanks for the explaining this.

Referencing file stored under SAS Content (SAS Viya)