Are there any links/sources available on the internet which provide datasets (and problems on the same) which can be taken up as practice resource for various SAS procedures and data steps manipulations? I tried to find such resources on the internet but wasn't too successful in finding out any.. ... View more

Hi, I have a file with around 58 variables (Numeric and Char). While using "if-then" statement on the char variables, since the column length is small, i am not able to match the string (used in "if") with the value in observation. How can i resize all the character variables while importing the file in SAS? ... View more

I have a dataset with variables as "SalesID", "ActualSales" , "TargetSalesAmt" and "Region". I need to create a performance index based on total sales achieved against the target set, and identify the best performing region overall. How can this be done without using Proq SQL. Example:- SalsID ActualSales TargetSales Region XE908 19000 13800 East XA908 20000 18000 East XC102 25000 30000 West XB102 15000 18000 East XA908 20000 22000 West XE908 10000 10000 North XB102 30000 25000 South ... View more