cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ameey
‎04-25-2020
  • 19 Posts
  • 3 Likes Given
  • 0 Solutions
  • 3 Likes Received

ods and proc tabulate report

by Calcite | Level 5 in ODS and Base Reporting
‎05-07-2015 10:18 AM
‎05-07-2015 10:18 AM
Hi Cynthia/All Please guide me how can I keep the value of total column for a particular indicator as a blank cell in proc tabulate. As given below i have enclosed a the requirement sheet where we have to put blank cell in a total column for a particular indicators only and rest should come  with the sum of all months.  I have attached a small Data set and sas code. Anyone can reply me with correct solution. LIBNAME Amit 'C:\amit\code\RCH Indicatorwise'; run; data amit.DATA2 ; set Amit.DATA1( firstobs= 1 obs= 10000); run; data WORK.data2; set Amit.data2; run; ods Tagsets.Msoffice2k_x file="C:\amit\code\RCH Indicatorwise\C. Data ItemWise (Across States, Districts, Months and Blocks)\5. All States and Districts Across Months\&Finyear\All_India.xls"    options(             data_type="String,String,String,String,String,String,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number"             column_width="2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,3"                   orientation="landscape"                   pageheight="95%"                   pagewidth="100%"                   margin=".1in .1in .1in .3in"                   print_header_margin=".1in"                   print_footer_margin=".1in"                   fit2page="yes"                   excel_scale="95"                   Auto_format="list"             ) style=styles.Normal  headtext="<style> h1 {margin:0}</style>" ; /*ods Tagsets.Msoffice2k_x file="&path.SASReports\C. Data ItemWise (Across States, Districts, Months and Blocks)\5. All States and Districts Across Months\&Finyear\All_India.xls" */ /*   options(*/ /*            data_type="String,String,String,String,String,String,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number,Number"*/ /*            column_width="2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,3"*/ /*                  orientation="landscape"*/ /*                  pageheight="95%"*/ /*                  pagewidth="100%"*/ /*                  margin=".1in .1in .1in .3in"*/ /*                  print_header_margin=".1in"*/ /*                  print_footer_margin=".1in"*/ /*                  fit2page="yes"*/ /*                  excel_scale="95"*/ /*                  Auto_format="list"*/ /*            ) style=styles.Normal  headtext="<style> h1 {margin:0}</style>"*/ /**/ /*;*/ /*ODS MSOffice2K file="C:\SASReports\I.Data ItemWise\&State\&State..xls" STYLE=normal; */ TITLE1   FONT="Trebuchet MS" height=3 color=black " Data ItemWise Report for - All India "; TITLE2   FONT="Trebuchet MS" height=3 color=black " Provisional Figures for - &Finyear "; /*TITLE3   FONT="verdana" height=4 color=black " Status As On: %SYSFUNC(DATE(), EURDFDE9.) at %SYSFUNC(TIME(), TIMEAMPM8.) ";*/ TITLE3   FONT="Trebuchet MS" height=3 color=black " Status As On: &Update "; /* -------------------------------------------------------------------    Run the tabulate procedure    ------------------------------------------------------------------- */ /**/ /*data WORK.Data2;*/ /*set work.data2;*/ /*total= '0';*/ /*run;*/ PROC TABULATE DATA=WORK.DATA2 STYLE={bordercolor=vigb};       VAR VALUE_N / STYLE={bordercolor=vigb} ;       CLASS STATENAME_V / ORDER=DATA MISSING; /*      CLASS DISTRICTNAME_V / ORDER=DATA MISSING;*/       CLASS MISCONSHEADERCODE_V /ORDER=DATA MISSING;       CLASS MISCONSHEADERNAME_V /ORDER=DATA MISSING;       CLASS MONTHNAME_V / ORDER =DATA MISSING;       CLASS DETAIL/ ascending  MISSING;           CLASSLEV STATENAME_V / STYLE={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' VJUST=TOP};       CLASSLEV MONTHNAME_V / STYLE={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' VJUST=TOP };       CLASSLEV MISCONSHEADERCODE_V / STYLE={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' VJUST=TOP};       CLASSLEV MISCONSHEADERNAME_V / STYLE={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' VJUST=TOP};       CLASSLEV DETAIL / STYLE={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' VJUST=TOP};       TABLE /* Row Dimension */ (STATENAME_V ={Label= 'State' style={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=20}}* /*DISTRICTNAME_V ={Label= 'District' style={FONT_FACE='dsr' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=20}}**/ /*     CODEWITHSECTION ={Label= ' ' style={FONT_FACE='dsr' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=20}}**/       MISCONSHEADERCODE_V ={Label= ' ' style={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=22}}*         MISCONSHEADERNAME_V ={Label= ' ' style={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=130}}*                   DETAIL ={Label= ' ' style={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=28}}), /* Column Dimension */ /*        (MONTHNAME_V=' ' total={Label=' ' style={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=58}})**/ /*                        VALUE_N   =' '*Sum='' *f=PRN. / MISSTEXT=' '  box={label=' ' style={bordercolor=vigb}};*/                                                       (MONTHNAME_V=' ' All={Label='Total' style={bordercolor=vigb color=vigb FONT_FACE='Trebuchet MS' FONT_SIZE=2 FONT_WEIGHT=bold just=Center VJUST=TOP cellwidth=58}})*                         VALUE_N   =' '*Sum='' *f=PRN. / MISSTEXT=' '  box={label=' ' style={bordercolor=vigb}};       ; RUN; ods _all_ close; ... View more

ods and proc tabulate report

by Calcite | Level 5 in ODS and Base Reporting
‎05-07-2015 10:13 AM
‎05-07-2015 10:13 AM
Hi Cynthia/All Please guide me how can I keep the value of total column for a particular indicator as a blank cell in proc tabulate. As given below i have enclosed a the requirement sheet where we have to put blank cell in a total column for a particular indicators only and rest should come  with the sum of all months.  I have attached a small Data set and sas code. Anyone can reply me with correct solution. ... View more

Re: Proc tabulate issue

by Calcite | Level 5 in SAS Procedures
‎05-07-2015 07:13 AM
‎05-07-2015 07:13 AM
Hi RW9 I have to use only proc tabulate and SAS ODS only. Sorry to say I did not get your answer. ... View more

Proc tabulate issue

by Calcite | Level 5 in SAS Procedures
‎05-07-2015 06:27 AM
‎05-07-2015 06:27 AM
Hi Cynthia/All Please guide me how can I keep the value of total column for a particular indicator as a blank cell in proc tabulate. As given below i have enclosed a the requirement sheet where we have to put blank cell in a total column for a particular indicators only and rest should come  with the sum of all months.  I have attached a small Data set and sas code. Anyone can reply me with correct solution. ... View more

Re: Proc tabulate issue

by Calcite | Level 5 in SAS Procedures
‎04-23-2015 05:50 AM
‎04-23-2015 05:50 AM
Hi, my data set is there in gip file and already i have used a proc format and  tried to move the B column value in left align but stll it is not moving in left. Even you can try with my dataset and sas code. ... View more

Proc tabulate issue

by Calcite | Level 5 in SAS Procedures
‎04-21-2015 05:37 AM
‎04-21-2015 05:37 AM
Hi Cynthia/ All This is same report, Here is sub header B where there value is coming in a right alignment because in label it is numeric character and using proc format  I have changed the value into a printable character value. Now this character value is still coming in right alignment now I have to put in left alignment which is not going. I have tried to solve it but unable to do it. Please help me out how can i do it. Herewith i am sharing a data set with sas code, print screen of output and desired output. ... View more

proc tabulate issue

by Calcite | Level 5 in ODS and Base Reporting
‎03-26-2015 10:51 PM
‎03-26-2015 10:51 PM
Dear Cynthia/ All Expert, I took the help in same report earlier also and that was the excellent solution you shared to me . Again there is one change using proc tabulate in same report. I have to put the header A, B C , D , E with formula , F with formula in a separate row. To better understanding  I am sharing the data set with SAS code as well desired excel output sheet to compare with generate excel report. Also I sent you print screens of source report ( which i created previous ) and target report ( changes according to this ). This is request please do needful help even I am trying to resolve it but i am not getting a perfect solution. proc format; value abc  1='Eligible Couples'               2='Estd. Live Births'               3='children aged less than 10 years of age'               4='children aged less than 16 years of age'               5='children of 3 year of age'               6='children of 5 years of age'               7='children of 9 years of age'               8='children upto 1 year of age'               9='pregnant women'               10=' ' ; ODS tagsets.MSOFFICE2k_x FILE="C:\amit\code\RCH Indicatorwise\All_India.xls" STYLE=NORMAL headtext="<style> h1 {margin:0}</style>" ; /*x md "C:\amit\code\RCH Indicatorwise\H. RCH Reports - State Wise\&Financial_Year\MonthUpTo&Month_Name";*/ /**/ /*ODS Msoffice2k_x FILE="C:\amit\code\RCH Indicatorwise\H. RCH Reports - State Wise\&Financial_Year\MonthUpTo&Month_Name\All_India.xls" */ /*STYLE=NORMAL headtext="<style> h1 {margin:0}</style>";*/ /*Title*/ TITLE1 j=c font='verdana' color=black  height=4 BOLD justify=left underlin=0 " Performance on RCH Indicators: India "; Title2 j=l font='Verdana' color=black  height=3 bold underlin=0 "India"; TITLE3 j=l font=Verdana color=black  height=2 bold underlin=0 "For the period: April 2013 to June 2013"; /*TITLE3 j=l font=Verdana color=black  height=2 bold underlin=0 "For the period: April &YEAR1 to &Month_Name &YEAR5";*/ TITLE4 j=l font=Verdana color=black  height=2 bold underlin=0 "As on 20Jul 2012, 11:00 AM"; /*TITLE4 j=l font=Verdana color=black  height=2 bold underlin=0 "As on &dt";*/ /*TITLE6 j=l font=Verdana color=black  height=2 bold underlin=0 "As on &date,&time1";*/ TITLE5 j=r font=Verdana color=black italic height=2 bold underlin=0 "Refreshed on weekly basis"; FOOTNOTE1 font=verdana  height=1 bold j=left "Note:"; FOOTNOTE2 font=verdana  height=1 j=left "Provisional Figures"; data Work.APPEND_TABLE3; set Work.APPEND_TABLE3; /*Need="Need Assessed";*/ Need=" "; Achievement="Achievement during April to &Month_Name "; India="India"; run; PROC TABULATE DATA=Work.APPEND_TABLE3 STYLE={bordercolor=#000000 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN}; VAR NeedAssessed code  CurrFinYearAchivement PreFinYearAchivement PercentageChange PercentagechangeNeedAssessed PerFill / STYLE={bordercolor= #000000 FONT_SIZE=.01 background=#fbf6d9 color=vigb} ; CLASS ReportTypeDecs_V / STYLE=[bordercolor=#000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; CLASS ReportType_v / STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; CLASS Achievement/ STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; CLASS NEED/ STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; class India/ STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] order=unformatted missing; CLASS SNO /STYLE=[bordercolor=#000000 FONT_SIZE=.01 color=vigb] ORDER=UNFORMATTED MISSING; CLASS Item_code / STYLE=[bordercolor= #000000 FONT_SIZE=.01 background=#fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; classlev SNO /  STYLE={bordercolor=#000000 FONT_SIZE=.01 color=vigb FONT_FACE='Calibri'}; classlev ReportTypeDecs_V /  STYLE={bordercolor=#000000 FONT_SIZE=.01 color=vigb FONT_FACE='Calibri'}; classlev ReportType_v /  STYLE={bordercolor=#000000 FONT_SIZE=.01 color=vigb FONT_FACE='Calibri'}; classlev  Achievement / style=[background= #fbf6d9 FONT_SIZE=.01 bordercolor=#000000 color=vigb FONT_FACE='Calibri']; classlev  Need / style=[background= #fbf6d9 FONT_SIZE=.01 bordercolor=#000000 color=vigb FONT_FACE='Calibri']; classlev  India / style=[background= #fbf6d9 FONT_SIZE=.01 bordercolor=#000000 color=vigb FONT_FACE='Calibri']; TABLE /* ROW Statement */ ReportType_v={LABEL='Indicator Group' STYLE(CLASSLEV)={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=116 vjust=top}}* SNO ={LABEL='S.No. ' STYLE(CLASSLEV)={bordercolor=#000000 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=60}}* Item_code={LABEL='Item Code (As per HMIS formats)' STYLE(CLASSLEV)={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=240 vjust=top}}* ReportTypeDecs_V ={LABEL='Item ' STYLE(CLASSLEV)={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=240}} , /* COLUMN Statement */ Sum ={LABEL="Need Assessed (&YEAR1-&YEAR2)" STYLE={FONT_FACE='Calibri' bordercolor=#000000 color=vigb FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN background=#fbf6d9 cellwidth=162 cellheight=10 vjust=C}}* ( NeedAssessed ={LABEL="Nos.                          (A)    " STYLE={FONT_FACE='Calibri' bordercolor=#000000 color=vigb FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN background=#fbf6d9 cellwidth=100 cellheight=40 Vjust=center }} code ={LABEL="Units                            (B)" STYLE={FONT_FACE='Calibri' bordercolor=#000000 color=vigb FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN background=#fbf6d9 cellwidth=62 cellheight=40 vjust=center}} ) Achievement={LABEL=" " STYLE={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=390 cellheight=1 vjust=top }}* ( India={LABEL=" " STYLE={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN JUST=CENTER vjust=top cellwidth=390 cellheight=1}}* ( CurrFinYearAchivement ={LABEL="      (&YEAR1-&YEAR2)            (C)                  " STYLE={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=91    Vjust=center}}* Sum ={LABEL=''}*f=TonsNum.* {STYLE={FONT_FACE='Calibri' FONT_SIZE=.01 FONT_STYLE=ROMAN FONT_WEIGHT=MEDIUM JUST=right bordercolor=#000000}} PreFinYearAchivement ={LABEL="        (&YEAR3-&YEAR4)            (D)                  " STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=91  Vjust=center just=center}}* Sum ={LABEL=''}*f=TonsNum.* {STYLE={FONT_FACE='Calibri' FONT_SIZE=.01 FONT_STYLE=ROMAN FONT_WEIGHT=MEDIUM bordercolor=#000000}} PercentageChange  ={LABEL='% Change                                                                                (E =((C-D)/D)*100)' STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=91 Vjust=center}}* Sum ={LABEL=''}*f=12.1* {STYLE={HTMLSTYLE="VND.MS-EXCEL.NUMBERFORMAT:#0.0" FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN JUST=right bordercolor=#000000}}) ) PercentagechangeNeedAssessed  ={LABEL="% Achievement of need assessed    (&YEAR1-&YEAR2)                                                                 (F =(C/A)*100)" STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=134 cellheight= 50 vjust= C}}* Sum ={LABEL=''}*f=12.1* {STYLE={HTMLSTYLE="VND.MS-EXCEL.NUMBERFORMAT:#0.0" FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN JUST=right bordercolor=#000000}}   / BOX={LABEL="Indicators" STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE= .4 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN VJUST=center cellpadding=0}} style =[bordercolor=black BorderWidth=1 ]  MISSTEXT=' ' ; RUN; TITLE; FOOTNOTE; run;quit; ODS _ALL_ CLOSE; Regards, +918010732125 India ... View more

Re: Proc tabulate issue

by Calcite | Level 5 in ODS and Base Reporting
‎03-26-2015 10:39 PM
‎03-26-2015 10:39 PM
Dear Cynthia/ All Expert, I took the help in same report earlier also and that was the excellent solution you shared to me . Again there is one change using proc tabulate in same report. I have to put the header A, B C , D , E with formula , F with formula in a separate row. To better understanding  I am sharing the data set with SAS code as well desired excel output sheet to compare with generate excel report. Also I sent you print screens of source report ( which i created previous ) and target report ( changes according to this ). This is request please do needful help even I am trying to resolve it but i am not getting a perfect solution. I am trying to attched dataset and code also but this is not taking attachment that what i am taking a help on previous comment and here already my dataset and code is available . programe LIBNAME Amit 'C:\amit\code\RCH Indicatorwise'; data Work.APPEND_TABLE3; set Amit.APPEND_TABLE3; run; proc format; value abc  1='Eligible Couples'               2='Estd. Live Births'               3='children aged less than 10 years of age'               4='children aged less than 16 years of age'               5='children of 3 year of age'               6='children of 5 years of age'               7='children of 9 years of age'               8='children upto 1 year of age'               9='pregnant women'               10=' ' ; ODS tagsets.MSOFFICE2k_x FILE="C:\amit\code\RCH Indicatorwise\All_India.xls" STYLE=NORMAL headtext="<style> h1 {margin:0}</style>" ; /*x md "C:\amit\code\RCH Indicatorwise\H. RCH Reports - State Wise\&Financial_Year\MonthUpTo&Month_Name";*/ /**/ /*ODS Msoffice2k_x FILE="C:\amit\code\RCH Indicatorwise\H. RCH Reports - State Wise\&Financial_Year\MonthUpTo&Month_Name\All_India.xls" */ /*STYLE=NORMAL headtext="<style> h1 {margin:0}</style>";*/ /*Title*/ TITLE1 j=c font='verdana' color=black  height=4 BOLD justify=left underlin=0 " Performance on RCH Indicators: India "; Title2 j=l font='Verdana' color=black  height=3 bold underlin=0 "India"; TITLE3 j=l font=Verdana color=black  height=2 bold underlin=0 "For the period: April 2013 to June 2013"; /*TITLE3 j=l font=Verdana color=black  height=2 bold underlin=0 "For the period: April &YEAR1 to &Month_Name &YEAR5";*/ TITLE4 j=l font=Verdana color=black  height=2 bold underlin=0 "As on 20Jul 2012, 11:00 AM"; /*TITLE4 j=l font=Verdana color=black  height=2 bold underlin=0 "As on &dt";*/ /*TITLE6 j=l font=Verdana color=black  height=2 bold underlin=0 "As on &date,&time1";*/ TITLE5 j=r font=Verdana color=black italic height=2 bold underlin=0 "Refreshed on weekly basis"; FOOTNOTE1 font=verdana  height=1 bold j=left "Note:"; FOOTNOTE2 font=verdana  height=1 j=left "Provisional Figures"; data Work.APPEND_TABLE3; set Work.APPEND_TABLE3; /*Need="Need Assessed";*/ Need=" "; Achievement="Achievement during April to &Month_Name "; India="India"; run;     PROC TABULATE DATA=Work.APPEND_TABLE3 STYLE={bordercolor=#000000 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN}; VAR NeedAssessed code  CurrFinYearAchivement PreFinYearAchivement PercentageChange PercentagechangeNeedAssessed PerFill / STYLE={bordercolor= #000000 FONT_SIZE=.01 background=#fbf6d9 color=vigb} ; CLASS ReportTypeDecs_V / STYLE=[bordercolor=#000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; CLASS ReportType_v / STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; CLASS Achievement/ STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; CLASS NEED/ STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; class India/ STYLE=[bordercolor= #000000 FONT_SIZE=.01 background= #fbf6d9 color=vigb] order=unformatted missing; CLASS SNO /STYLE=[bordercolor=#000000 FONT_SIZE=.01 color=vigb] ORDER=UNFORMATTED MISSING; CLASS Item_code / STYLE=[bordercolor= #000000 FONT_SIZE=.01 background=#fbf6d9 color=vigb] ORDER=UNFORMATTED MISSING; classlev SNO /  STYLE={bordercolor=#000000 FONT_SIZE=.01 color=vigb FONT_FACE='Calibri'}; classlev ReportTypeDecs_V /  STYLE={bordercolor=#000000 FONT_SIZE=.01 color=vigb FONT_FACE='Calibri'}; classlev ReportType_v /  STYLE={bordercolor=#000000 FONT_SIZE=.01 color=vigb FONT_FACE='Calibri'}; classlev  Achievement / style=[background= #fbf6d9 FONT_SIZE=.01 bordercolor=#000000 color=vigb FONT_FACE='Calibri']; classlev  Need / style=[background= #fbf6d9 FONT_SIZE=.01 bordercolor=#000000 color=vigb FONT_FACE='Calibri']; classlev  India / style=[background= #fbf6d9 FONT_SIZE=.01 bordercolor=#000000 color=vigb FONT_FACE='Calibri']; TABLE /* ROW Statement */   ReportType_v={LABEL='Indicator Group' STYLE(CLASSLEV)={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=116 vjust=top}}* SNO ={LABEL='S.No. ' STYLE(CLASSLEV)={bordercolor=#000000 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=60}}* Item_code={LABEL='Item Code (As per HMIS formats)' STYLE(CLASSLEV)={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=240 vjust=top}}* ReportTypeDecs_V ={LABEL='Item ' STYLE(CLASSLEV)={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN cellwidth=240}} , /* COLUMN Statement */ Sum ={LABEL="Need Assessed (&YEAR1-&YEAR2)" STYLE={FONT_FACE='Calibri' bordercolor=#000000 color=vigb FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN background=#fbf6d9 cellwidth=162 cellheight=10 vjust=C}}* ( NeedAssessed ={LABEL="Nos.                           (A)     " STYLE={FONT_FACE='Calibri' bordercolor=#000000 color=vigb FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN background=#fbf6d9 cellwidth=100 cellheight=40 Vjust=center }} code ={LABEL="Units                            (B)" STYLE={FONT_FACE='Calibri' bordercolor=#000000 color=vigb FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN background=#fbf6d9 cellwidth=62 cellheight=40 vjust=center}} ) Achievement={LABEL=" " STYLE={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=390 cellheight=1 vjust=top }}* ( India={LABEL=" " STYLE={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN JUST=CENTER vjust=top cellwidth=390 cellheight=1}}* ( CurrFinYearAchivement ={LABEL="       (&YEAR1-&YEAR2)            (C)                   " STYLE={bordercolor=#000000 color=vigb background= #fbf6d9 FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=91    Vjust=center}}* Sum ={LABEL=''}*f=TonsNum.* {STYLE={FONT_FACE='Calibri' FONT_SIZE=.01 FONT_STYLE=ROMAN FONT_WEIGHT=MEDIUM JUST=right bordercolor=#000000}} PreFinYearAchivement ={LABEL="        (&YEAR3-&YEAR4)             (D)                  " STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=91  Vjust=center just=center}}* Sum ={LABEL=''}*f=TonsNum.* {STYLE={FONT_FACE='Calibri' FONT_SIZE=.01 FONT_STYLE=ROMAN FONT_WEIGHT=MEDIUM bordercolor=#000000}} PercentageChange  ={LABEL='% Change                                                                                (E =((C-D)/D)*100)' STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=91 Vjust=center}}* Sum ={LABEL=''}*f=12.1* {STYLE={HTMLSTYLE="VND.MS-EXCEL.NUMBERFORMAT:#0.0" FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN JUST=right bordercolor=#000000}}) )  PercentagechangeNeedAssessed  ={LABEL="% Achievement of need assessed     (&YEAR1-&YEAR2)                                                                       (F =(C/A)*100)" STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN cellwidth=134 cellheight= 50 vjust= C}}* Sum ={LABEL=''}*f=12.1*  {STYLE={HTMLSTYLE="VND.MS-EXCEL.NUMBERFORMAT:#0.0" FONT_FACE='Calibri' FONT_SIZE=.01 FONT_WEIGHT=MEDIUM FONT_STYLE=ROMAN JUST=right bordercolor=#000000}}         / BOX={LABEL="Indicators" STYLE={bordercolor=#000000 background= #fbf6d9 color=vigb FONT_FACE='Calibri' FONT_SIZE= .4 FONT_WEIGHT=BOLD FONT_STYLE=ROMAN VJUST=center cellpadding=0}} style =[bordercolor=black BorderWidth=1 ]  MISSTEXT=' ' ; RUN; TITLE; FOOTNOTE; run;quit; ODS _ALL_ CLOSE; Regards, Regards, +918010732125 ... View more

Re: help to rename the sheet name using ods msoffice2k_x only

by Calcite | Level 5 in ODS and Base Reporting
‎10-21-2014 05:10 AM
‎10-21-2014 05:10 AM
Hi cynthia I applied a same  code using ODS TAGSETS.MSOFFICE2K_X which is mentioned in sas support link but still sheet name is not changing. I am not understanding if this code is mentioned on sas support link then why it doest not work and unable to renaming excel report sheet name (Actually I have more then 50 reports where I have to rename excel sheet name by sas code only because by default it is not taking more then 32 character name and this is mandatory for   me to use ODS TAGSETS.MSOFFICE2K_X only..please if possible then help me  or guide me how can I do it. Base SAS: The MSOffice2K_x Tagset Adds Options to the MSOffice2K Tagset  ... View more

Re: help to rename the sheet name using ods msoffice2k_x only

by Calcite | Level 5 in ODS and Base Reporting
‎10-20-2014 03:08 AM
‎10-20-2014 03:08 AM
HI Mohamed This additional code msoffice2k_x has been run successfully but till as per code sheet name is not renaming.Still this sas code is not giving me desired output. ... View more

Re: help to rename the sheet name using ods msoffice2k_x only

by Calcite | Level 5 in ODS and Base Reporting
‎10-20-2014 01:31 AM
‎10-20-2014 01:31 AM
Hi Cynthia Please reply. ... View more

help to rename the sheet name using ods msoffice2k_x only

by Calcite | Level 5 in ODS and Base Reporting
‎10-17-2014 06:58 AM
‎10-17-2014 06:58 AM
Dear Cynthia / All . I am sharing one link of sas support as well as screen shot where u can check we can rename the sheet name using ods TAGSETS.MSOFFCE2K_X  but still I am facing one problem. when I follow this code and  generate my excel sheet using ods tagsets.MSOFFICE2K_X and once the file has been generated and I go to open this file it is giving a one pop message and due to this I am unable to check my output. I am sharing screen shot this pop message , please check and help me out  why this is happening  because I am stuck here. Base SAS: The MSOffice2K_x Tagset Adds Options to the MSOffice2K Tagset ... View more

Re: Remove sheet name from ods tagsets.msoffice2k_x

by Calcite | Level 5 in ODS and Base Reporting
‎10-17-2014 06:48 AM
‎10-17-2014 06:48 AM
Dear RW9 Sorry to say but this possible. I am sharing one link of sas support as well screen shot where u can check that this is possible to rename yr sheet name using ods tagsets.msoffice2k_x and this link is by sas support only. Base SAS: The MSOffice2K_x Tagset Adds Options to the MSOffice2K Tagset but still I am facing one problem. when I follow this code and  generate my excel sheet using ods tagsets.MSOFFICE2K_X and once the file has been generated and I open this file it is giving a one pop message and due to this I am unable to check my output.So please anyone help me out because here I am stuck. ... View more

Re: Remove sheet name from ods tagsets.msoffice2k_x

by Calcite | Level 5 in ODS and Base Reporting
‎10-17-2014 05:04 AM
‎10-17-2014 05:04 AM
Hi Thanks for your quick response. Yes you r true tagsets,Msoffice2k_x is inherited from tagsets,Msoffice2k. But i can not take any other other format ( eg. excelXp, msoffice2k). I have only option to use msoffice2k_x because this my client need and i want either rename my sheet name or it will come as "sheet 1" .. Please  share your knowledge. if any one can help me out. Regards ... View more

Remove sheet name from ods tagsets.msoffice2k_x

by Calcite | Level 5 in ODS and Base Reporting
‎10-17-2014 02:48 AM
‎10-17-2014 02:48 AM
Hi Cynthia/ All This is common question whenever we use ods tagsets.Msoffice2k_x to generate excel reports that time by default sheet name of excel worksheet retains the same name of excel sheet name that i do not want in tagsets.msoffice2k_x. Please tell me if any one know how can I bring the sheet name by blank name ( no sheet name)  or how can i rename the sheet name in ods  tagsets.Msoffice2k_x. only. I am giving a test data set and screen shot of error ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-25-2020 09:10 PM
Likes given to
View All
Likes from
View All
Quick links