That's a pretty broad question. You might have more luck if you provide some specific examples.   However, in the hopes that this helps, here's documentation for one of the SAS statistical procedures that describes how the measures are calculated.   Tom   http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473330.htm ... View more

One thing we need to figure out is what style your date is. SAS has two "date-like" storage mechanisms; one is number of days, and one is number of seconds. The functions and formats need to be used taking this into account. Set up a new query on your table, and include only your date column. Include it three times. On the first, use a format of best15. On the second, use a format of date. On the third, use a format of datetime. Post a few lines of the result, and we'll know what your data is. Tom ... View more

Another suggestion for your decimal problem. Copy your data to a work table, and set the format for all the numeric variables in the work table to BEST15.   That may show up the variable with the fractional part.   Tom ... View more

Do you know what macro variables are being created by the prompts, and what their values are? ... View more

First, I don't see any problem creating two prompts.   Second, could you then use the "Conditional Processing" facility to run whichever programs should be triggered by the prompts? ... View more

Before you get into a complex query, perhaps a simple example might clarify things a bit.   Here's a simple one-to-many join that shows the idea.   Tom   data Customers; length CustomerID 8 CustomerName $20 ContactName $20 Address $30 City $15 PostalCode $10 Country $10; input CustomerID & CustomerName & ContactName & Address & City & PostalCode & Country &; cards; 1 Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany 2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constitución 2222 México D.F. 05021 Mexico 3 Antonio Moreno Taquería Antonio Moreno Mataderos 2312 México D.F. 05023 Mexico run; data Orders; informat OrderDate yymmdd10.; input OrderID CustomerNumber EmployeeID OrderDate ShipperID; cards; 10308 2 7 1996-09-18 3 10309 37 3 1996-09-19 1 10310 77 8 1996-09-20 2 10311 2 9 1996-09-21 4 run; proc sql noprint; create table OrdersAndCustomers as select Orders.OrderID, Orders.OrderDate, Customers.CustomerID, Customers.CustomerName from Orders inner join Customers on Orders.CustomerNumber = Customers.CustomerID; quit; ... View more

The BY statement tells SAS to set up special "first" and "last" variables for each group of observations that have the same value of the BY variable(s).   Then when I say "if last.Income", it means if this is the last observation that has this particular set of first name, last name, and income.   So I'm saving only one observation with that combination of values, the last one.   Here's a technical description: https://documentation.sas.com/?docsetId=lestmtsref&docsetVersion=9.4&docsetTarget=p0yeyftk8ftuckn1o5qzy53284gz.htm&locale=en#p03fp6zpdf1njjn1ikv77q4wld7c ... View more

From what your post says, you have the actual "get the needed data from a file" part working, so I'm not going to consider that.   In terms of getting your data from the different datasets:   1. You need to put your successful code into a SAS macro, where the name of the dataset is a parameter, and you have some way of distinguising one output from another (an incremented counter would work fine).   2. Then you need a way to get the names of all the datasets in a directory. Take a look at the SAS "External Files" routines, they do exactly that. Here's a reference to how to use them: http://www.mwsug.org/proceedings/2012/S1/MWSUG-2012-S128.pdf   3. Then just get the dataset names, and invoke your macro for each dataset.   Tom ... View more