Hi,    I want to find the first and the last value of each row, giving back the variable's name, as I will try to explain in the next output:    Name Source1 source2 source3 FirstValue LastValue a   A B Source2 source3 b A B   Source1 Source2 c A   B source1 source3 d   A B Source 2 source 3   Thank you.      ... View more

Hi,    I have 3 different programs, and I want to create a "program 0" that runs all the others programs. However, in the program 1, I want to run him to 36 different months, (i'm using a macro that change every month). Is it possible to run in program 0, 36 times one to each month? if yes, how?    Thank you.   ... View more

Hi,    I'm trying to export SAS dataset to an excel file. However, when I run the code, Sas only create this type of file "$$1" and not a excel file.    Here is the code:  PROC SORT DATA= Data; BY Y; RUN; PROC MEANS DATA= Data; VAR X; BY Y; OUTPUT OUT= Y SUM=; RUN; proc export data=Data outfile= "xxxxxx/DATA.xlsx" dbms=xlsx replace; sheet='Y'; run; and here is the log: ERROR: Resource is write-locked by another thread. File =/xxxxxx//Y.$$1. Error creating temporary file for XLSX file -> /xxxxxxx/Y.$$1 . It is either not an Excel spreadsheet or it is damaged. Error code=80001019 Requested Output File is Invalid ERROR: Export unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors.     Thank you       ... View more