topic Re: Copy dataset from unix to windows shared drive in SAS Enterprise Guide

Copy dataset from unix to windows shared drive

AJ_Brien — Wed, 14 Aug 2019 19:05:57 GMT

Hello,

I have a dataset in the unix location by the name 'db_&cur_mon.' where cur_mon is a macro variable which gets the value MONYY. This dataset gets generated each month, and every month I need to copy the current months' dataset from its unix location to a windows shared drive location.

This is the function that I'm using (attached), but I get this error:

ERROR: File /unix link/TEMP/YES/db_&cur_mon..sas7bdat not a valid file

I'm assuming it's because I shouldn't be using a macro variable but am not sure how else can I perform this operation.

Appreciate all helping me understand this concept. Thank you!

%let abc=/unix link/TEMP/YES;
%let win=\\shard drive windows location\PILOT;
%SYSRPUT win=&win.;

Re: Copy dataset from unix to windows shared drive

Kurt_Bremser — Wed, 14 Aug 2019 19:49:52 GMT

&cur_mon cannot be resolved in the SAS session.

Re: Copy dataset from unix to windows shared drive

Tom — Wed, 14 Aug 2019 20:09:06 GMT

What remote SAS/Connect session do you think the %SYSRPUT statement is going to execute in?

Did you actually run those %LET statements in the current SAS session before trying to run the copy task?

Re: Copy dataset from unix to windows shared drive

AJ_Brien — Tue, 20 Aug 2019 17:00:52 GMT

So I made some changes and this is what I did:

%let path_unix=unix path;
%SYSRPUT path_unix=&path_unix.;
%let path_win = \\windows shared drive path;
%SYSRPUT path_win=&path_win.;
%let MON = %sysfunc(intnx(month, %sysfunc(today()),0), monyy5.);
%SYSRPUT MON=&MON.;

Now when I use the copy task to move my dataset from &path_unix./ABC_&mon..sas7bdat to &path_win.

it gives me the error:

ERROR: Object reference not set to an instance of an object.

Re: Copy dataset from unix to windows shared drive

AJ_Brien — Tue, 20 Aug 2019 17:01:11 GMT

I made some changes and this is what I did:

%let path_unix=unix path;
%SYSRPUT path_unix=&path_unix.;
%let path_win = \\windows shared drive path;
%SYSRPUT path_win=&path_win.;
%let MON = %sysfunc(intnx(month, %sysfunc(today()),0), monyy5.);
%SYSRPUT MON=&MON.;

Now when I use the copy task to move my dataset from &path_unix./ABC_&mon..sas7bdat to &path_win.

it gives me the error:

ERROR: Object reference not set to an instance of an object.

Re: Copy dataset from unix to windows shared drive

Kurt_Bremser — Wed, 21 Aug 2019 06:14:46 GMT

Since this now seems to be a .NET problem, I moved the post to the EG community. Maybe @ChrisHemedinger can help.

Re: Copy dataset from unix to windows shared drive

ChrisHemedinger — Wed, 21 Aug 2019 12:32:05 GMT

@AJ_Brien Do you have a log from the Copy Files task? If not, you might need to enable Application Logging (Tools->Options) to get a detailed log, and work with SAS Tech Support on this.

One other thing to try -- map a drive to your UNC path (\\server\path\file) and use the mapped drive instead of the "\\" notation.