topic Re: Running script (Data infile) in .NET application in SAS Enterprise Guide

Running script (Data infile) in .NET application

gneccao — Wed, 17 Jan 2018 18:03:16 GMT

Hi,

I have a .NET application to run SaS scripts, i´m trying to create a Data Set, using a the data in a file.

I have others imports running the same script and it´s ok, but when i try to import that one, the result message doens´t show any errors or warning, but the DataSet is created empty. When i run the script in the Guide, its work perfectly.

DATA WORK.DataTest;
	FORMAT
PROTOCOLO	BEST12.
ASSUNTO	$CHAR174.
ENVIADOPOR	$CHAR54.
DATAEMAIL	DATETIME18.;
INFILE '/home/users/data.txt'
LRECL=257
ENCODING="LATIN1"
TERMSTR=LF
DLM='&'
MISSOVER
DSD ;
INPUT
PROTOCOLO	: BEST32.
ASSUNTO	: $CHAR174.
ENVIADOPOR	: $CHAR54.
DATAEMAIL	: ?? ANYDTDTM19.;
RUN;

I have to send a option? Im confused because its was working for at least 13 files. That´s the only one with the problem of empty DataSet.

Re: Running script (Data infile) in .NET application

gneccao — Wed, 17 Jan 2018 18:43:40 GMT

Well, i don´t know how to explain that, but when i restart the computer..... it´s now working... i really don´t know why...

Re: Running script (Data infile) in .NET application

ChrisHemedinger — Wed, 17 Jan 2018 18:48:37 GMT

You didn't share details about the .NET script you're using. If it happens again, share info about how that was built and what it's doing. Differences between EG and other environments usually come down to SAS system options that have been set differently, or user account differences. Comparing PROC OPTIONS output between the two (while tedious) can help you to figure it out.

Re: Running script (Data infile) in .NET application

gneccao — Thu, 18 Jan 2018 13:55:18 GMT

Sorry about that.

The proc options output you are talking about, is the result log?