Doubt in SAS Data Import

Discussion in 'Masters Program - Customers only' started by _17647, Jan 6, 2018.

  1. _17647

    _17647 Member

    Joined:
    Dec 8, 2017
    Messages:
    2
    Likes Received:
    0
    Hi,

    I am trying to import the data in sas, Below is the SAS code,

    data work;
    infile cards missover truncover;
    input cname :$ area :$ invest strength;
    cards;
    cts bglore 7000000 789
    tata . 789
    satyam delhi 7000000 789
    ;
    run;


    I can see that the output is coming wrong as for 2nd observation the variable values are like,

    Cname: Tata
    Area :
    invest : 789
    Strength: .

    Can you please guide me on getting the correct response for it..


    Thanks and Regards,
    Abhijeet Patil.
     
    #1
  2. _17647

    _17647 Member

    Joined:
    Dec 8, 2017
    Messages:
    2
    Likes Received:
    0
    the values should be

    Cname: Tata
    Area :
    invest : .
    Strength: 789
     
    #2

Share This Page