Hi Team,   I had granted read access to a member for a library through the SAS Management Console.   The End User who was accessing the library from SAS EG was unable to view any of the tables under this library. When i investigated in SMC , the tables were not been granted access.   My Question here is : Suppose a library is provided access , will the tables under it also need to be given access explicitly.     ... View more

Hi Team,   Just wanted to know , is there a way to check in Flow Manager in SAS before the batch starts for all the flows whether all the relevant tables are closed in respective applications (Eg. SAS DI Studio, SAS EG). ... View more

Hi Team,   Could you let me know how to delete the log files from the Logs Folder in SAS which are older than 1 month.  Currently i am manually deleting the files from this folder.   Is there a SAS job which can be written or any script which can be auto triggered ?.   Regards Laxman  ... View more

Hi, I have a dataset abc which has 2 columns for example . Dataset : abc Columns : riskst_a        label ='riskst_a'                 claim            label='claim'   I am creating one more dataset abcd by referencing this dataset abc. In my new dataset abcd i want all the columns from the dataset abc to be converted to uppercase including the labels.   Could you please let me know.   Regards Laxman Pai  ... View more

Hi , i am getting my data from oracle table wherein i am formatting my timestamp columns as follows proc format; picture mdyhms low-high ='%Y-%0m-%0d %0H:%0M:%0S.000000' (datatype=datetime);   i am using this format in my code as below  data Test; set map; format eff_datetime mdyhms.; run;   I am creating a template table using the above Test table.   %macro a (dsn); %if sysfunc(exist(&sharedlib..&dsn.))  %then %do; proc sql; delete from &sharedlib..&dsn.; quit; %end; %else %do; proc sql; create table &sharedlib..&dsn. like work.&dsn.; quit; %end; %mend a;   %a (Test);   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.   Could someone help me on this.        ... View more

Hi,   My work table has 10 columns which i am trying to export this into .txt file using proc export using "|" delimiter. Ideally the txt file must contain 9 pipe ("|") symbols separating the 10 columns but here since the last 2 columns has null values in the input data , it has only 8 pipe ("|") symbols and the last column is getting truncated.   for Example ; Proc export data = a.txt outfile= b.txt dbms=dlm replace; delimiter="|"; putnames=NO; RUN;   Any help would be much appreciated if anything needed to be included in the proc export option which would solve my issue. ... View more

Hi, I have 2 output files in Sas EG. the path is /mnt/a.txt and /mnt/a1.txt But when I try to delete the file using the fileexists condition in SAS EG , I get the message "physical file does not exist" even though the file exists in that output path Could you please let me know how to fix this issue through coding in SAS EG ? ... View more

Hi,   I am having an input '05AUG2019:09:00:00.000000' which is to be formatted to                           2019-08-05:09:00:00.000000   i am using below code to achieve this but it returns me "ERROR" in the column.   proc format ; picture mdyhms other = '%Y-%0m-%0d %0H:%0M:%0S.000000' (datatype=datetime);         ... View more

Hi All, Could anyone suggest me as to how can i convert a SAS code to SQL stored procedure. Is there any tool to convert sas code to SQL. Awaiting your reply    Regards pai ... View more