Hi Team, I have the data as below A Jan-23 52,332 A Feb-23 51,800 A Mar-23 53,765 A May-23 50,879 A Jun-23 52,543 A Jul-23 82,640 A Oct-23 57,243 A Dec-23 60,763 B Feb-23 1,12,332 B Mar-23 82,843 B Jun-23 85,851 B Aug-23 84,008 B Sep-23 86,715 B Oct-23 1,17,855 B Nov-23 93,501 B Dec-23 98,064    I want to insert a row which should read as below A          Apr-23         53765 B          Jan-23           20   I also want to get the totals based on the Employee Id. Could you help me here   ... View more

Hi Team,   I have a Text below; abcd15ppppp bvcsf24dsfd cadadada30fdsfdsf   The final output should look like below with 3 columns: col1                col2                   col3 abcd               15                        ppppp bvcsf                24                       dsfd cadadada        30                      fdsfdsf   Could you please help me here     Regards Laxman    ... View more

Hi Team,    Wanted a query regarding SAS Scheduler. In the process Manager in SAS, Under the ByEvent tab, I find a Flow with the same name due to which it is failing since both of them trigger at the same time which should not be the case.   Usually when we schedule , it would be under the lsfuser  But for one of the flow , it is also under a username.   Could you please guide me how to remove the one which is against the username     ... View more

Hi Team,   Could you please let me know , is there a way that would allow SAS users to programmatically run proc imports and exports to a particular drive without using the log on as batch user permission . ... View more

Hi Team,   Under User Manager in SMC, when i click on a group and then select the properties , It would display the list of individual names as well as any groups associated to it . But when i copy the names which is displayed in SMC , into a notepad, instead of the names only the short id's which are associated with it gets populated.   Could someone tell me whatever the names i copy , the same has to get pasted in notepad.   ... View more

Hi Team,   When i try to register SAS Metadata objects from the Physical file location in SAS DI i get the below error. Step 1 : I am able to locate the table Step 2 : Browse, then change the location of the folder. Step 3 : For the first time , i am able to see the table but it does not get registered in the metadata folder. Step 4 : for the next time, i dont see the table only and get the below message. In both step 3 and Step 4 , i get the same preview, the only difference is initially it shows the table but later it does not show.   As i cannot disclose the tables, showing you only the attached image. ... View more

Hi Team,   I have a Data folder in SAS DI which has over 152 Tables. I need to export these 152 datasets to be copied as .csv files and need to be exported to a local folder .   Could you let me know ... View more

Hi Team,   Just wanted to know whether SAS DI can be integrated using Azure Dev Ops.     ... View more