Call define: how to assign the percent format

SASdevAnneMarie — Fri, 13 Nov 2020 16:46:25 GMT

Hello Experts,

I would like to assign a percent format for my data in call define.

When I use the statement: call define(_col_,'format','percent8.2') I have all time the error that my server is deconnected.

I joined my input data.

The code is:

ods noresults;
	ods excel file="&Rep_Travail.\&DatePubli._&fichier_final." options(sheet_name='Stats_LinkedIn_Twitter');

	proc report data=donnee_marketing_&numtab noheader nowd style(column)=[textalign=left verticalalign=top];
		columns

			%do i=1 %to &nombre_var;
				VAR&i.
			%end;
		;

		
		compute VAR7;

			if anydigit(VAR1) then
				do;
					call define(_col_,'format','percent8.2');
				end;
		endcomp;

		compute VAR2;

			if anydigit(VAR1) then
				do;
					call define(_col_,'url',VAR2 );
					call define(_col_,'style','style={textdecoration=underline color=blue}');
				end;
			else
				do;
					call define(_ROW_, "style", "STYLE=[BACKGROUND=#00acee font_size = 11pt font_face = 'Arial' font_weight = bold color=white ]");
				end;
		endcomp;
	run;

	ods excel close;

Re: Call define: how to assign the percent format

Shmuel — Fri, 13 Nov 2020 16:59:26 GMT

As you export the output to excel you should change the cells' format in excel itself.

II don't know if it can be done in sas.

topic Call define: how to assign the percent format in SAS Programming

Call define: how to assign the percent format

Re: Call define: how to assign the percent format