I'm have to import an excel spreadsheet that had a date column but the values are not a consistant format.  For example : SDate ------ Jun-07 Nov-08 2009 2000 11/01/2009 When I try                          Jun-04 Nov-04 2007 2002 07/01/2008 proc sql ; create table xls as select     input(sdate, ddmmyy10.) as sdate from exl ; quit ; I get NOTE: Invalid date value NOTE: Invalid argument to function INPUT. Missing values may be generated. NOTE: Table WORK.XLS created, with 5 rows and 1 columns. But the column is empty except for the last row.  Is there a way to apply a default format to all rows? Thanks for any help ... View more

I have a data table that has a list of emails Bob@test.com Jim@test.com Steve@test.com Cindy@test.com Kelly@test.com I want to create a text file that has these in a continous list like this Bob@test.com;Jim@test.com;Steve@test.com;Cindy@test.com;Kelly@test.com; proc sql noprint ; select email into :emails separated by ' ; ' from eData ; quit; But whenever I put I get errors and I think it has to do with the semi-colon at the end. Thank you ... View more

I have a report i'm creating that displays columns that have decimal data that is not even in length. For example 11.1111 2222.2222 3.3333 I want to know how I can have it display where it right justifies the data     11.1111 2222.2222      3.3333 I tried using formats which helped in some other scenarios but not this one. I'm currently just doing a put @1 decData I'm sending this to a text file using a filename statement. Any help would be greatly appreciated. ... View more

I have a data table that I have sorted by a specific field.  I want to create an id for this field so I did the following: data tbl ;     length id 8 ;     set tbl_ ;     by num ;        retain id 0 ;     if first.num then id = id + 1 ;    run ; The first few rows of num are blank and I want them to have a . not 0 as the id. I'm going to use this to create an look up table so by assigning the ids here I can split up the data sets after.  I just don't want id 1 = to a blank value. Thank you ... View more

I have a excel file that is sent to me that I need to bring into sas.  This is what i'm currently doing %let prjdir = c:\temp ; data tabs ;        input tabname $ ;    cards; Tab1 Tab2 OTHER SPECS ; run ; data _null_ ;     set tabs end=last ;     call symput('tabname'||strip(_n_), strip(tabname) ) ;     if last then call symput('ntabs', strip(_n_) ) ; run ; %put &ntabs ; %macro import_tabs ; %do i= 1 %to &ntabs ; proc import out = raw_&&tabname&i     datafile= "&prjdir.\temp.xls"     dbms = excel     replace     ;     sheet="&&tabname&i" ;     getnames = yes ;          run ; %end ; %mend import_tabs ; options nomprint ; %import_tabs ; My problem is the last tab name gives me this error ERROR: File _IMEX_.'OTHER$'n.DATA does not exist. ERROR: Import unsuccessful.  See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time):       real time           0.46 seconds       cpu time            0.18 seconds When I shorten that tab name to OtherSP it works fine. Is there a way to cycle through the tabs without needing to use the tab names?  I can't control the names that are used. Thank you ... View more