Hello, it's again me.
I make a "table de sythese" and missing values are with "." and i want "0" . How can I do?
Thanks
TITLE;
TITLE1 "Tables de synthèse";
FOOTNOTE;
FOOTNOTE1 "Généré par le Système SAS (&_SASSERVERNAME, &SYSSCPL) le %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) à %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))";
/* -------------------------------------------------------------------
Code généré par une tâche SAS
Généré le : lundi 1 août 2016 à 17:10:52
Par tâche : Tables de synthèse2
Données d'entrée : Local:WORK.FILTER_FOR_QUERY_FOR_ACP_LO_0000
Serveur : Local
------------------------------------------------------------------- */
%_eg_conditional_dropds(WORK.TRAITES_S);
/* -------------------------------------------------------------------
Exécuter la procédure TABULATE
------------------------------------------------------------------- */
PROC TABULATE
DATA=WORK.FILTER_FOR_QUERY_FOR_ACP_LO_0000
OUT=WORK.TRAITES_S(LABEL="Tables de synthèse pour WORK.FILTER_FOR_QUERY_FOR_ACP_LO_0000")
;
VAR "Identifiant opération"n;
CLASS "Thème"n / ORDER=UNFORMATTED MISSING;
CLASS "Centre financier"n / ORDER=UNFORMATTED MISSING;
TABLE /* Dimension de page */
'Centre financier'n,
/* Dimension de ligne */
'Thème'n,
/* Dimension de colonne */
N
ColPctN
/* Options de la table */
/ PRINTMISS MISSTEXT="0" INDENT=0 ;
;
RUN;
/* -------------------------------------------------------------------
Fin du code de la tâche.
------------------------------------------------------------------- */
RUN; QUIT;
TITLE; FOOTNOTE;
I believe that you may be referring to the output dataset WORK.TRAITES_S. Am I correct?
If you want a 0 to appear in table view of the data set you may either set
Options missing='0';
which would make all variables with missing appear as 0 until you reset the option to the default "." which you would do with another option statement.
Or if you only want those variables you could use a custom format such as:
Proc format;
value mymissing
.='0'
other=[best12.]
;
run;
And associate that format with the specific variables in the data set.
I believe that you may be referring to the output dataset WORK.TRAITES_S. Am I correct?
If you want a 0 to appear in table view of the data set you may either set
Options missing='0';
which would make all variables with missing appear as 0 until you reset the option to the default "." which you would do with another option statement.
Or if you only want those variables you could use a custom format such as:
Proc format;
value mymissing
.='0'
other=[best12.]
;
run;
And associate that format with the specific variables in the data set.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.