BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
peter2
Obsidian | Level 7

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;

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

 

View solution in original post

1 REPLY 1
ballardw
Super User

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.

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 5475 views
  • 1 like
  • 2 in conversation