Search results for query: *

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...

Hi Klaz, I got it.I used FINDREPLACE command to replace a dummy characterthat i have created with ^p for new paragraph. Also, I trid that next cell command to write a table, but it is very slow.It writes cell by cell and it is taking a long time.I am not sure ifthat just happened to me...

Hi Chris, It looks like the options for libname cannot be changed once defined.Its wierd. Anyways, here is another question. Libname test "C:\test"; Libname yesy1(test) access=readonly; I think this should word right.This should give read only access to the library right? Thanks, Kiran

Hi, I have a file with all libnames defined.They all have write access.Now how can I make all the defined libraries or a few selected ones readonly. I can get the librefs,paths from dictionary.memn=bers and can create a macro to give readoly access to all opf the defined liobraries. I was...

Hi Klaz, Here is the code that I am using. mark10 is the bookmark for a blank space in my word template where a table is written from scratch. I need to get the text wrapped at places where there is space for columns 4(var4).I tried to replace/concatenate '0D0A'x at those spaces in the...

Hi Klaz, I have created a string that is exactly as your text string and tried to use in put statement. But it didn to work. Probably I am not explaining you right.Let me explain my situation clearly.I have a word table and I have a bookmark for the whole table. Now how do I tell to word to...