Hello,
I could not find code issues with obs=10
the only note is
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values
-----
We have at least 150 GIGA space for work on the server.
----
Matching table has less than 2500 rows.
Why by limiting it to (obs=2500) the trns_table could be larger than (obs=177) ? and even (obs=300)
---
there is no consistency - next run with combination of 2500 & 300 ended with connection error.
Thanks
... View more
Hello,
I am running several combinations of obs=
for the combination below, the program runs fine.
once increase obs from 300 to 350 the connection to the server is lost.
I shall check all suggestions posted and update regarding the results.
------------------------
filename sas_code temp ;
data _null_ ;
Set MATCHING_TABLE_FUNC(obs=2500) end = last ;
file sas_code ;
if _N_ = 1 then put "options ls = 256 errors = max nospool ; Data Formula_ ; set TRNSP_SERIES_LIST(obs=300) ;" ;
put Target '=' Formula ";" ;
if last then put "Run ;" ;
run ;
data _null_ ;
infile sas_code ;
input ;
put _infile_ ;
run ;
%include sas_code ;
... View more
Hello,
The following log error
Error: The connection to the server has been lost.
appears for (obs=177)
for obs with lower values such as 170, 175, 176 the program runs fine.
------------------------------------------------------------------------------------
filename sas_code temp ;
data _null_ ;
Set MATCHING_TABLE_FUNC end = last ;
file sas_code ;
if _N_ = 1 then put "options ls = 256 errors = max nospool ; Data Formula_ ; set TRNSP_SERIES_LIST(obs=177) ;" ;
put Target '=' Formula ";" ;
if last then put "Run ;" ;
run ;
data _null_ ;
infile sas_code ;
input ;
put _infile_ ;
run ;
%include sas_code ;
... View more
Hello,
The TRNP_SERIES_LIST columns looks like this
DATE x1 x2 x3 until x4623
The x(i) are variables from TRNS_SERIES_LIST that appear in the formula in the MATCHING_TABLE.
The matching table includes target name of a new variable to calculate and the formula of variables.
for example new_var = x1 + x2 /x3 + x4
... View more
Hello,
I will try to answer your questions:-
The code is valid it runs very good for 175 rows in the TRNS_SERIES_LIST table.
The matching table includes 2454 rows each row with one target formula.
Each formula includes up to 20 variables.
The TRNS_SERIES_LIST includes one column of date and thousands columns of variables.
These variables appear in the formula.
Thanks
... View more
Hello,
Are there data size limitations for the following code,
if so is there a solution rather than a smaller data input:
----------------------------------------------------
filename sas_code temp ;
data _null_ ;
Set MATCHING_TABLE_FUNC end = last ;
file sas_code ;
if _N_ = 1 then put "options ls = 256 errors = max nospool ; Data Formula_ ; set TRNSP_SERIES_LIST ;" ;
put Target '=' Formula ";" ;
if last then put "Run ;" ;
run ;
data _null_ ;
infile sas_code ;
input ;
put _infile_ ;
run ;
%include sas_code ;
----------------------
The log has an error of connection to the server was lost.
The matching table includes thousands of formula such as
target= x1 + x2
The TRNSP_SERIES_LIST SAS file includes 487 rows and 4624 columns.
If the TRNSP_SERIES_LIST includes only 175 rows there is no log error of connection and the program runs smoothly.
We work with Linux, SAS EG 8.2
-------------------------
I can invent data if it is required.
Thanks in advance.
... View more
Hello, We get the same error if the csv is local or if it is located on the web and not at the Linux server.
Thanks your reply is helpful.
... View more
Hello,
we are able to extract the last modified date of a file on Linux using the following code,
and we would like to extract similar information from a web server/ local.
* Running on a Linux folder ;
filename myfile '/opt/sas/spf/xyz/abc.csv' ;
data last_updated ;
opt=FOPTNAME(FOPEN('myfile'),5) ;
optval=FINFO(FOPEN('myfile'),upcase(opt)) ;
run ;
Here we get the required information
Last Modified
31Jan2023:15:29:01
However a log ERROR appears for running on a web server/windows :
filename fileref 'C:\Temp\abc.csv' ;
data a(drop=fid);
infile fileref truncover obs=1;
fid=fopen('fileref');
moddate=finfo(fid,'Last Modified');
run;
ERROR: Physical file does not exist, /opt/sas/config/Lev1/SASApp/C:\Temp\abc.csv.
Do we need to install Samba in order to solve this issue ? another solution you might have ?
What would the code be ?
Thanks a lot
... View more
Hello,
Seems like this can work for TYPE B,
Data next ;
set have ;
xx = scan(data,-1,"/") ;
Array x_ [40] $55 x1-x40 ;
do i = 1 to 40 ;
x_[i] = scan(scan(xx,-i,','),1,'.') ; ;
end ;
drop i xx data ;
Run ;
... View more
