Proc freq ascending order

Koke — Sun, 23 Jul 2017 04:41:33 GMT

Hello all,

I want the table, which shows frequency of observation in ascending order

Here is my output

STATE1 Frequency NJ NY PA

STATE2 Frequency Frequency Missing = 1 NJ NY

STATE3 Frequency Frequency Missing = 1 CA PA

STATE4 Frequency Frequency Missing = 2 TX

STATE5 Frequency Frequency Missing = 2 GA

I want the table that has the frequency 1 come first and then 2 and 3.

here is my code

DATA STATE (drop = i);
   INFORMAT STATE1-STATE5 $2.;
   INPUT ID STATE1-STATE5;
   array vars[*] _character_; 
do i=1 to dim(vars);
if vars[i]= 'XX' then vars[i]= ' '; 
end;
DATALINES;
1   NY   NJ   PA   TX   GA
2   NJ   NY   CA   XX   XX
3   PA   XX   XX   XX   XX
;
proc
print data=state;

proc
freq data=state;
table STATE1-STATE5/ nocum nopercent;
run;

here is my log

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

62 DATA STATE (drop = i);

63 INFORMAT STATE1-STATE5 $2.;

64 INPUT ID STATE1-STATE5;

65 array vars[*] _character_;

66 do i=1 to dim(vars);

67 if vars[i]= 'XX' then vars[i]= ' ';

68 end;

69 DATALINES;

NOTE: The data set WORK.STATE has 3 observations and 6 variables.

NOTE: DATA statement used (Total process time):

real time 0.02 seconds

cpu time 0.02 seconds

73 ;

74 proc

75 print data=state;

NOTE: There were 3 observations read from the data set WORK.STATE.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.21 seconds

cpu time 0.22 seconds

77 proc

78 freq data=state;

79 table STATE1-STATE5/ nocum nopercent;

80 run;

NOTE: There were 3 observations read from the data set WORK.STATE.

NOTE: PROCEDURE FREQ used (Total process time):

real time 0.29 seconds

cpu time 0.27 seconds

82 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

thank you guys

Re: Proc freq ascending order

Ron_MacroMaven — Wed, 26 Jul 2017 12:20:35 GMT

save the output and sort it

PROC freq data = &syslast;

tables ... /noprint

out = list_values;

run;

PROC sort data = &syslast;

by count;

PROC print;

run;

Ron Fehd out-data maven

topic Re: Proc freq ascending order in SAS Programming

Proc freq ascending order

Re: Proc freq ascending order