Hello, thank you for your answer. I import excel files, and in every excel i have different variable name. my aim is convert every variable name to unique variable name that will be identical across different files. the next problem that the names of variable is in Hebrew... Sometimes they consist from two words with blank, sometimes, one word, sometimes three words. ... View more

Hello, thank you for your answer. I import excel files, and in every excel i have different variable name. my aim is convert every variable name to unique variable name that will be identical across different files. the next problem that the names of variable is in Hebrew... Sometimes they consist from two words with blank. ... View more

Hi, thank you for help. but i put title after ods and then all titles change, also in the first page ... View more

Hi Cynthia, i checked your code and found that if i replace proc print in the second page to ods text='Description'; i will still get the same title1 and title2 from first page.what do you think? maybe command title is not working or i have some problem with word 2013? thank you ... View more

Hi, thank you for your help. but you didin't understand me.Cynthia is right, i need different title on page one and page two. my code is : options nonumber nodate; ods rtf file='C:\..........\ControlReportDeveloper.rtf' startpage=no ; ods escapechar = '~';   title1  j=l '~S={preimage="C:\...........\logo.jpg" }'; title2  j=l height=10pt bold 'Left'   j=r height=12pt bold 'Right'; ods  text='Alexey'; title; ods rtf startpage=now; title2  justify=left j=l height=10pt bold 'Cilic Champion'; ods  text='~{newline 6}'; ods   text='~{style[font=(Arial) just=r fontweight=bold fontsize=14pt] Description}'; ods rtf close; on the first page i get on the header : logo, Left and right and text : Alexey . It's OK on the second page i still get logo, Left and right (title is not work?) and Description. I had to get header Cilic Champion and text Description. thank you ... View more

Thank you for your help. I run your code and it's really work, but my code is not run as your. options nonumber nodate; ods rtf file='C:\..........\ControlReportDeveloper.rtf' startpage=no ; ods escapechar = '~'; title1  j=l '~S={preimage="C:\...........\logo.jpg" }'; title2  j=l height=10pt bold 'Left'   j=r height=12pt bold 'Right'; ods  text='Alexey'; title; ods rtf startpage=now; title2  justify=left j=l height=10pt bold 'Cilic Champion'; ods  text='~{newline 6}'; ods   text='~{style[font=(Arial) just=r fontweight=bold fontsize=14pt] Description}'; ods rtf close; on the first page i get on the header : logo, Left and right and text : Alexey . It's OK on the second page i still get logo, Left and right (title is not work?) and Description. I had to get header Cilic Champion and text Description. thank you ... View more

we have standard products, not something special. but maybe can i operate SAS FROM DOS? what is SAS Stored Process? ... View more

SAS reside on server and we don't have Enterprise Guide. Our customers have to upload a file with data to site and press button than SAS have to work and return the results by file. i don't know if we can do it and how can i operate SAS from site... ... View more

Thank you. i have another question to you, can i operate SAS from other system automaticcally? i will describe situation : my customer will enter my site, will put there his file, and will press button, this button will operate SAS program and then ther results will send to this customer by file. can i do it? if yes, how can i operate SAS from site? thank you ... View more