infile

  1. M

    Infile for non-standard data

    I have a messy file (does not line up in columns), where some of the columns are tab delimitated and some are comma. My problem with the data set is reading the files with variable lengths 12 Stephen Cole, 33, Columbia, MO 5 Dave Anderson, 25*, Concord, OH The first...
  2. M

    Relearning SAS

    Greetings Does anyone know how to use the 'set' or 'infile' statement using SAS on Demand for Professionals (SODP)? Since it utilizes Enterprise Guide (EG) 6.1, it is geared to new users of SAS wanting to use the GUI. I am attempting to relearn program code from my SAS v5 days. Since SODP...
  3. N

    Importing data with missing values notated with a blank

    I have a csv file that I am trying to import that is comma delimited. Missing data is notated with either a blank or a period. How do I account for this in my infile statement so that the data does not get shifted? I've tried DLM="," which didn't account for the blanks. Thanks for the...
  4. S

    excel to SAS

    library work 'c:\documents and settings\desktop\s' data s.sas; infile 'C:\Documents and Settings\Desktop\sas.prn' firstobs=2; input subject salary job jobtitle $ yrsatjob gender age manager $; run; I cannot get this code to read in an excel sheet into SAS. I am saving it as a space...