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