Create a SAS data set for observations starting with the 10th and ending with the 40th based on the female-master-applicant data set, which you have created for item 5. Use the appropriate data set option and the assignment statement or the SUM statement to calculate the average GPA (Ave_GPA) for those 31 students. Show the average GPA (i.e., the value of the Ave_GPA variable) from SAS Log or PROC PRINT output.
This is the general code I have right now:
data hi.femalesq6;
infile 'C:\Users\larkj\Desktop\STUDENT.DAT';
input SSN 1-9 sex $ 11 type $ 19 GPA 50-53;
run;
proc print data=hi.femalesq6(firstobs= 10 obs=40);
where sex='F' and type='M';
run;
When I add some kinda sum statement it just seems to create a new variable and print the same numbers as the gpa.
@larkjr18 wrote:
Create a SAS data set for observations starting with the 10th and ending with the 40th based on the female-master-applicant data set, which you have created for item 5. Use the appropriate data set option and the assignment statement or the SUM statement to calculate the average GPA (Ave_GPA) for those 31 students. Show the average GPA (i.e., the value of the Ave_GPA variable) from SAS Log or PROC PRINT output.
This is the general code I have right now:
data hi.femalesq6;
infile 'C:\Users\larkj\Desktop\STUDENT.DAT';
input SSN 1-9 sex $ 11 type $ 19 GPA 50-53;
run;
proc print data=hi.femalesq6(firstobs= 10 obs=40);
where sex='F' and type='M';
run;
When I add some kinda sum statement it just seems to create a new variable and print the same numbers as the gpa.
Proc means
When I tried proc means yesterday it didn't work. Here is my code for it.
proc means data=hi.femalesq6(firstobs=10 obs=40);
where sex='F' and type='M';
by GPA;
run;
Also posted a picture of the output.
Just figured out that I had by and not var thank you for the help though.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.