topic Re: How to save attachments in a physical location of an object in SAS in SAS Programming

How to save attachments in a physical location of an object in SAS

Azeem112 — Fri, 02 Feb 2018 08:00:55 GMT

Hi I want to get all attachments from SAS content server of solution EGRC 6.1 policy object and want to save it in a physical location on my server.

This is what I'm doing now.

proc sql noprint;
select BUSINESS_OBJECT_RK 
into: rk saperated by '-'
from sasoprsk.attachment_l
where BUSINESS_OBJECT_NM eq "POLICY_INST"
and   ATTACHMENT_TYPE_CD ne "LNK";

select FILE_NM 
into: file saperated by '-'
from sasoprsk.attachment_l
where BUSINESS_OBJECT_NM eq "POLICY_INST"
and   ATTACHMENT_TYPE_CD ne "LNK";

quit;


%macro attachment;

proc sql noprint;
select count(*) 
into: count
from sasoprsk.attachment_l
where BUSINESS_OBJECT_NM eq "POLICY_INST"
and   ATTACHMENT_TYPE_CD ne "LNK";
quit;

%do i = 1 %to &count;

filename out temp;

    %let rk_l=%scan(%bquote(&rk), %bquote(&i) ,%str(-));
    %let file_l=%scan(%bquote(&file), %bquote(&i) ,%str(-));

%put "file &file_l";
%put "http://sasbap.demo.sas.com/SASContentServer/repository/default/sasdav/Products/SASEnterpriseGRC/EnterpriseGRCMidTier6.1/Content/policy/&rk_l/&file_l"; 

proc http 
method="get"
url="http://sasbap.demo.sas.com/SASContentServer/repository/default/sasdav/Products/SASEnterpriseGRC/EnterpriseGRCMidTier6.1/Content/policy/&rk_l/&file_l"
webUserName="sas"
webPassword="Orion123"
out=out;
run;

%end;
%mend;  

%attachment;

I'm saving my attachment files in temp file but I want to save in a physical location as "C drive" inside a folder named as their rk of my object with proper extension as file.doc, file.xls or file.jpg etc.

example 
obj_nm        rk      file_nm
POLICY_INST   12      file.xls
POLICY_INST   13      file.doc
POLICY_INST   14      file.gif

I want to put those files as

C:/12/file.xls 
C:/13/file.doc
C:/14/file.gif

Kindly tell me how can I save my files from SAS content server to a physical location of my server with proper extension.

Re: How to save attachments in a physical location of an object in SAS

andreas_lds — Fri, 02 Feb 2018 09:28:07 GMT

You are, most likely, using sas on a server. That server is not able to access your local drives. You could try an UNC-path if the server sees your computer that should work. But using a network-share is recommended.

Re: How to save attachments in a physical location of an object in SAS

Azeem112 — Fri, 02 Feb 2018 09:32:45 GMT

I want to place my files on the directory or server. I can access the server and get my files from server

Re: How to save attachments in a physical location of an object in SAS

Kurt_Bremser — Fri, 02 Feb 2018 09:52:09 GMT

If you put files on a server like this:

C:/12/file.xls 
C:/13/file.doc
C:/14/file.gif

where I am the admin, I'd come after you with a LART.

But it wouldn't happen, of course, because you wouldn't have write permission in the root directory anyway.

Why don't you simply make your filename dynamic:

%do i = 1 %to &count;

  %let rk_l=%scan(%bquote(&rk), %bquote(&i) ,%str(-));
  %let file_l=%scan(%bquote(&file), %bquote(&i) ,%str(-));

  filename out "E:\somewhere_you_may_write_to\&rk_l.\&file_l.";

You might also need to take care of instances where the path &rk_l does not yet exist.

Re: How to save attachments in a physical location of an object in SAS

Shmuel — Fri, 02 Feb 2018 09:53:45 GMT

You wrote: "I'm saving my attachment files in temp file ..." -

I don't see any assignment to a temp file in your code.

Can you show where is that assignment - usually a FILENAME statement ?

Just change the assignment to physical path and name you prefer.

If the program runs in the server - assign physical path in the server.

Re: How to save attachments in a physical location of an object in SAS

Kurt_Bremser — Fri, 02 Feb 2018 10:00:25 GMT

@Shmuel it's there:

%do i = 1 %to &count;

filename out temp;

    %let rk_l=%scan(%bquote(&rk), %bquote(&i) ,%str(-));
    %let file_l=%scan(%bquote(&file), %bquote(&i) ,%str(-));

TBH, it also took me some time to find it.

Re: How to save attachments in a physical location of an object in SAS

Azeem112 — Fri, 02 Feb 2018 10:00:03 GMT

I can't do this because in my drive there is not any folder of name as object_rk and this code is giving me HTTP client error because physical path didn't exist.

Re: How to save attachments in a physical location of an object in SAS

Kurt_Bremser — Fri, 02 Feb 2018 10:02:46 GMT

If you want to write files to a server, you must of course make sure that the path exists and is writable by you. That's a very obvious given.

To create such a path, you must talk with the server admin.

Re: How to save attachments in a physical location of an object in SAS

Azeem112 — Fri, 02 Feb 2018 10:04:35 GMT

I want to create path using my code.

Re: How to save attachments in a physical location of an object in SAS

Kurt_Bremser — Fri, 02 Feb 2018 10:14:45 GMT

@Azeem112 wrote:
I want to create path using my code.

Look at the fcreate() data step function.

Re: How to save attachments in a physical location of an object in SAS

Azeem112 — Fri, 02 Feb 2018 10:28:00 GMT

I managed to create my path using code but I'm still having issues as there is not any file having same name as file_nm. so proc HTTP gives error because he can't place incoming data from SAS content server to a file.

Re: How to save attachments in a physical location of an object in SAS

Kurt_Bremser — Fri, 02 Feb 2018 10:29:37 GMT

Please post the complete code and log of the proc http step and the filename statement preceding it.

Re: How to save attachments in a physical location of an object in SAS

Shmuel — Fri, 02 Feb 2018 10:45:40 GMT

Thank you @Kurt_Bremser.

BTW the function is dcreate() - to create a directry/subdirectory (not fcreate);

Re: How to save attachments in a physical location of an object in SAS

Azeem112 — Fri, 02 Feb 2018 10:59:24 GMT

This is my code

%do i = 1 %to &count;

*filename out temp;

%let rk_l=%scan(%bquote(&rk), %bquote(&i) ,%str(-));
%let file_l=%scan(%bquote(&file), %bquote(&i) ,%str(-));

options dlcreatedir;
libname newdir "C:/attachments/&rk_l";

filename out "C:/attachments/&rk_l/&file_l";


%put "file &file_l";
%put "http://sasbap.demo.sas.com/SASContentServer/repository/default/sasdav/Products/SASEnterpriseGRC/EnterpriseGRCMidTier6.1/Content/policy/&rk_l/&file_l"; 

proc http 
method="get"
url="http://sasbap.demo.sas.com/SASContentServer/repository/default/sasdav/Products/SASEnterpriseGRC/EnterpriseGRCMidTier6.1/Content/policy/&rk_l/&file_l"
webUserName="sas"
webPassword="Orion123"
out=out;
run;

%end;

Thanks for help, this code is working fine.