Hi experts,   To start, I'm currently on SAS EG 7.15 HF8. I need to access a path in a server which requires my credentials. I have the user ID and password but am not able to access the path running the below code:   libname uat '/sas/dev/path' user=xxx password="xxx";    May I know what did I do wrongly? Just to supplement with more information: a) My user ID doesn't follow SAS rules in which the whole ID is in numeric format (i.e. 123456) b) My password does follow SAS rules; first character is an alphabetic character (i.e. Abc123)   Let me know if you need more info. Appreciate your kind help on the above. Thanks! ... View more

Hi there,   I have a problem where the title using ODS text is not appearing in the second worksheet but instead appearing at the bottom of Sheet 1.   My code is as follows:   **Start of code;   ods Excel file ="&PATH2./Output/OptoutReport.xlsx" style=HTMLblue options(sheet_interval="none" sheet_name="Sheet1");   ods escapechar='~';   ods text="~S={font_size=14pt font_weight=bold}~Sheet 1";   proc tabulate data=pct; . . . run;   **Dummy table; ***********;   ods excel options(sheet_interval="table"); ods exclude all; data _null_; file print; put _all_; run; ods select all; ***********; 　 ods Excel options(sheet_interval="none" sheet_name="Sheet2");   ods escapechar='~';   ods text="~S={font_size=14pt font_weight=bold}~Sheet 2";   proc tabulate data=pct; . . . run;   ods Excel close;     **end of code;   Oddly enough, when I placed this code --> ods text="~S={font_size=14pt font_weight=bold}~Sheet 2"; just before this line of code--> ods Excel close; the text would then appear after the table generated using proc tabulate data.   Appreciate if anyone can give a pointer to solve this issue.   Thank you.     ... View more