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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.