cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
tansel
‎10-30-2019
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: ERROR 457-185: The REPLACE statement is not valid on a data set th...

by Calcite | Level 5 in SAS Programming
‎10-24-2019 04:57 AM
‎10-24-2019 04:57 AM
first colomn of the current data is  as_of_date column. it can defined if "the first column of the next day's data" and "dates that are currently stored at the first column of current table" is matched. the picture below is a sample data from Sas database. Just think that I m trying to add the new day fx rates to this table everyday. (ex: a table with start 24/10/2019 for today). i dont want to duplicate it if there is already some data which has a 24/10/2019 date in the DATE column. this is the reason why i write a replace statement.   many thanks for your help Sample Data From Database table ... View more

Re: ERROR 457-185: The REPLACE statement is not valid on a data set th...

by Calcite | Level 5 in SAS Programming
‎10-23-2019 10:46 AM
‎10-23-2019 10:46 AM
thanks for reply. i also try it and its working. but my concern is duplicating the data in table. (for example: inserting same day data for 2 or 3 times). have you got any suggestion for preventing it? ... View more

ERROR 457-185: The REPLACE statement is not valid on a data set that i...

by Calcite | Level 5 in SAS Programming
‎10-23-2019 10:15 AM
‎10-23-2019 10:15 AM
Hi everyone,   We have an input excel that we read some data from multiple sources by vba and then importing some of it to the sas lib. We are aiming to import the new day data everyday and cumulate the data date by date in one table.    for ex: we have a currency fx rates data that contains 21 th of october at market.IMP_EXCH datatable. And trying to add 22 th of october to it by the code below:   %let data='/sasdata/input_22102019.xlsx';   PROC IMPORT OUT= EXCH DATAFILE= &data DBMS=xlsx REPLACE; SHEET="fxrates"; /* fx rates data is in the fxrates sheet of the excel */ GETNAMES=YES; run;   data market.IMP_EXCH; set EXCH market.IMP_EXCH; REPLACE; run;   but we got an error message like this:   ERROR 457-185: The REPLACE statement is not valid on a data set that is opened for OUTPUT.    the reason for adding a replace statement to code is preventing duplication in table. does any one have any idea as a solution? ... View more

Re: Poor SAS View performance

by Calcite | Level 5 in SAS Data Management
‎08-28-2019 04:11 AM
‎08-28-2019 04:11 AM
thanks to everyone. we did it finally. we created a temporary table on db side (includes joins etc) and executed query with it. Then we took the view from it with a simple query without joins. It worked in seconds. ... View more

Re: Poor SAS View performance

by Calcite | Level 5 in SAS Data Management
‎08-23-2019 11:23 AM
‎08-23-2019 11:23 AM
thanks for your reply. I will forward t to IT dept very soon. Now we r talking about creating the table at orijinal database then get a single view at SAS or directly create a table at SAS instead of view. But im not sure because of memory issues.It should be resolved with view option. ... View more

Re: Poor SAS View performance

by Calcite | Level 5 in SAS Data Management
‎08-23-2019 11:18 AM
‎08-23-2019 11:18 AM
Sorry for insufficent details. i ve just talked to IT dept. they said that thay are running query at the orjinal database. but i dont understand why we are not able to see it in seconds while it is running at orijinal database in seconds. we call the local support. and they said that when it becomes complicated with somequeries, even if its runnig on database, use the table option instead of view option i SAS. But, It doesnt sound reasonable to me. ... View more

Poor SAS View performance

by Calcite | Level 5 in SAS Data Management
‎08-23-2019 09:40 AM
‎08-23-2019 09:40 AM
We have a problem about SAS view performance when its getting a query from multiple tables -that contains reasonable large data- from database. We have a simple loan portfolio data that has nearly 600k rows and 40 columns for a day and we have it for 2 years period. It has some inner joins from differnt tables also (2-3 more tables) IT department create views for us and we find that its working so slowly. When you try to drag it to the process flow, it takes 30 minutes to have a view.    I read that (i m not sure its true or not)  if you r getting a view that contains multiple join queries from different table, SAS is getting all data inside and make it ready for you for view usage. Is it true? as i mentioned above, i have to wait for neasrly 30 minutes to have a view from SAS and the data is not so large.   When we try it with a view that is getting one table query the perfomance is great. Also we put the data to sas table and try to view it. performance is great als this time. But i dont want to create a new copy database that contains same tables in SAS server.   Is anybody knows a solution to handle this poor performans of a view that contains multiple queries joined by a query?   p.s. we also try proc sql for just one day data. It is not also working properly.   Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-30-2019 11:32 AM
Quick links