Hi, I want to import an excel files to SAS (v9.4). The excel is formatted as such: the 1st column being people' names (titled Name) and the rest of the columns being "1/1/1990 2/1/1990 3/1/1990........". The data is each person's sales in each month. The folloiwng code was used: PROC IMPORT OUT= file_SAS DATAFILE= "directory\file_excel.xls" DBMS=xls REPLACE SHEET='Sheet1'; GETNAMES=YES; namerow=8; /*the variable names on row 8*/ datarow=9; RUN; After imported, file_SAS only shows the "Name" as the variable name in the 1st column. The remaining date variables became alphabet C, D, E, ..... Is there any way for SAS to keep the variable name without using rename (I have hundres of months)? Or any suggestion about importing this kind of data structure? Any suggestions welcomed! Thank you.
... View more