About GPatel

GPatel · ‎04-06-2014

I have test data as shown below. How can I compute trend factor and create a macro variable for the same? Data Test; infile cards missover; Input YEAR ACTUAL best8.; cards; 1995 4356.26 1996 8520.93 1997 8161.92 1998 8715.83 1999 4060.38 2000 5446.24 2001 2212.86 2002 4348.00 2003 3803.34 2004 3095.96 2005 8455.64 2006 3553.20 ; run;

GPatel · ‎02-24-2014

Cynthia, This works fine as expected. I need to modify SAS code to use Macro logic. Its doable. Again, thanks for your insight and optimum solution. Regards, Girish Patel

GPatel · ‎02-23-2014

Cynthia, Thanks for your time and interest. I appreciate your efforts on this posting and solution. I learned that it is not feasible to change a single cell from COMPUTE BEFORE to have 2 different background colors. PDF file shows cell with only one color. Could you please shed some more lights on " However, the downside of this technique is that you won't be able to change the color and text of the "Third Line" (such as when TYPE changes) without "macro-izing" your code." Regards, Girish Patel

GPatel · ‎02-22-2014

Cynthia: Thanks for your prompt reply and comments. SAS code (Version SAS 9.4) updated is attached below for your review and reference. Is it possible to design report with following changes ? (1) For the second line, it should be ' THIN ' line with white background. (2) Background of third line (which reads -: Type : Sedan) should be other than yellow. (3) Font Color for the third line should be black. %let ff = %str(HEIGHT=9PT Bold F=ARIAL bcolor="White" color='BLACK') ; %Let Title1 =%str(Line of Business : Electronics); %Let Title2 =%str(US Export); %Let Title3 =%str(Enterprise Unit); %Let Title4 =%str(Report ID: Ele_Export_US); %Let Title5 =%str(Department : HR01AL9012) ; %Let Title6 =%str(Paid Period); %Let Title7 =%str( December 2013); Title Font=Arial bold height=12pt J=c "&title1" J=c Font=Arial bold height=12pt "&title2" J=l Font=Arial bold height=10pt "&title3" J=l Font=Arial bold height=10pt "&title4" J=c Font=Arial bold height=9pt "^{newline 1}" "&title5" J=c Font=Arial bold height=9pt "^{newline 1}" "&title6" J=c Font=Arial bold height=9pt "^{newline 1}" "&title7"; FootNote ' '; ODS escapechar='^'; ODS _all_ close; options orientation=landscape leftmargin="0.2cm" rightmargin="0.2cm" Device=ACTXIMG topmargin="0.5cm" bottommargin="0.5cm" nodate nonumber center spool printerpath="Postscript"; ODS pdf file="d:\temp\Test.pdf" style=sasweb startpage=yes notoc; %Let starttime=%sysfunc(datetime()); Proc Report Data=sashelp.cars(obs=5 keep=Make Model Type Origin MSRP Invoice) nowd style(report)=[cellspacing=5 borderwidth=0 bordercolor=white] style(header)=[color=Black Fontstyle=italic Fontsize=4] style(column)=[color=moderate brown Fontfamily=helvetica Fontsize=4] style(lines)=[color=black backgroundcolor=black Fontstyle=italic Fontweight=bold Fontsize=5] style(summary)=[color=cx3e3d73 backgroundcolor=cxaeadd9 Fontfamily=helvetica Fontsize=3 textalign=r]; /* style(calldef)=[background=white]; /* Reference from SAS Guide to Report Writing By Michele M. Burlew : Page 191 */ Columns Make model Type Origin MSRP Invoice ; Define make / Order Noprint; Define model / 'Model' ; Define type / Order Noprint; Define origin / Order Noprint; Define MSRP / sum analysis ; Define invoice / sum analysis ; break after type / page skip; compute before _page_ / left style=[Font_weight=bold foreground=green background=yellow]; if _Break_ ne ' ' then CALL DEFINE(_COL_,'style', 'style=[ foreground=green background=yellow Fontstyle=italic Fontsize=2 ]'); line 'Make: ' Make $char. ; /* First Line */ line ' '; /* Blank Line */ if _Break_ ne ' ' then CALL DEFINE(_COL_,'style', 'style=[ foreground=red background=silver Fontstyle=italic Fontsize=2 ]'); line 'Type : ' Type $char.; /* Third Line */ endcomp; run; ODS PDF Close; ODS LISTING ;

GPatel · ‎02-21-2014

Dear SAS Communities Members : I have attached sample code below. How can I change background/font type/font size of line # 1 (Make : Acura) to yellow, and insert a blank thin line and change background/font type/font size of line # 3 (Type : SUV) to lightblue ? proc report data=sashelp.cars(obs=25 keep=Make Model Type Origin DriveTrain MSRP Invoice ) nowd headline headskip style(report)=[cellspacing=5 borderwidth=0 bordercolor=white] style(header)=[color=Black fontstyle=italic fontsize=4] style(column)=[color=moderate brown fontfamily=helvetica fontsize=4] style(lines)=[color=white backgroundcolor=black fontstyle=italic fontweight=bold fontsize=5] style(summary)=[color=cx3e3d73 backgroundcolor=cxaeadd9 fontfamily=helvetica fontsize=3 textalign=r] style(calldef)=[background=white]; Columns Make model Type Origin DriveTrain MSRP Invoice ; Define make / Order Noprint; Define model / 'Model' ; Define type / Order Noprint; Define origin / Order Noprint; Define DriveTrain / Order Noprint; Define MSRP / sum analysis ; Define invoice / sum analysis ; break after type / page skip; compute before _page_ / left style=[font_weight=bold foreground=green background=yellow]; if make ne ' ' then call define(_lines_,'style', 'style=[ foreground=green background=yellow fontstyle=italic fontsize=2 ]'); line 'Make: ' Make $char. ; line ' '; if Type ne ' ' then call define(_row_,'style', 'style=[ foreground=red background=silver fontstyle=italic fontsize=2 ]'); line 'Type : ' Type $char.; endcomp; run;

GPatel · ‎08-01-2013

data a; input id $ Trans $; cards; ... Proc SQL ; Select id, count(Distinct(Trans)) as UnqTrans from A Group by ID; Quit;

GPatel · ‎11-02-2012

Thanks Art. It is what I was looking for. Girish

GPatel · ‎11-02-2012

Is there a SAS format to display 1 as One, 2 as Two, and so on? Or one has to define its own?

GPatel · ‎09-25-2012

Is there any procedure or code that lists all store processes, olap cubes, information maps off the metadata, like proc contents lists?

GPatel · ‎09-07-2012

Cynthia, Thanks for your "fundamental" response. While cutting & pasting code, I took it out ODS HTML BODY=..... line of code. I will be contacting SAS Tech Support staff. Regards, Girish Patel

GPatel · ‎09-06-2012

I have a code as show below. Image is being inserted if I use ODS output. Is there a way to display contents with image in the output window without using ODS output file? I am using this code in EG. With PC SAS, it works fine, however when I use EG, how do you code/point image location ? Eventually, I am going to create a store process, and job will be scheduled to be run off the store process server. dm 'log' clear; dm 'Output' clear; data a; input Indicators $ SALCD $ Total; cards; A M 10 A N 22 A O 35 A P 41 B M 5 B N 9 B O 15 B P 29 ; run; proc sort data=a; by indicators;run; proc transpose data=a out=b; by indicators; id salcd; var total; run; /* proc sort data=b nodupkey; by m_n_diff; run; data fmt; set b ; fmtname = "mypic"; start = m_n_diff; label = "d:\arrow_png"||put(m_n_diff,4.)||".jpg"; keep start fmtname label; run; proc format cntlin=fmt; run; */ proc format; value colorfmt low-0 = 'navyblue' 0 = 'CX23d8FF' 0-high = 'lightblue' ; value mypic low-0 = "Green_down.jpg" 10-high = "Green_up.jpg" 0 = "right.jpg" ; value difffmt low - <-10 = 'red' -10 - 0 = 'green' other = 'beige' ; value blank other=" "; run; * ods html close; * ods html body ="d:\arrows_jpg\test.html"; title1 ' '; %let curr_90= 27 MAR 2012 ; proc report data=b nowd headline headskip style=[/*preimage="d:\arrows_jpg\up_new.jpg" */ background=mypic.]; column indicators ("Curr Prev 90 Days - &CURR_90" m n m_n_diff m_n_perc)('Curr Prev 12 Months' o p o_p_diff o_p_perc) ; define indicators /group; define n /display; define m_n_diff /computed center style=[ foreground=difffmt. preimage=mypic. ] ; define m_n_perc /computed center format=percentn8.2 style=[ preimage=mypic. ] ; define o_p_diff /computed center style=[ foreground=difffmt. preimage=mypic. ] ;; define o_p_perc /computed center format=percentn8.2 style=[ /*background=difffmt.*/ preimage=mypic. ] ; compute o_p_perc; m_n_diff = m.sum - n; m_n_perc = (m.sum-n)/m.sum; o_p_diff = o.sum - p.sum; o_p_perc = (o.sum-p.sum)/p.sum; endcomp; compute before _page_ / center style=[font_weight=bold foreground=black background=white]; line 'Income by RC'; endcomp; run; * ods listing;

GPatel · ‎08-15-2012

Dear Cynthia, Ksharp, and LHV Your prompt and proposed soultion worked great. Appreciate your time and interest. I will use ODS style statements to display grids. Regards, Girish Patel

GPatel · ‎08-14-2012

Help with Proc Tabulate/Report formatting output. Data one; input reason : $ year $ cas pct ; cards; XYZ 2010 68 51.9084 Others 2010 63 48.0916 XYZ 2011 169 62.3616 Others 2011 102 37.63 XYZ 2012 88 56.0510 Others 2012 69 43.9494 ; run; How one create table like shown below with grid lines and exact column name either with proc report or proc tabulate? 2010 2011 2012 -------------------------------- XYZ_Cnt 68 169 88 XYZ_Pct 51.9 62.4 56.0 Others_Cnt 63 102 69 Others_PCt 48.0 37.6 43.9 My code shown below generates the output shown below, however, I would like to retain column name as shown above. Proc tabulate data=one order=data ; Class reason year; classlev reason /style=<parent>[foreground=black]; Var cas pct; table reason=' '*(cas='Xyz Count'*f=comma5. pct='Other Pct'*f=8.1), year=' ' / row=float; Key Label sum=' ' ; run; Output from above code: XYZ Xyz Count 68 169 88 Other Pct 51.9 62.4 56.1 Others Xyz Count 63 102 69 Other Pct 48.1 37.6 43.9

GPatel · ‎08-08-2012

Thanks Chris. This is what I was looking for.

GPatel · ‎08-08-2012

Chris, I tired that. I don't see any source code for either %_EG_CONDITIONAL_DROPDS or %_SAS_POPCHARTSIZE.

Online Status	Offline
Date Last Visited	‎05-17-2024 11:04 PM

Re: Abnormal characters in sas file

Re: Macro Quetion

Macro Quetion

How to create multiple excel file links in Job Execution

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Re: Can HASH Object do the same job?

Can HASH Object do the same job?

Re: Updating JSON files….

Re: Finding a Specific letter in Specific position in text

WEB SERVER CONFIGURATION ERROR at STAGE # 11 DURING INSTALL

How to compute trend factor for the given data?

Re: How to decorate line in Proc Report?

Re: How to decorate line in Proc Report?

Re: How to decorate line in Proc Report?

How to decorate line in Proc Report?

Re: Transactions per client

Re: SAS Format or User defined format?

SAS Format or User defined format?

Metadata Lisitings

Re: Inserting & displaying Image in EG/Store Process w/o ODS output

Inserting & displaying Image in EG/Store Process w/o ODS output

Re: Proc Tabulate/Report

Proc Tabulate/Report

Re: SAS EG %_sas_popchartsize Macro

Re: SAS EG %_sas_popchartsize Macro