Hi,   I try to export a table to Excel, with a simple PROC EXPORT. But some formats are destroyed. For example I have some amounts values, formats 15.2 in my SAS table, which have, after exporting, 4 decimals in my Excel spreadsheet.  I'm sure you will agree that is a nonsense for amounts...   Is there anything I can do to avoid this? Or is it an Excel problem?   Thanks for answers. ... View more

Hi,   I have a table t1 with two dates d1 and d2. I need to have the year difference in decimals (2decimals). I do:   format yr 15.2; yr= INTCK('month',d1, d2)/12;     Following this, I join with another table t2 on the number of years (with two decimals). But it can't match except when the year t1 has  decimals like *.00 *.25 *.50 *.75   It doesn't want to match when it is decimals like *.08 *.17 *.33 *.42 *.58 *.67 *.83 *.92   The common points of all is they are rounded to the second decimal calculations (*.33 is in fact *.33333333... whereas for table t2 it is truely *.33)   Do you know what I have to do in order to match them?   Thanks for answer. ... View more

Hi,   My provider send me files very bad thinked, and I have no choice but to accept it. One of the main problem is there can be in the Excel file they provide some rows or columns empty at any moment of the Excel file (usually at the beginning and end but not only). The number of empty rows/column change from one file to each other, and whatever the size of the file.   Do you know how I can remove efficiantly those "blank" rows/columns, without having to specify which row/column is impacted?   Second question, when I import the file I specify    getnames = "no"   When I do this, SAS names columns A, B, C... When I remove the first column I will have column names B,C,... If I succeed to remove "blank" columns automatically, I will have to go back to A, B, C... names to work efficiently on data.   Do you know I can do it?   Thanks for answers. 🙂 ... View more

Hi all,   I have an amount MT, which I extract from a file. So at the beginning my amount is a char value   To transform it I use the following function: input (MT, 20.2) The problem is, it doesn't work efficiantely. All of my amounts are actually numbers. In the file I will receive for exemple 186 instead of 186.00. Nevertheless I don't want to treat them like number because they are amounts.   When I use the input function like this the results is the amount divided by 100. To come back to the previous example, in my output table I will have 1.86 instead of 186.00   How can I correct this?   Thanks ... View more

Hi all,   I have a SAS table named A like this:   ID NUMBER VALUE1 VALUE2 ... VALUEn I am sure that whatever the row, the value of the column "NUMBER" is a number between 1 and n.   I want to use A to creaate a new table B which is like this ID VALUE The management rule between A and B is the following: For each of A row, B.ID = A.ID B.VALUE = A.VALUEi if A.NUMBER = i   Basically, if the column NUMBER from A is equal to 100, I need to get the value of the column VALUE100 and write it in the column VALUE of table B.   I precise that VALUE1 ... VALUEn are fantasy names for explanation, the real names of column don't have indexes like this.      Do you have any idea on how to do this in SAS?    Thanks     ... View more