About Nasser_DRMCP

Nasser_DRMCP · ‎08-10-2017

Thanks a lot Ballardw

Nasser_DRMCP · ‎08-09-2017

thanks both for your quick reponse. below my code. note that the variable v_RAC_Label has the value, "CONSO", "HYPO", and "PP" because I have 3 dataset BEH_SUITE_INDIC_CONSO, BEH_SUITE_INDIC_HYPO and BEH_SUITE_INDIC_PP. my problem is that RAC_Label is displayed in the rtf as well %macro Loop_Rac_ODS(count) ; ODS RTF startpage = yes FILE = "&filename." style = Sapphire ; %Do i=1 %To &count ; proc sql ; select RAC_Label into :v_RAC_Label from RAC_Values where RAC_Indexe = &i ; quit ; proc sgplot data = BEH_SUITE_INDIC_&v_RAC_Label ; series x = ANNEE_AMO_SUITE y = ratio / group = &v_AXE. lineattrs=(pattern=solid) ; xaxis display=(nolabel); yaxis display=(nolabel); run; %End ; ODS RTF CLOSE ; %Mend Loop_Rac_ODS ; 　 %Loop_Rac_ODS(3) ;

Nasser_DRMCP · ‎08-09-2017

Hello, I would like to create 3 charts in the a single doc rtf. each chart is based on a different dataset. The names of dataset have suffix, as "Data_TYPE_1", "Data_TYPE_2", and "Data_3", So, I have created a loop with 3 iterative. (between ODS RTF and ODS RTF close) And the variable is set to 1, 2, 3. I manage to create the chart but there is one page with an unexpected table that shows the varaible value.I would like to remove it ! Thanks in adance for your help Nasser

Nasser_DRMCP · ‎07-21-2017

ok sorry !

Nasser_DRMCP · ‎07-21-2017

I works ! thanks warren ! have a goodday !

Nasser_DRMCP · ‎07-21-2017

hI Warren thanks for your respons. I put sapphire. Now my group lines are all blue. What I would like is to get one different color per group. thanks

Nasser_DRMCP · ‎07-21-2017

Hello, I would like to generate a graph by using proc sgplot. It works but the lines are all black. I would like to attibute differents colors for each group value. I don't know where (and how) I should specify colors my code is ODS RTF startpage = yes FILE = "&filename." style = journal ; proc sgplot data = BEH_SUITE_INDIC ; xaxis type=discrete; series x = ANNEE_AMO_SUITE y = ratio / group = DUREE ; xaxis display=(nolabel); yaxis display=(nolabel); run; ODS RTF CLOSE ; thanks a lot in advance for your help

Nasser_DRMCP · ‎07-20-2017

I forgot to specify that you should do style = journal to avoid an empty file

Nasser_DRMCP · ‎07-20-2017

It works ! I get a rtf file no empty, with a graph By specifying device = png300 like this. goptions reset = goptions device = png300 xmax=7in ymax=9in; but I didn't manage to store the output file on windows in C:\... but only in SAS guide in a folder.maybe a FTP should be done

Nasser_DRMCP · ‎07-20-2017

I wonder wich device because I can notice "ERROR: Device was not specified" in the file log

Nasser_DRMCP · ‎07-20-2017

thanks warren. this is my code bellow. The rtf file is created but empty.I did not specified any device like goptions ftext=zapf device=gif for example, wich device should I specify ? thanks ODS RTF startpage = yes FILE = 'S:\Etudes Rentabilités\Rentabilité 2017\Encours Payback\NASSER\SASLOG\chroniques.rtf' style = sapphire ; proc gplot data = BEH_SUITE_INDIC ; format ratio percent7.0 ; plot ratio * ANNEE_AMO_SUITE = &v_AXE. / legend = legend1 vaxis = axis1 haxis = axis2 ; run ; ODS RTF CLOSE ;

Nasser_DRMCP · ‎07-20-2017

Hello, In a prgm I use ODS RTF and proc plot to get a graph into a file. In SAS guide It works correctly. But whenever I launch the prgm via batch mode, then the file is empty and in the log file a message is "Device was not specified". In the support.sas I found this "The only exception for batch processing is having output sent to the output window." So how can I get my graph via batch mode into the output window ? thanks in advance for your help. Nasser

Nasser_DRMCP · ‎07-19-2017

I found the solution ! I have to use %QSCAN instead of %SCAN ! thanks for your help !!!

Nasser_DRMCP · ‎07-19-2017

I lauch the program via within unix system (Putt). I don't know exactly the command because a menu has been created. I use the menu. I just have to specify the prgm name and the step after the prompt is "SYSPARM ?" I have to specify 2015 2016

Nasser_DRMCP · ‎07-19-2017

If the code is only %put =========> &SYSPARM ; and the prgm launched with 2015, so then the result is correct %put =========> &SYSPARM ; =========> 2015

Online Status	Offline
Date Last Visited	13 hours ago

duration between 2 dates and display hour min sec

struggle with different date format in a string

Re: macro with returned value string instead numeric

macro with returned value string instead numeric

Re: catch program failed

Re: catch program failed

catch program failed

use ampersand in concatenation string but not a macro variable

compile all values from many columns in a signle column

close an opened table with open instruction

Re: Converting Date number to Date9.

Re: create subgroup number by group

Re: generate a random integer without duplicate

Re: generate a random integer without duplicate

Re: generate a random integer without duplicate

struggle with different date format in a string

Re: function that returns a min date from table

join two tables by comparing date in range dates

Re: sgplot xaxis NOT sorted for all group values

Re: proc sgplot create a chart but also an unexpected table

Re: proc sgplot create a chart but also an unexpected table

proc sgplot create a chart but also an unexpected table

Re: SGPLOT colors

Re: SGPLOT colors

Re: SGPLOT colors

SGPLOT colors

Re: ODS RTF in batch mode, the file is empty

Re: ODS RTF in batch mode, the file is empty

Re: ODS RTF in batch mode, the file is empty

Re: ODS RTF in batch mode, the file is empty

ODS RTF in batch mode, the file is empty

Re: launch batch with multiple parameter retrieve scan

Re: launch batch with multiple parameter retrieve scan

Re: launch batch with multiple parameter retrieve scan