About radha009

radha009 · ‎04-23-2018

How to subtract and get the % from the below table in SAS. - Thank you difference = mar.test1-feb.test1 % =mar.test1-feb.test1/feb.test1 month test1 test2 test3 test4 test5 Jan 357 240 421 231 174 Feb 358 305 557 182 359 Mar 277 245 568 279 329 difference %

radha009 · ‎04-23-2018

Proc sql; Create table work.Ent_L2_Apps as SELECT Affected_CI, COUNT(Affected_CI) as count FROM dash.Ent_L2_inc GROUP BY Affected_CI HAVING COUNT (Affected_CI)=( SELECT MAX(count) FROM ( SELECT Affected_CI, COUNT(Affected_CI) as count FROM dash.Ent_L2_inc GROUP BY Affected_CI)); quit; proc sql; Create table work.Ent_L2_Apps1 as SELECT Affected_CI, COUNT(Affected_CI) as count FROM work.Ent_L2_prev GROUP BY Affected_CI HAVING COUNT (Affected_CI)=( SELECT MAX(count) FROM ( SELECT Affected_CI, COUNT(Affected_CI) as count FROM work.Ent_L2_prev GROUP BY Affected_CI)); quit; proc sql; Create table work.Ent_L2_Apps2 as SELECT Affected_CI, COUNT(Affected_CI) as count FROM work.Ent_L2_old GROUP BY Affected_CI HAVING COUNT (Affected_CI)=( SELECT MAX(count) FROM ( SELECT Affected_CI, COUNT(Affected_CI) as count FROM work.Ent_L2_old GROUP BY Affected_CI)); quit; data dash.Ent_Top_apps; set work.Ent_L2_Apps2(firstobs=1 obs=1) work.Ent_L2_Apps1 (firstobs=1 obs=1) work.Ent_L2_Apps (firstobs=1 obs=1); run;

radha009 · ‎04-23-2018

resolved in adding below code: ods excel options(sheet_interval="table"); ods exclude all; data _null_; file print; put _all_; run; ods select all;

radha009 · ‎04-23-2018

NOTE: There were 3 observations read from the data set DASH.ICM_MAJOR_INC. NOTE: PROCEDURE REPORT used (Total process time): real time 0.07 seconds cpu time 0.03 seconds ERROR: Argument now for word option sheet_interval not recognized. Expecting one of these keywords output, table, page, bygroup, bygroups, proc, none or none. 12015 ods excel options(sheet_name='MF_BTO' embedded_titles="yes" sheet_interval='now' ); 12016 title "All Incidents - MF by Group"; 12017 proc report data=dash.MF_AllInc_Final;

radha009 · ‎04-23-2018

expecting one Ent_BTO ,ICM_BTO tabs with datasets and graph in each sheet.

radha009 · ‎04-23-2018

with excel the graph is working fine but it is displaying different sheet. ods listing close; ods excel file="C:\Dashboard\SAS\Dash2.xlsx" options(sheet_name='Ent_BTO') style=styles.sansprinter;; proc report data=dash.Ent_AllInc_Final; run; proc report data=dash.ENT_L2Inc_Final; run; proc report data=dash.Ent_Top_apps; run; ods graphics / height=600 width=1000 noborder; proc sgplot data=dash.Ent_Top_apps; vbar Affected_CI / reponse=count stat=mean fillattrs=(color=lightblue) barwidth= .25; xaxis display=(nolabel); yaxis display=(nolabel) grid; run; ods excel options(sheet_name='ICM_BTO' embedded_titles="yes" ); proc report data=dash.ICM_AllInc_Final; run; proc report data=dash.ICM_Top_apps; run; ods graphics / height=600 width=1000 noborder; proc sgplot data=dash.ICM_Top_apps; vbar Affected_CI / reponse=count stat=mean fillattrs=(color=lightblue) barwidth= .25; xaxis display=(nolabel); yaxis display=(nolabel) grid; run; proc report data=dash.ICM_change_req; run; ods excel options(sheet_name='MF_BTO' embedded_titles="yes" ); proc report data=dash.MF_AllInc_Final; run; proc report data=dash.MF_L2Inc_Final; run; proc report data=dash.MF_pie_Final; run; ods graphics / height=600 width=1000 noborder; proc sgplot data=dash.MF_Top_apps; vbar Affected_CI / reponse=count stat=mean fillattrs=(color=lightblue) barwidth= .25; xaxis display=(nolabel); yaxis display=(nolabel) grid; run; proc report data=dash.MF_Major_INC; run; ods excel options(sheet_name='SFSS_BTO' embedded_titles="yes" ); proc report data=dash.SFSS_AllInc_Final; run; proc report data=dash.SFSS_L2Inc_Final; run; proc report data=dash.SFSS_pie_Final; run; ods excel close; ods listing; run;

radha009 · ‎04-22-2018

i started writing my code with excel and then changed to excelxp due to i have 3 datasets & 1 graph to display in multiple sheets, sheet 1( 3 datasets and graph) sheet2 ( 3 datasets and graph) sheet 3 ( 2 datasets and 2 graph) with excel all data is displaying in one sheet.so i changed to excelxp the multiplesheet issue is resolved but graphs are not displaying. How to display datasets and graph in multiple sheets. Thanks a lot in advance.

radha009 · ‎04-22-2018

I have top 3 month apps.with same name. want to add month next to the data. is it possible to add or merge two variables apps count pmf 34 pmf 23 pmf 12 expected apps count pmf (march) 34 pmf (feb) 23 pmf (jan) 12

radha009 · ‎04-22-2018

The graph is not exporting to excel all datasets are displaying ods tagsets.excelxp file="C:\Dashboard\SAS\Dashboard.xml" style=styles.excel_update options(sheet_name='Ent' embedded_titles="yes" sheet_interval="none"); proc report data=dash.Ent_AllInc_Final; run; proc report data=dash.ENT_L2Inc_Final; run; proc report data=dash.Ent_pie_Final; run; proc report data=dash.Ent_Top_apps; run; proc report data=dash.Ent_change_req; run; proc sgplot data=dash.Ent_Top_apps; vbar Affected_CI / reponse=count stat=mean fillattrs=(color=lightblue) barwidth= .25; xaxis display=(nolabel); yaxis display=(nolabel) grid; run; ods excel close;

radha009 · ‎04-22-2018

sorry for the typos and the wording. I want to create a report to show the cells colored if the data doesn't match. my data few variables are dynamic,every month it will be different but they have a number start with chg so i am putting all columns which starts with %chg%. ------------------------ data comp.check5; merge descope.load2sp_ds (in=ina) comp.check4; by Name CI_ID; if ina; run; proc sql noprint; select name into :varlist separated by ' ' from dictionary.columns where libname = "COMP" and memname = "CHECK1" and name like '%CHG%'; quit; proc report data=comp.check5 nowd; column Name ID test1 test2 flag_: Impacted_Flag Validation_required Validation_status Validator_Name flag_:&varlist. Maint_Window; define Name / display style(column)=[just=left cellwidth=3.1in]'Name'; define CI_ID / display style(column)=[just=left cellwidth=1.1in] 'ID'; define flag_: / noprint display; define Impacted_Flag / display style(column)=[just=center cellwidth=1.1in] 'Impacted'; define var / computed display style(column)=[just=center cellwidth=1.1in]; compute Impacted_Flag; if FLAG_Impacted_flag = 2 then call define(_col_, "style", "style=[background=yellow]"); endcomp; compute var; do i = 1 to dim(var) ; if FLAG_:&varlist. = 2 then call define(_col_, "style", "style=[background=yellow]"); end; endcomp;

radha009 · ‎04-22-2018

Got it. but how do i transform the data. should i create new table and insert the data.

radha009 · ‎04-22-2018

How to compute macro variable in proc report, the &varlist. is displaying all column names as one. how to call only one column name. proc sq; select name into :varlist from the dictionary.columns where memname='test'; proc report data=qtrresults column ID test1 test2 &varlist. ; define ID / display "ID"; define test1 /display "test1"; define &varlist. /display; compute &varlist.; if flag:_&varlist. =2 then call define('dummy3',"style", "style=[font_style=italic background=yellow]"); end; end comp;

radha009 · ‎04-22-2018

I want to create a bar chart using sas code with data as below with sgplot. PROC SGPLOT DATA = applications; VBAR sys / RESPONSE = app; VBAR sys / RESPONSE = env; RUN; Sys app env a 67 45 b 20 54 c 35 60 d 40 78

radha009 · ‎04-18-2018

i have in my code all mapped to the drive and path ss H://SAS/code/libraries/temp1\. if any one want to run the code they do not have the same drive mapping. i tried the below without drive. it didn't work. libname test "Support(\\pe2s432424t3\PE22f2S41)\SAS\Code\libraries\temp1\";

radha009 · ‎04-17-2018

How to proc report with microvariable column names. My column names are from dictionary. Columns into varlist. How I display column name in proc report, define and compute the varlist column names. The varlist column names will be dynamic it will not be always same.

Online Status	Offline
Date Last Visited	‎03-17-2020 03:22 PM

column name with / special char

Launch a url in the browser and click the link

Error on connect to DB2

Re: email body font size and grid changes

email body font size and grid changes

Re: Hyperlink which open pop up with data

Hyperlink which open pop up with data

Re: proc report display date next to the variable name

Re: proc report display date next to the variable name

proc report display date next to the variable name

Re: do looping issue

Re: How to create 3d clustered column chart in sas

Re: How to create 3d clustered column chart in sas

Re: How to update dynamically created variable names

Re: Change the x-axis order in SGPLOT

subtract the values in a dataset

Re: add month to the cell data

Re: how to export graph into worksheet

Re: how to export graph into worksheet

Re: how to export graph into worksheet

Re: how to export graph into worksheet

Re: how to export graph into worksheet

add month to the cell data

how to export graph into worksheet

Re: proc report compute macro variable

Re: create a bar gragh with sgplot

proc report compute macro variable

create a bar gragh with sgplot

How to assign a library to unmapped with servername

Create Proc report with micro variables column names, define and compu...