Importing data from external files

[Katemeva]

Hello,

I'm using SAS 7.1, I'm working in a remote host with SAS but SAS is in a server.

I'm tried to import and append a lot of files into one but, SAS shows that not recognize the path, I see that is because SAS take the path like local path, but the files are in other server. How can I declare that the file is in here ("\\sbmdebns03\VP_SERV_CLIE\DIR_SERV_FINAN\GCIA_SERV_TRIB\InfoActual\2016\TRIBUTARIA CLIENTES\Certificados Anuales\SAS\Proceso Certificados Tributarios\Data\Input\Planos HtaCertificados\RFTE_2010_1\ArchivosGenerados\RFTE2015_1.txt";
)?

For this example I put only two files, but in this moment are 56 files

FILENAME archivos ('\\sbmdebns03\VP_SERV_CLIE\DIR_SERV_FINAN\GCIA_SERV_TRIB\InfoActual\2016\TRIBUTARIA CLIENTES\Certificados Anuales\SAS\Proceso Certificados Tributarios\Data\Input\Planos HtaCertificados\RFTE_2010_1\ArchivosGenerados\RFTE2015_1.txt' '\\sbmdebns03\VP_SERV_CLIE\DIR_SERV_FINAN\GCIA_SERV_TRIB\InfoActual\2016\TRIBUTARIA CLIENTES\Certificados Anuales\SAS\Proceso Certificados Tributarios\Data\Input\Planos HtaCertificados\RFTE_2010_1\ArchivosGenerados\RFTE2015_2.txt');

data temp;
infile archivos;
input A B C D E F G H I J K L M N O P Q R S T U V W;
run;
proc print data = temp;
run;

The numbre of columns are 23 and the error is this:

ERROR: Physical file does not exist,
/sasend/sas_config/Lev1/SASApp/\\sbmdebns03\VP_SERV_CLIE\DIR_SERV_FINAN\GCIA_SERV_TRIB\InfoActual\2016\TRIBUTARIA
CLIENTES\Certificados Anuales\SAS\Proceso Certificados Tributarios\Data\Input\Planos
HtaCertificados\RFTE_2010_1\ArchivosGenerados\RFTE2015_1.txt.

So like I said (/sasend/sas_config/Lev1/SASApp/\) this path is in the server and my files aren't there.

Thank you for you help!

[Kurt_Bremser]

Your SAS server obviously resides on a UNIX platform, so you have to use UNIX filename syntax:

- directories are separated by a forward slash instead of a backslash

- directory names should start with a slash, indicating an absolute path name starting at the root directory of the system

(other pathnames will automatically start from the current working directory, which is /sasend/sas_config/Lev1/SASApp/ in your case)

First, have your system administrator create a mount for your shared drive on your SAS server; after you have received the name of the directory where the shared drive is mounted, use it as the base for your filename.

Your path name looks awfully long at the moment; keep in mind that most operating systems will run out of space for filenames somewhere around 254 characters. And, for ease of use, strictly avoid blanks in file or path names. Use underlines instead.