Import date and time within one colum e.g. 1.1.1999 01:00:23

Discussion in 'SAS (Statistical Analysis Software)' started by Jarg, Mar 2, 2005.

  1. Jarg

    Jarg Guest

    Hello!

    Does anybody know how to import the following date colum as an sas
    date and time value? The original data is delimited by ";".

    1.1.1999 01:00:23
    10.10.2003 21:23:01
    ..
    ..
    ..

    Thanks a lot in advance!

    Jarg
     
    Jarg, Mar 2, 2005
    #1

    1. Advertisements

  2. Jarg

    shiling99 Guest

    I think the ready to use informat for your problem is not available
    yet. But you always can .......

    HTH.

    data _null_;
    length timec $20;
    infile cards;
    input timec 1-20;
    date=input(scan(timec,1,' '),ddmmyy10.);
    time=input(scan(timec,2,' '),time9.);

    datetime=input(put(date,date9.)||'/'||put(time,time10.),datetime20.);
    put date= ddmmyy10. time= time8. datetime= datetime20. ;;
    cards;
    1.1.1999 01:00:23
    10.10.2003 21:23:01
    ;
     
    shiling99, Mar 3, 2005
    #2

    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. saveppt.m (by Mark Brown 1999)

  2. saveppt.m (written by Mark Brown 1999)

  3. Removing Diagonal row and colum from Matrix

  4. import the KDD Cup 1999

  5. Threshold Estimation by Hansen (1999)

  6. seprate the result from one colum to different colums

  7. Import Date and Time Values 1.1.1999 21:21:34

  8. how can I transfer one colum data to a several-column data.

Loading...