The D (and A) modifiers add characters to the list of delimiter characters. D means Digits and A means Alphabet. So the command  col1= scan(text,1, , 'D'); is the same as the command col1= scan(text,1,'0123456789') Remember that when there are multiple adjacent delimiter it only causes one split in the list. So scan('abcd15xyz',1,'0123456789') Will return abcd as that is the first "word" before the first delimiter. Also when the string starts with the delimiters the first word is after the first block of delimiters.   So  scan('abcd15xyz',1,,'A') will return '15' since the leading block of letters is skipped over and the trailing block of letters marks the end of the first word.   The way to remember this is that it is basically doing what you would do when reading a space delimited list of words.  For both of these strings: ONE TWO THREE ONE TWO THREE The first word is "ONE" and the second word is "TWO". ... View more

Please go back to your ORIGINAL subject line and change "columns" to "rows"     data extra; employee_id='A'; date='01APR2023'd; amount=53765; output; employee_id='B'; date='01JAN2023'd; amount=20; output; run; data want; set have extra; run; /* Get sums by employee_id */ proc summary data=want nway; class employee_id; var amount; output out=sums sum=; run;     Please, in the future, provide data not as a screen capture from Excel, and not via file attachments, but by creating working SAS data step code (examples and instructions) and including this code in your question. Screen captures are not acceptable, for reasons pointed out by @Tom, and so we consider it mandatory that you provide data in working SAS data step code. ... View more

Switch to the By Definition tab. Flows are listed in alpha order, prefixed by the username. Locate the flow you wish to delete, right click on it and select Remove Flow.  ... View more

SAS users can run SAS code in a number of ways. They could have SAS installed on their Windows desktop or they could have SAS running on a server somewhere and use either Enterprise Guide (EG) or SAS/Studio to connect to the server and run their code.   Having SAS installed on your Windows desktop and running SAS in display manager mode (DMS mode) does not require the SAS user to have the 'logon as batch' privilege.   If the SAS user runs EG or SAS/Studio, the SAS server is started as a 'batch' process and does require the user to have 'logon as batch' privilege (even if the SAS process is on the same machine).   ... View more

That appears to be a 'feature' of SMC. Only the 'Name' is copied, not the 'Display Name'. That dialogue is only designed for moving names into or out of a group so I'm not surprised it only selects names as display names are optional. AFAIK, there is no workaround.  ... View more

Suppose we have the following dataset in SAS: /*create dataset*/ data my_data; input A B C; datalines; 1 4 76 2 3 49 2 3 85 4 5 88 2 2 90 4 6 78 5 9 80 ; run; /*view dataset*/ proc print data=my_data;   We can use the following code to export this dataset to a CSV file called data.csv: /*export dataset*/ proc export data=my_data outfile="/home/u13181/data.csv" dbms=csv replace; run; I can then navigate to the location on my computer where I exported the file and view it:   The data in the CSV file matches the dataset from SAS.   Regards, Rachel Gomez ... View more

What does the log say? Please share?   If you use the SMC library plug-in: Can you see the table under the library?  If you use the SMC search function and search for the table name: Do you find something? And if you find something is the table object under the expected library and in the expected folder?  ... View more

We use ADO with SAS 9.4 for change management purposes using the integrated Git and pipeline functionality. Only SAS program files are controlled this way however along with non-SAS reference data.   I don't use SAS DI, but my understanding is DI jobs are stored in SAS metadata. The only way to get these into ADO would be via exported packages unless there is some other API I'm not aware of. ... View more

Can other users see the tables OK and only the one user is affected? Are these SAS tables or external relational database tables? If nobody can see tables in this library your metadata library configuration might need changing. ... View more

Thank you ... View more

I don't think so. How would you know what files are going to be affected without running the batch jobs? If you have a SAS dataset locking problem then there are other possible strategies that will help. What OS does your SAS servers run on and do your batch jobs run outside of normal business hours? ... View more

@laxmanpai wrote: Hi, I am getting the error  "The HEADER/VARIABLE update function is not supported by the sasiosnf engine. Actually the libref is sas is actually connected to the Library in Snowflake.   So i am getting the above error. That pretty much says that SAS cannot change the properties of variables in the external data base. So you need to use SNOWFLAKE tools to change data in Snowflake. It may have helped a bit to provide this little bit of information in the first place as remote databases and what can be done depend  a lot which database, how you connect and where you want to make a change. ... View more

Thanks @Tom for the simple and elegant example. ... View more

Hello @laxmanpai  I see the following statements in your question/posting Help me understand your requirement. 1.I am getting my data from oracle table wherein i am formatting my timestamp columns as follows (You give your format statement) 2.Now what is happening here is , the template table being created out of the work.test table is having the column eff_datetime with datatype as FLOAT instead of timestamp in Snowflake. So what I understand is that You are getting a date value from oracle and want to convert to a format for snowflake. Please confirm if my understanding correct? Please provide sample of date values you are getting from oracle. ... View more

Please post the code you are using. Most times, when sas is complaining about the non-existence of files, those files are simply not visible for the sas session. ... View more