About VD

VD · ‎02-01-2013

Coding - I find it much easier than using the wizard.

VD · ‎02-01-2013

Importing.

VD · ‎02-01-2013

Excel determines the format of the column based on the first few rows (first 5 I think). If the value in these rows is in a different format to those in the rest, incorrect format might result. Adding a single quote, which you have done, usually works. If not, I tend to apply a desired format to that column after importing in SAS and it works fine.

VD · ‎02-01-2013

Looks like it is something to do with the WHERE statement. 1. Use '=' or 'in' instead of 'is'. 2. Check that the date format is correct.

VD · ‎02-01-2013

data get; format id2 $5.; set have; id2= '000'||strip(id); rename id2=id; drop id; run;

VD · ‎12-06-2012

AncaTilea, Thank you for your reply. I found this piece of code (for the header section) which helped to resolve the filename: %if ( &REPORTFORMAT=RTF ) %then %do; %let _odsdest=RTF; %let rv = %sysfunc(appsrv_header(Content-type,application/msword)); %let rv = %sysfunc(appsrv_header(Content-disposition,attachment%nrstr(;) filename=meaningful_name.rtf)); %end;

VD · ‎12-06-2012

Hello, I am creating an rtf file using ods in a stored process (without specifying any path). The default name of the file comes out to be do.doc which I want to change to something more meaningful. Is anyone aware of how to do it? I am using the following settings in the header of the code file: %if ( &REPORTFORMAT=RTF ) %then %do; %let _odsdest=RTF; %end; I also use this statement in the body of the code file: ods rtf style=rtf bodytitle startpage=no nokeepn notoc_data nogfootnote ; Thanks. VD.

VD · ‎12-06-2012

Hello, I am creating an rtf file using a stored process (without specifying any location on a drive). The default name of the file comes out to be do.doc which I want to change to something more meaningful. Is anyone aware of how to do it? I am using the following settings in the header of the code file: %if ( &REPORTFORMAT=RTF ) %then %do; %let _odsdest=RTF; %end; I also use this statement in the body of the code file: ods rtf style=rtf bodytitle startpage=no nokeepn notoc_data nogfootnote ; Thanks. VD.

VD · ‎10-29-2012

I want to use the style 'Printer' for a pdf destination. A graph using proc chart is giving me black and white output instead of any colors. Is it possible to get colors (in any given order) in this style? Thanks.

VD · ‎10-29-2012

Ballardw, Thank you for your reply. The style doesn't seem to make a difference, the device does. But I have to use this device (Actximg).

VD · ‎10-29-2012

symbol1 value=none i=r ci=black; symbol2 value=none i=r ci=blue; symbol3 value=none i=r ci=green; PROC GPLOT DATA=class; PLOT Age *Weight=Gender/ ; RUN; QUIT;

VD · ‎10-29-2012

Hi, I am using annotate function=label to label my datapoints on graph (proc gplot as well proc gplot). When I get the output as html the text size of the labels work fine. But for pdf output the text size comes out as very small and doesn't change even after increasing the size in the annotate function. I am using device=Actximg. Is there an option to manage this? Thanks.

VD · ‎10-29-2012

Thank you, both. I am now working on hard coding the ods options for the required outputs, so hopefully will work then.

VD · ‎10-26-2012

Hi, I want to write a code which outputs a text in a html file. For instance, ods html text="^S={font=('Arial',20pt,bold) outputwidth=100% just=c foreground=red}Test String"; It works on an html output but I also want to get the same text using MS Office add-in. So, when I run a stored process using the add-in, the text should appear in the MS Word document. Is there a way of doing this without explicitly coding rtf options? Otherwise, what would be the rtf options which allows me to get the output from the office add-in? Many thanks. VD

VD · ‎10-25-2012

Robert/Cynthia, Thank you for your replies. Much appreciated. The move keyword seems to work for my graph, which is great. Vikas

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: How to suppress the plot description in html drill down graph

How to suppress the plot description in html drill down graph

Re: How to display both tooltips and hyperlinks simultaneously in gplo...

How to display both tooltips and hyperlinks simultaneously in gplot

Re: To decide if a prompt has been selected or not

Re: To decide if a prompt has been selected or not

To decide if a prompt has been selected or not

Re: Character variable to Date variable

Character variable to Date variable

Re: iterative values

Re: Splitting a string

Re: Splitting a string

Re: Conditional running of array

Re: ods text length

Re: macro variable value

Re: Adding zeros for the number...

Re: Rank on Groups?

Re: Elementary question regarding data step iteration

Re: Formatting Column Names in Output

Re: Can I put multiple regression lines on a plot: ?

Re: Excel converts string to numeric

Re: Excel converts string to numeric

Re: Excel converts string to numeric

Re: Select all

Re: Adding zeros for the number...

Re: ods rtf filename

ods rtf filename

Ods rtf document filename

Change of default colors in style

Re: annotate labels in pdf output

Re: Can I put multiple regression lines on a plot: ?

annotate labels in pdf output

Re: html and word

html and word

Re: footnote - line break