Data formatting through infile

[smalek]

Hi
I am importing a file through a data infile and the date field is coming in as * "01/04/09". I tried stripping the special characters with a number of manipulations but no success. Any thoughts?
Also my infile is being imported in the following variable sequence
Date Site Pt_Id Mnemonic
01/04/09 ML 123 CBC
1 01603 TEST
01/04/09 ML 456 WBC
1 03015 SPEC

My Desired output is the following:
Date Site PT_ID Mnemonic Count Code Countby
01/04/09 ML 123 CBC 1 01603 TEST
01/04/09 ML 456 CBC 1 03015 SPEC

Any advice is much appreciated?
Thanks

 

[klaz2002]

Can you show us a sample of your raw data that you import. This looks like SAS is reading some char that tells it to store your second line of data on a new line (record).
Klaz

 

[smalek]

Hi klaz2002
In fact the raw data file is setup such that

1 01603 TEST

1 03015 SPEC

are on a separate line. Due to the number of records it would labourious to go through the raw file and bring these records back up the the parent entry. It is for this reason I would like to run it through SAS to end up with the following desired output:

Date Site PT_ID Mnemonic Count Code Countby
01/04/09 ML 123 CBC 1 01603 TEST
01/04/09 ML 456 CBC 1 03015 SPEC

Thanks

 

[klaz2002]

Is the raw data set up like this?

01/04/09         ML              123          CBC
1                01603           TEST
01/04/09         ML              456          WBC
1                03015           SPEC

When you read this type of data into SAS you should use list input.

ex

data test;
 infile "yourfile";
 input Date Site PT_ID Mnemonic Count  Code  Countby;
run;

This should read the raw data and proceed to the next line when data wraps.

Klaz