This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
title "Simple proc means"; | |
/* Simple proc means */ | |
PROC MEANS DATA=SASHELP.CARS; | |
RUN; | |
title "Select the required variables & drop the labels"; | |
/* Select the variables & drop the labels */ | |
PROC MEANS DATA=SASHELP.CARS nolabels; | |
var |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from IPython.display import display | |
def multiFreq(dataset, variable_list): | |
for i in variable_list: | |
datax = dataset[f'{i}'].value_counts() | |
datay = pd.DataFrame({ | |
f'{i}': datax.index, | |
'Frequency': datax.values, | |
'Percent': ((datax.values/datax.values.sum())*100).round(2), | |
'Cumulative Frequency': datax.values.cumsum(), |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* freq procedure with multiple variables */ | |
proc freq data=hgrosser; | |
tables GENRE MOVIE; | |
run; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
datax = data['GENRE'].value_counts(dropna=False) | |
datay = pd.DataFrame({ | |
'GENRE': datax.index, | |
'Frequency': datax.values, | |
'Percent': ((datax.values/datax.values.sum())*100).round(2), | |
'Cumulative Frequency': datax.values.cumsum(), | |
'Cumulative Percent': ((datax.values.cumsum()/datax.values.sum())*100).round(2) | |
}) | |
datay |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* freq procedure with missing */ | |
proc freq data=Gov_C_SAS; | |
tables GENRE / missing; | |
run; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
datab = pd.crosstab(data.county, data.state, margins=True, margins_name='Total') | |
datab |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
proc freq data=Gov_C_SAS; | |
tables county*state / norow nocol nopercent; | |
run; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
datax = data['state'].value_counts().sort_index() | |
datay = pd.DataFrame({ | |
'state': datax.index, | |
'Frequency': datax.values | |
}) | |
datay |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
proc freq data = Gov_C_SAS; | |
tables state / nopercent nocum; | |
run; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
datax = data['state'].value_counts() | |
datay = pd.DataFrame({ | |
'state': datax.index, | |
'Frequency': datax.values, | |
'Percent': ((datax.values/datax.values.sum())*100).round(2), | |
'Cumulative Frequenc': datax.values.cumsum(), | |
'Cumulative Percen':((datax.values.cumsum()/datax.values.sum())*100).round(2) | |
}) | |
datay |
NewerOlder