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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.