+ Reply to Thread
Results 1 to 2 of 2

Thread: Problem importing raw sas data

  1. #1
    Points: 66, Level: 1
    Level completed: 32%, Points required for next Level: 34

    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool Problem importing raw sas data



    Here is a snapshot of the data I am importing:
    james smith" <james_smith@hotmail.com> "a allen" <weshae@aol.com>, "aaron jones" <meismjones@gmail.com>,adam smith ii <adam@gmail.com>
    Program I wrote:
    data DCAreaMembers;
    length FName $10 LName $20 email $40 ;
    infile 'v:\orion\mymembers.txt' dlm = '" < > ,';
    input FName $ LName $ email $ ;
    run;
    When I run it, the program pulls the first record only. One issue is that a few of the records show a name suffix. Another issue is that the data shows multiple names and emails on the same row. How can I address both issues. I would not mind combining the suffix with the last name.

  2. #2
    TS Contributor
    Points: 6,779, Level: 54
    Level completed: 15%, Points required for next Level: 171

    Posts
    774
    Thanks
    0
    Thanked 70 Times in 69 Posts

    Re: Problem importing raw sas data


    Quote Originally Posted by sas1958 View Post
    Another issue is that the data shows multiple names and emails on the same row.
    In the INPUT line, put @@ at the end, eg
    Code: 
    input FName $ LName $ email $ @@;

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts








Advertise on Talk Stats