Question: The following is my incomplete SAS program. options nodate; data HW1; if (state = Maine or state= Maryland or state=Massachusettsor state=Michiganor state=Minnesotaor state=Montana or state=Missourior

The following is my incomplete SAS program.

options nodate;

data HW1;

if (state = "Maine" or state= "Maryland" or state="Massachusetts"or state="Michigan"or state="Minnesota"or state="Montana" or state="Missouri"or state="Missisippi") then delete;// This is incomplete. Don't know how to do it afterward.

proc print data=HW1; var state; title "Question 1B(v)"; run;

Question: I only want to print all American states except the ones that start with M and N and T using SAS.

48 American states are as follow

Delaware
Rhode Island
Idiana
Maine
New Hampshire
Vermont
Connecticut
Maryland
Massachusetts
New Jersey
Ohio
Pennsylvania
Iowa
Michigan
Minnesota
Wisconsin
Illinois
NewYork
Nebraska
Oregon
Washington
Idaho
Montana
Wyoming
North Dakota
South Dakota
West Virginia
Kentucky
Virginia
Arkansas
Lousiana
Missouri
Alabama
Arizona
Georgia
Missisippi
Tennessee
Florida
North Carolina
South Carolina
Nevada
Utah
New Mexico
Oklahoma
Colorado
Kansas
California
Texas

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!