Thanks Hima ... View more

Are the fields the same or similar for all files? Do you know the field names and data types? Do you want a single data set in the end. (assuming common fields)? This paper http://www.lexjansen.com/pharmasug/2011/tt/pharmasug-2011-tt04.pdf includes an example program to read any number of files with common fields.  The fields don't have to exist in all files nor be in any particular column but you do have to to know the field names you want to read and define them as to type.  In other words you will need to know something about the data you are reading but there is no quessing as with PROC IMPORT. ... View more

Awesome guys, great to have so many different answers! Thanks for the additional information PG,  i am using Ksharp query but yours just gave me more depth for my analysis ... View more

SAS has already a function to handle this question. data have; input block $15.; cards; 220790101003023 040159507041388 . 21071920100j011 481210201053003 21071920100A011 ; run; data want; set have; flag=ifc(notdigit(block),'N','Y'); run; Ksharp ... View more

The reason the . didn't work is because SAS uses different representations for Oracle's NULL; . for numeric variables, blank for character. This is a really old feature of the SAS language. On the subject of your filter, dates with DBMS tables can be tricky, as different DBMS products represent them differently. DATETIME() is a SAS function that might work. If not, try posting to the "SAS Macro Facility, Data Step and SAS Language Elements" community; someone with more Oracle experience can probably help. Do you need your filtering statements in the actual MAX(CASE(...)) statements, or can you use a filter on the "Filter Data" tab in your EG query? ... View more

Thanks, that worked perfectly. ... View more

Hi Art, I thought you wanted to show how to print all numeric or character variables between two variables. In the example below, the two outputs are different.  Thanks -Linlin data class;   set sashelp.class;   age2=age;   w2=weight; proc print data=class; title print out all numeric variables; var _numeric_; run; proc print data=class; title print out all numeric variables between name and weight;   var name-numeric-weight; run; ... View more

Thank you everyone for posting! ... View more

That is meaning nothing. Just give it to TOM. Actually I love TOM's code too. Ksharp ... View more

Thank you so much. You helped me so much... ... View more

This is the final code that worked.  Thank you so much for your help with this.  This was an immense help to get this report out. case when MS.changed_price >= (AO.total_amount - AO.tax_amount - AO.service_charge_amount + AO.discount_amount + AO.manual_gift_cert_amount) then MS.changed_price       else 0 end as Full_Payment, case when MS.changed_price < (AO.total_amount - AO.tax_amount - AO.service_charge_amount + AO.discount_amount + AO.manual_gift_cert_amount) then MS.Changed_Price         else 0 end as Partial_Payment I needed two different fields for two different types of data, so i had to make two case statements and it works beautifully now.  I could not of done it without the starter that you gave me.  Thanks so much! DZ ... View more