Recent content by eguva

I am bookmarking the word docuemnt and writing to the bookmarks using SAS DDE and word basic command. I have 2 boookmarks in the header and my program is not recognizing the bookmarks in the header. Please let me know the word commands to write somethign to the book marks in the header

Hi, You can simply use a retain statement. If you have say 50 variables and you are concerned with ordering for only first 5 or 10 columns. If you use PROC SQL, you have to list all. With retain statement just use those 5 or 10 variables and you are all set. Using this retain statement on...

Thank you for the link. I was planning to write a generic SAS macro which can compare 2 pdf files and probably produce an output dataset for the user to subset or post-process it to reduce the output size. But looks like there is nothing in SAS to read a PDF file. Even if i use this tool, not...

Is there a way to read PDF files into SAS. I saw a presentation online, which says about ghost script, but i am not sure what it emans and how to do it. Can someone help me if you have idea of how to read a PDF file into SAS. Thanks, Eguva

Yes, I did run it and the error is "Unrecognized SAS option name, NOQUOTELENMAX" Eguva

I am using version 8. I guess this is new in version right? Please correct me if i am wrong. Eguva

Hi, I am trying to put a string into a word docuemnt with DDE.I am getting the warning below because the variable value is too long.May I please know how to get rid of this warning: "The quoted string currently being processed has become more than 262 characters long. You may have unbalanced...

Hi Klaz, I tried this and it works. filename foo pipe "dir %bquote("&file.") /t:c /a:-d "; Thanks, Eguva

The following code is from SAS support. It isn ot working when my file name or any of the directories/sub-directories have special characters such as space or hyphen.(eg.: C:\documents settings\test.sas Can someone help me to get away with this.The error i am getting is "Stderr output: The...

Hi Klaz, I have split that into 2 datasteps and increased the sleep time to 10 secs. I am having the same problem as before. When I open the .sas file from its location and run it for first time the word document is opening by itself.AFter first time, it is not able to open the word document...

Hi Klaz, Can ou please help me get rid of this error "ERROR: Physical file does not exist, winword|system" Here is my program: %let template_path=%str(C:\test\template.doc); %let maxmarks=15 /*Total number of bookmarks in the template*/ x 'c:\msoffice\winword\winword.exe'; filename sas2word...

Hi Klaz, Thank you. That helped. For the program that i have discussed above, i need to have a word document/file open already for the program to work. Is it possible to programatically specify to open the word docuemtn too instead. Thanks, Eguva

Hi, I have a table written to word using SAS and DDE. Now I want to know the word basic command to repeat the header row in each page if the table spans to more than one page. Thanks, Eguva

I got it. SASHELP.VTITLE

Hi, Is there any way to get the value assigned to title statements. Say, I am including a program file with libnames, titles assigned.I have no control of the program file.I just include it. In the new program that I am writing, I want to determine programatically, the titles assigned and put...