BookmarkSubscribeRSS Feed
Sahrseb2020
Calcite | Level 5

 

Roll

Number

Class

Age

Gender

Subject

Sports

001

1

10

M

Maths

Cricket

002

1

11

M

English

Tennis

003

2

9

F

Maths

Football

004

4

7

F

Science

Football

005

3

7

M

Maths

Cricket

006

5

10

F

Science

Tennis

007

3

7

F

Art

Cricket

 

Questions

 

  1. Write code to see frequency distribution by Gender & Subject?  

 

  1. Write code to filter student age less than 10 and like football and Maths?             

 

  1. Write code to sort the data by age?        

 

  1. Which sport has the maximum demand, write code to see proportionate                

 

5 REPLIES 5
ballardw
Super User

This sounds a lot like a homework assignment.

So, what have you tried so far?

 

Proc Freq will likely do 1 and 4

Data step with IF or WHERE for 2

Proc Sort for 3

 

And why are all of your questions number 1???

Sahrseb2020
Calcite | Level 5

Indeed it is a home work.

I had been trying to download the SAS software to work on it but the computer is restricted as it is company owned.

Reeza
Super User
Use Academics on Demand which is cloud based and doesn’t require software installation. There is a limit on file sizes but you should be fine.
Sahrseb2020
Calcite | Level 5
Please support me with the direct link

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 895 views
  • 1 like
  • 3 in conversation