Good morning.   I'm hoping some can help because I'm out of ideas.   I'm attempting to use ODS Excel to place the page number and number of pages in the footer at a right justify. I've tried the three different methods in the example below.  I've done some searching and found some information but can't seem to get it to work.   I get warning messages such as:    WARNING: Apparent symbolic reference R not resolved. WARNING: Apparent symbolic reference P not resolved. WARNING: Apparent symbolic reference N not resolved.   Can anyone give me a hint as to what I may be doing wrong here?                       options(sheet_interval = 'none'                     sheet_name = 'Sheet Name'                     frozen_headers = '2' row_repeat = '1-2'                     suppress_bylines = 'yes' autofilter = 'all'                     pages_fitwidth = '1'                     pages_fitheight = '50'   /* print_footer = '&R &P & of &N'*/ /* print_footer = 'Page &P & of &N'*/ print_footer = "Page &R &P of &N" /* print_footer = "&;LInstitutional Research and Assessment &R Page &P of &N &Z &F"*/   absolute_column_width = '12, 30, 30, 18, 10, 10, 12, 50');   ... View more

Hi everyone,   I hope you're all doing well.   I wanted to discuss a recent suggestion from my boss regarding a potential change in our workflow. Currently, we typically execute SAS code on the server and save all related files, including code, datasets, and outputs, directly on that server. However, the new proposal involves saving all of these files on an FTP server while still running the SAS code on our existing server. Despite consulting with both our SAS after-sale engineer and the IT department, we haven't received a definitive answer on whether this approach would be effective.   Therefore, I'm reaching out to the community for any insights or experiences you may have had with a similar setup. Specifically, I'm interested in understanding if running SAS code on the server while storing related files on an FTP server is a viable approach. Your input on this matter would be greatly appreciated.   Thank you,   *************************************************************************** 1、connection is ok between FTP and SAS server,  I can use FileZilla to  upload  or download some files  2、Can I build the libraries direcly using libname xx "FTP path ....." ?  I am not sure ... View more

Proc export giving additional quotes to the quoted char values.and if u use data step for that it is giving a space or . To numeric values which is not required . Needs to change nothing.now it is , , but want ,, no space no .for missing numeric value. ... View more

To whom who may concern,   I have dragged `Text Import` from the tab `Text Mining` in a `Diagram`. When I execute it, the error "Proc tgfilter reports Error: Cannot load the tktg extension. Check the tktg.dll." has shown.   The screenshot is provided in the attachment.    Some details: server: odaws01-apsel.oda.sas.com last run time: 5/18/24 5:38 am (UTC) ... View more

I have a scenario as follows:   data have; input id var1 var2; datalines; 1  .  5 2  3  4 3  4  5 5  0  6 6  9  8 ; run;   %let nvar = 2; %let v1 = 5; /*Condition for var1*/ %let v2 = 8; /*Condition for var2*/ When i run this array , i am getting error. data want; set have; array var{2} var1 : var&nvar; array flag{2} flag1-flag&nvar; do i = 1 to 2; if var{i} >= 5 then flag{i} = 1; else flag{i} = 0; end; drop i; run; This above code run correct but what i need is that instead of var{i} >= 5  i have to replace by var{i} >= &v{i} so i make  the condition to change as i changes. However this modification does not work ,saying it can not resolve &v{i}. Any suggestion ? Thank you. ... View more