a. Region&State&Month&Expenses&Revenue Southern&GA&JAN2001&2000&8000 Southern&GA&FEB2001&1200&6000 Southern&FL&FEB2001&8500&11000 Northern&NY&FEB2001&3000&4000 Northern&NY&MAR2001&6000&5000 Southern&FL&MAR2001&9800&13500 Northern&MA&MAR2001&1500&1000   b. "Africa","Boot","Addis Ababa","12","$29,761","$191,821","$769" "Asia","Boot","Bangkok","1","$1,996","$9,576","$80" "Canada","Boot","Calgary","8","$17,720","$63,280","$472" "Eastern Europe","Boot","Budapest","22","$74,102","$317,515","$3,341" "Middle East","Boot","Al-Khobar","10","$15,062","$44,658","$765" "Pacific","Boot","Auckland","12","$20,141","$97,919","$962" "South America","Boot","Bogota","19","$15,312","$35,805","$1,229" "United States","Boot","Chicago","16","$82,483","$305,061","$3,735" "Western Europe","Boot","Copenhagen","2","$1,663","$4,657","$129"   c. Region State Capital Bird South Georgia Atlanta 'Brown Thrasher' South 'North Carolina' Raleigh Cardinal North Connecticut Hartford Robin West Washington Olympia 'American Goldfinch' Midwest Illinois Springfield Cardinal   d. all of the above ... View more

Assume that Sasuser.One does not exist and that the following SAS program is submitted at the beginning of a new SAS session: data sasuser.one; x=1; y=27; output one; run;     ... View more

data have; input name $ letter $; datalines; john j Jacobs J Alex A mathew m harward h Liner L Meesa M xenon x ; run; data want; set have; if letter in('A' 'B' 'C' 'D' 'E' 'F' 'G' 'H' 'a' 'b' 'c' 'd' 'e' 'f' 'g' 'h') then group='A'; if letter in('I' 'J' 'K' 'L' 'M' 'N' 'O' 'i' 'j' 'k' 'l' 'm' 'n' 'o') then group = 'B'; if letter in('P' 'Q' 'R' 'S' 'T' 'U' 'W' 'X' 'Y' 'Z' 'p' 'q' 'r' 's' 't' 'u' 'w' 'x' 'y' 'z') then group = 'C'; run;  this is the result i want from the code i have written above but is there any category like string.ascii_letters (similar to python) from which i can assign group so that i dont have to write individual letters like above?   ... View more