https://communities.sas.com/t5/New-SAS-User/Guidance-on-open-access-data-on-SAS/m-p/822735#M35027 <BR />Hi everyone, I am relatively new to the public health world. I am a fellow at a state health department and soon I would be needing to do SAS programming. During my graduate years, I do most of my programming needs in STATA. However I feel that the analysis and data management I have done in big datasets (i.e., NHANES, BRFSS) is incorrectly done. For example, I usually export the data to excel and manage the variables in excel.<BR /><BR />Any senior or intermediate epidemiologist or data analyst have any pointers of how they clean or manage their data? SAS coding is a new software for me to do.<BR /><BR />Thanks! Tue, 12 Jul 2022 02:19:29 GMT aigiss 2022-07-12T02:19:29Z https://communities.sas.com/t5/New-SAS-User/Guidance-on-open-access-data-on-SAS/m-p/822735#M35027 <BR />Hi everyone, I am relatively new to the public health world. I am a fellow at a state health department and soon I would be needing to do SAS programming. During my graduate years, I do most of my programming needs in STATA. However I feel that the analysis and data management I have done in big datasets (i.e., NHANES, BRFSS) is incorrectly done. For example, I usually export the data to excel and manage the variables in excel.<BR /><BR />Any senior or intermediate epidemiologist or data analyst have any pointers of how they clean or manage their data? SAS coding is a new software for me to do.<BR /><BR />Thanks! Tue, 12 Jul 2022 02:19:29 GMT https://communities.sas.com/t5/New-SAS-User/Guidance-on-open-access-data-on-SAS/m-p/822735#M35027 aigiss 2022-07-12T02:19:29Z https://communities.sas.com/t5/New-SAS-User/Guidance-on-open-access-data-on-SAS/m-p/822753#M35029 <P>I don't know why anyone would would attempt BRFSS or NHANES or similar data with Excel. Just getting the weights applied correctly can be a nightmare. If you go to the CDC websites for the data you should find SAS code to read text files into SAS or SAS data sets in transport format; helper code like Proc Format and typically some examples of basic summary statistics.</P> <P>&nbsp;</P> <P>Start with the free online SAS Programming 1.</P> <P>If you are working with any of the public use data sets look for the SAS code, code books/data dictionaries and example analysis code.</P> <P>You can find a large number results just putting "SAS BRFSS" or "SAS NHANES" or similar into any search engine. Though again if using those I would start on the CDC website for project specific.</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 12 Jul 2022 06:46:47 GMT https://communities.sas.com/t5/New-SAS-User/Guidance-on-open-access-data-on-SAS/m-p/822753#M35029 ballardw 2022-07-12T06:46:47Z