Comment your code with what you think is happening to avoid issues like this.
When you import your data you're calling it : analysis.detailedCMA. However, when you try and use it, you're trying to use some data set called IMPORT instead? Is that a data set from somewhere else, or were you intending to use the CMA data?
The SAS programming classes are free and I would highly recommend taking some time to go through it if you're trying to learn SAS, especially if you're not familiar with the basic concepts yet.
*assigns a location where you can save your files between sessions;
libname Analysis '/folders/myfolders/research';
*imports the data;
*data is saved to analysis.detailedCMA;
proc import out= Analysis.DetailedCMA datafile= "/folders/myfolders/Research/Analysis 1906/CMA 1906.xlsx"
DBMS=xlsx Replace; SHEET="Detailed CMA";
GETNAMES=YES;
RUN;
*not sure what this is doing?????;
*data import; set import;
*Assume you intended this to summarize your analysis.detailedCMA data;
*it would run on any numerical variable;
title 'Summary statistics';
proc means data=analysis.detailedCMA ndec=2 n mean std median p25 p75 min max; var BMI; run;
Here's an example on calculating BMI and adding that to a data set.
data class;
set sashelp.class;
length category $20.;
bmi = 703*(weight/(height**2));
if bmi < 18 then
category='Under Weight';
else if 18 <= BMI < 25 then
category='Normal';
else if 25 <= BMI < 30 then
category ='Over Weight';
else if BMI >=30 then
category = 'Obese';
run;
... View more