For the spherecity test, what does "Transformed Variates" mean?   ... View more

I got a code as shown below. How do I abbreviate the if statements in a way that goes like this Chile-Japan without typing every one of them?   data med; infile "/folders/myshortcuts/sas/Vaccines.dat"; input VacName $ 1-29 Mode $ 32-50 WInc 51-60 WDeath 61-70 Chile $ 71-73 Cuba $ 77-79 US $ 83-85 UK $ 89-91 Finland $ 95-97 Germany $ 101-103 SaudiArab $ 107-109 Ethiopia $ 113-115 Botswana $ 119-121 India $ 125-127 Australia $ 131-133 China $ 137-139 Japan $ 143-145 ; if WDeath = "" then WDeath = "0"; if WInc = "" then WDeath = "0"; if Chile = "" then Chile = "No"; if Cuba = "" then Cuba = "No"; if US = "" then US = "No"; if UK = "" then UK = "No"; if Finland = "" then Finland = "No"; if Germany = "" then Germany = "No"; if SaudiArab = "" then SaudiArab = "No"; if Ethiopia = "" then Ethiopia = "No"; if Botswana = "" then Botswana = "No"; if India = "" then India = "No"; if Australia = "" then Australia = "No"; if China = "" then China = "No"; if Japan = "" then Japan = "No"; run; proc print data=med; format WInc comma10. WDeath comma8.; run; ... View more

I was able to show all of the values except for the Total Sales column. I can show the value in thousands, but the values in hundred just won't show up. How do I fix the code? Thanks. Attached png file is the output of the code. data bikes1; infile "/folders/myfolders/austin.txt" dlm='09'x; ; length Country $14 Bike $13 Model $10 Units 4 Price 6 TotalSales 7 ; format Price dollar6. TotalSales dollar7.; input Country Bike Model Units Price dollar6. TotalSales dollar9.; run; proc print data=bikes1 noobs; run; * USA Road Bike Trek 5000 $2,200 $11,000 USA Hybrid Trek 4500 $650 $2,925 USA Road Bike Cannondale 2000 $2,100 $4,200 USA Mountain Bike Trek 6000 $1,200 $7,200 USA Mountain Bike Cannondale 4000 $2,700 $10,800 United Kingdom Hybrid Cannondale 500 $880 $440 United Kingdom Hybrid Trek 800 $490 $392 United Kingdom Road Bike Cannondale 1200 $2,123 $2,548 United Kingdom Road Bike Trek 2444 $2,100 $5,132 United Kingdom Mountain Bike Trek 1211 $1,121 $1,358 Italy Mountain Bike Trek 3400 $1,877 $6,382 Italy Road Bike Trek 4500 $2,890 $13,005 Italy Hybrid Trek 700 $690 $483 France Road Bike Cannondale 900 $3,700 $3,330 France Road Bike Trek 3400 $2,500 $8,500 France Hybrid Trek 1100 $540 $594 France Mountain Bike Cannondale 800 $1,899 $1,519 France Mountain Bike Trek 5600 $1,300 $7,280 ;     ... View more