topic Ods tagsets.excelxp : I cannot open if I remove a column from proc report in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Ods-tagsets-excelxp-I-cannot-open-if-I-remove-a-column-from-proc/m-p/209744#M1667 <HTML><HEAD></HEAD><BODY><P>Hi. sory for this poor indentation. In the code below, I am having an issue (I am running SAS 9.1.3) . column kl does not exist in my dataset. is I keep it, my output file can be open with excel, having missing values on column kl. If I remove it, my output file will not open and promts an error indicating table. What can be the reason why removing this column creates a file that I cannot open with ms excel? ods tagsets.excelxp&nbsp; options(sheet_name="LISTE"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gridlines="yes" orientation="landscape" panelcols="1"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; embedded_titles="NO"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frozen_headers="YES"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frozen_headers="1" autofilter="yes"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filter_colls="_all_"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autofilter_table="1" row_heights="75"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autofit_heights="no"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; );&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; proc report data=reftable.liste nowd ; column&nbsp; actif Portefeuille&nbsp; Conseiller&nbsp; Poste majeure equipe ps Agregat Portefeuille kl ; define Portefeuille /style(header)=vertcl_header&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; style(column)=[just=center]; define equipe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] "Équipe"; define poste&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; define majeure&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center]; define ps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] format=fm_num.; define Agregat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] "Agrégat"; define actif&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /computed style(column) ={tagattr='formula:=STRUCTURE_CAISSE!RC[0]'}; /* ;si(cherchev(RC[0];STRUCTURE_CAISSE!RC[0]:RC[0]);1;0) compute Actif; call define(_row_,"style","style={background=#ffffff}"); if actif eq 'X' then call define("actif","style","style={background=#99cc00}"); endcomp; */&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; run;&nbsp; quit; Please note that I only have an issue when I remove the column kl from the column statement of the proc report. If this column is ketp, the output file does open with missing values for column kl as kl does not apear in the input dataset. thanks in advance.</P></BODY></HTML> Fri, 28 Aug 2015 16:06:16 GMT cnwentsa 2015-08-28T16:06:16Z Ods tagsets.excelxp : I cannot open if I remove a column from proc report https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Ods-tagsets-excelxp-I-cannot-open-if-I-remove-a-column-from-proc/m-p/209744#M1667 <HTML><HEAD></HEAD><BODY><P>Hi. sory for this poor indentation. In the code below, I am having an issue (I am running SAS 9.1.3) . column kl does not exist in my dataset. is I keep it, my output file can be open with excel, having missing values on column kl. If I remove it, my output file will not open and promts an error indicating table. What can be the reason why removing this column creates a file that I cannot open with ms excel? ods tagsets.excelxp&nbsp; options(sheet_name="LISTE"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gridlines="yes" orientation="landscape" panelcols="1"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; embedded_titles="NO"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frozen_headers="YES"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; frozen_headers="1" autofilter="yes"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; filter_colls="_all_"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autofilter_table="1" row_heights="75"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autofit_heights="no"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; );&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; proc report data=reftable.liste nowd ; column&nbsp; actif Portefeuille&nbsp; Conseiller&nbsp; Poste majeure equipe ps Agregat Portefeuille kl ; define Portefeuille /style(header)=vertcl_header&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; style(column)=[just=center]; define equipe&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] "Équipe"; define poste&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; define majeure&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center]; define ps&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] format=fm_num.; define Agregat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /style(column)=[just=center] "Agrégat"; define actif&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /computed style(column) ={tagattr='formula:=STRUCTURE_CAISSE!RC[0]'}; /* ;si(cherchev(RC[0];STRUCTURE_CAISSE!RC[0]:RC[0]);1;0) compute Actif; call define(_row_,"style","style={background=#ffffff}"); if actif eq 'X' then call define("actif","style","style={background=#99cc00}"); endcomp; */&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; run;&nbsp; quit; Please note that I only have an issue when I remove the column kl from the column statement of the proc report. If this column is ketp, the output file does open with missing values for column kl as kl does not apear in the input dataset. thanks in advance.</P></BODY></HTML> Fri, 28 Aug 2015 16:06:16 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Ods-tagsets-excelxp-I-cannot-open-if-I-remove-a-column-from-proc/m-p/209744#M1667 cnwentsa 2015-08-28T16:06:16Z Re: Ods tagsets.excelxp : I cannot open if I remove a column from proc report https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Ods-tagsets-excelxp-I-cannot-open-if-I-remove-a-column-from-proc/m-p/224412#M1736 <P>That shouldn't be.&nbsp;<BR />Can you post the log from the code submitted?</P> Tue, 08 Sep 2015 15:09:24 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Ods-tagsets-excelxp-I-cannot-open-if-I-remove-a-column-from-proc/m-p/224412#M1736 Reeza 2015-09-08T15:09:24Z