we are using SAS DIS (Data Integration Studio) on  a 9.4 M8 platform running on linux.    We got problems handling delta update in SAS. I have stored the data in SPD. eg. I need to delta update a data set with 525.877.099 rows (base) with 5.881.292 rows (delta).    I have tried to use update/insert by “Modify by index” but it only worked the first time for my deltaload and the second time with new delta load it came with error ERROR: No key variables have been defined for file XXX.   If I change the load to “Modify by columns” and the index key and index set ‘as it’ it runs forever or is stopped by broken pipe/network error. I stopped it after 15 hours run time. See log below.   What do you recommend for handle this type ? is SPD useless in this manner ? or should I choose different in the load transformation? Or should I avoid using SPD here? ERROR: Error on server LIBNAME socket. MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2025-05-26T07:46:02,814+02:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| 5881292| _DISARM| 16158720| _DISARM| 10| _DISARM| 10| _DISARM| 0| _DISARM| 0| _DISARM| 35263.340000| _DISARM| 56842.870510| _DISARM| 2063800719.944049| _DISARM| 2063857562.814559| _DISARM| 35257.960000| _DISARM| | _ENDDISARM ERROR: . NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements. ERROR: User asked for termination NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set XXX. NOTE: The data set xxx has been updated. There were 769 observations rewritten, 0 observations added and 0 observations deleted. ERROR: Client Generic Error - SocketWrite 569 MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2025-05-26T07:46:02,824+02:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| 525877099| _DISARM| 16158720| _DISARM| 10| _DISARM| 10| _DISARM| 0| _DISARM| 0| _DISARM| 35263.360000| _DISARM| 56842.886354| _DISARM| 2063800719.938458| _DISARM| 2063857562.824812| _DISARM| 35257.980000| _DISARM| | _ENDDISARM ERROR: Connection refused. NOTE: There were 770 observations read from the data set WORK.WG52IT. MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2025-05-26T07:46:02,825+02:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| -1| _DISARM| 16158720| _DISARM| 10| _DISARM| 10| _DISARM| 0| _DISARM| 0| _DISARM| 35263.350000| _DISARM| 56842.879640| _DISARM| 2063800719.945420| _DISARM| 2063857562.825060| _DISARM| 35257.970000| _DISARM| | _ENDDISARM NOTE: There were 770 observations read from the data set WORK.WG52J3. MVA_DSIO.OPEN_CLOSE| _DISARM| STOP| _DISARM| 2025-05-26T07:46:02,825+02:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| -1| _DISARM| 16158720| _DISARM| 10| _DISARM| 10| _DISARM| 0| _DISARM| 0| _DISARM| 35263.340000| _DISARM| 56842.877933| _DISARM| 2063800719.947373| _DISARM| 2063857562.825306| _DISARM| 35257.970000| _DISARM| | _ENDDISARM PROCEDURE| _DISARM| STOP| _DISARM| 2025-05-26T07:46:02,825+02:00| _DISARM| BatchServer| _DISARM| SAS| _DISARM| | _DISARM| 20881408| _DISARM| 16158720| _DISARM| 10| _DISARM| 10| _DISARM| 0| _DISARM| 0| _DISARM| 35263.360000| _DISARM| 56843.000551| _DISARM| 2063800719.824903| _DISARM| 2063857562.825454| _DISARM| 35257.980000| _DISARM| | _ENDDISARM NOTE: DATA statement used (Total process time): real time 15:47:23.00 cpu time 9:47:43.36 ... View more

Hi All,   I have an csv file with around 9 fields, one of this field (field 7) is an free text column in the source system. I.E., user can type an message in it, so this field has carriage return value, special char, quotes, alt+enter.   Below you can see one record. Most of the records are without CR in the text field and is one row in the csv file. But some are with and appear as below.     how can i import it in a easy way (we are using standard SAS integration studio) in a file reader? or programming? is there an option which can help me?    Thanks in advance.   regards, Ann ... View more

Hi, we have csv files delivered with name *_<date><id>. We want to easy rename the output files to * without suffix. Eg. class_20241114to class . How is that done in an easy way. We are running  Sas 9.4 on Linux.  We use Sas data integration studio. But can as well use the filesystem. We do not want  a shell script. But one command is fine. Thanks in advance for solutions.  ... View more

Hi,   we have users who has deleted shared libraries. How can I secure the libraries and the users still be able to manage eg. delete and add  tables metadata and physically? We are running Sas 9.4 m8 standard.  thanks in advance.  regards, Ann ... View more

How can I easy create storage/size in memeory information of all tables in a specific cas lib. I use this: proc cas; table.tabledetails /name="%" caslib="XXXX"; quit;   but it fails. it seems that I can not use a wildcards in that manner?   Do you have some code which could help me? ... View more