topic Re: Proc freq-order by format in SAS Programming

Proc freq-order by format

Ronein — Wed, 02 Jan 2019 11:02:02 GMT

Hello

I want to perform multiple proc freq using Macro.

I want that in each explanatory variable the categories will be by formatted order.

When I run the following code I get an error.

I will be happy to learn what is wrong with this code and to see the correct code.

proc format;
value $Fm1t ( notsorted)
'Male'='M'
'Female'='F';
Run;

proc format;
value $Fm2t ( notsorted)
'Desirable'='Desirable'
'Borderline'='Borderline'
'High'='High';
Run;

proc format;
value $Fm3t ( notsorted)
'Underweight'='Underweight'
'Normal'='Normal weight'
'Overweight'='Overweight';
Run;

proc format;
value $Fm4t ( notsorted)
'Non-smoker'='Non-smoker'
'Light (1-5)'='Light Smoker (1-5)'
'Moderate (6-15)'='Moderate Smoker(6-15)'
'Heavy (16-25)'='Heavy Smoker(16-25)'
'Very Heavy (> 25)'='Very Heavy Smoker(> 25)';
Run;

proc format;
value $Fm5t ( notsorted)
'Optimal'='Optimal Blood Pressure'
'Normal'='Normal Blood Pressure'
'High'='High Blood Pressure';
Run;

Data heart;
set sashelp.heart;
Format sex $Fm1t.
Chol_Status $Fm2t.
Weight_Status $Fm3t.
Smoking_Status $Fm4t.
BP_Status $Fm5t.;
Run;



%macro mmacro1(pred,i); 
proc freq data=heart order=formatted;  
tables &pred*Status/chisq sparse outpct out=outfreq&i ;
output out=stats&i chisq;
format &pred $Fm&i.t;
run;
%mend;

%mmacro1(sex,1);
%mmacro1(Chol_Status,2);
%mmacro1(Weight_Status,3);
%mmacro1(Smoking_Status,4);
%mmacro1(BP_Status,5);

Re: Proc freq-order by format

PaigeMiller — Wed, 02 Jan 2019 11:50:58 GMT

When I run the following code I get an error.

What error? Show us the full SASLOG.

Re: Proc freq-order by format

Ronein — Wed, 02 Jan 2019 11:56:52 GMT

IF you run the code you will see the log.

NOTE: Line generated by the macro variable "I".
3840 $Fm1t
-
22
200
WARNING: Variable FM1T not found in data set WORK.HEART.

ERROR 22-322: Syntax error, expecting one of the following: a name, a format name, ;, -, :, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

ERROR 200-322: The symbol is not recognized and will be ignored."

Re: Proc freq-order by format

andreas_lds — Wed, 02 Jan 2019 12:02:01 GMT

In the line

format &pred $Fm&i.t;

you need another dot after the t:

format &pred $Fm&i.t.;

Re: Proc freq-order by format

Ronein — Wed, 02 Jan 2019 12:52:32 GMT

Perfect and thank you.

Can you please explain Why the sort is not working well? I want that categories will appear in same order as they appear in proc format.( frequencies in order as determined by the formatted value)

Joe

Re: Proc freq-order by format

ballardw — Thu, 03 Jan 2019 17:26:43 GMT

@Ronein wrote:

Perfect and thank you.

Can you please explain Why the sort is not working well? I want that categories will appear in same order as they appear in proc format.( frequencies in order as determined by the formatted value)

Joe

Similar to your other question on formatted order: Proc Freq uses the Formatted VALUE, not the order of appearance in a format definition to order the output.

So in these format definitions:

proc format;
value $Fm1t ( notsorted)
'Male'='M'
'Female'='F';  F is before M 
Run;

proc format;
value $Fm2t ( notsorted)
'Desirable'='Desirable'
'Borderline'='Borderline' Borderline is before Desirable
'High'='High';
Run;

proc format;
value $Fm3t ( notsorted)
'Underweight'='Underweight'
'Normal'='Normal weight'  Normal is before Underweight
'Overweight'='Overweight';
Run