SAS Support Communities

Hi All, Facing issue with creating xml reports which ids created using xltagsets. Logs are clean but report has either of the below error and it occurs 1/30 runs. 1. “Unable to read” 2.”Problem during load The error which we are getting on reports which we are unable to replicate as the data refreshes earlier than before identifying the error in xml report.. ... View more

SPDE PROC SQL code utilising a large SAS work space. Please suggests me ideas to optimize and use the work space to minimal.   -In current scenario, I'm performing PROC SQL join on 36 datasets having 12 columns each.   Kindly consider below limitations: -Without redirecting - work or - utiloc locations -Without using system commands   Please let me know for further details. ... View more

Hi ,   I have Fields in a tables , which is supposed to have same content .If there any good deviation needs to be highlighted.     Example: A B S S M M M M S S L L S S S S S S M M S S S L S L   Below is the Cross tab created by PROC FREQ , I need to highlight value if it is greater than Diagonal value.     Table of A by b B Total L M S A L Frequency 1 0 0 1 Percent 8.33 0 0 8.33 Row Pct 100 0 0 Col Pct 33.33 0 0 M Frequency 0 3 0 3 Percent 0 25 0 25 Row Pct 0 100 0 Col Pct 0 100 0 S Frequency 2 0 6 8 Percent 16.67 0 50 66.67 Row Pct 25 0 75 Col Pct 66.67 0 100 Total Frequency 3 3 6 12 Percent 25 25 50 100       ... View more

Hi   I need to create a XLS worksheet report ,in which the tables displayed in panels and having multiple tabs in worksheet.   So I used msoffice2k_x tagset for having the side-by-side display of tables(but it created only one sheet per workbook) .   Then created separate worksheets and tried combining worksheet_source option.But it seems like it stores the hyperlink  and not the actual file.      Can you someone help me with storing the files permanently or an alternative approach ?   Thank, Kayal ... View more

Hi ,   Can you please help me find 'who modified the file .sas files in windows OS' using sas 9.4 .   Kindly let me know if you require any other details.   Thanks, Kayal ... View more

Hi All, Please let me know how we can decrpt the values by use of salt key. Below are the other details(from .Net).Kindly let me know if any other detail is required. tDes.Mode = CipherMode.ECB; tDes.Padding = PaddingMode.PKCS7; Thanks, Kayalvizhi ... View more