https://communities.sas.com/t5/SAS-Programming/How-to-output-data-as-a-single-record/m-p/54649#M11582 Hi,<BR /> <BR /> We are getting data of a particular person details in segments and I want to combine all info pertaining to single record.<BR /> <BR /> For $example, data is like this: (delimited by pipe)<BR /> <BR /> abc|tom^j^smith|23^elms street^manchester^MA|xxxxxx|yyyyyy<BR /> def|E|2|PPO|Male<BR /> ghi|blah1|blah2|blah3 <BR /> <BR /> So I want to combine all data into a single record, which is coming in segments. abc, def, ghi are repeating in the file and have many records. How to do this in sas?<BR /> <BR /> thanks, Thu, 16 Oct 2008 10:33:26 GMT deleted_user 2008-10-16T10:33:26Z https://communities.sas.com/t5/SAS-Programming/How-to-output-data-as-a-single-record/m-p/54649#M11582 Hi,<BR /> <BR /> We are getting data of a particular person details in segments and I want to combine all info pertaining to single record.<BR /> <BR /> For $example, data is like this: (delimited by pipe)<BR /> <BR /> abc|tom^j^smith|23^elms street^manchester^MA|xxxxxx|yyyyyy<BR /> def|E|2|PPO|Male<BR /> ghi|blah1|blah2|blah3 <BR /> <BR /> So I want to combine all data into a single record, which is coming in segments. abc, def, ghi are repeating in the file and have many records. How to do this in sas?<BR /> <BR /> thanks, Thu, 16 Oct 2008 10:33:26 GMT https://communities.sas.com/t5/SAS-Programming/How-to-output-data-as-a-single-record/m-p/54649#M11582 deleted_user 2008-10-16T10:33:26Z https://communities.sas.com/t5/SAS-Programming/How-to-output-data-as-a-single-record/m-p/54650#M11583 Is the result a text file or a SAS dataset?<BR /> <BR /> For a text file:<BR /> Have a look at the meaning of @ and @@ for the input and put statement.<BR /> <BR /> For a dataset:<BR /> Have a look at 'Proc Transpose' or at the OUTPUT statement.<BR /> <BR /> To denormalise a table is often not a good idea - avoid it if you don't have very good reasons for it.<BR /> <BR /> Cheers, Patrick Thu, 16 Oct 2008 10:41:38 GMT https://communities.sas.com/t5/SAS-Programming/How-to-output-data-as-a-single-record/m-p/54650#M11583 Patrick 2008-10-16T10:41:38Z https://communities.sas.com/t5/SAS-Programming/How-to-output-data-as-a-single-record/m-p/54651#M11584 Try this<BR /> <BR /> data test;<BR /> length a1-a14 $20;<BR /> infile datalines dlm='|';<BR /> input a1-a14 :$20.;<BR /> datalines;<BR /> abc|tom^j^smith|23^elms street^manchester^MA|xxxxxx|yyyyyy<BR /> def|E|2|PPO|Male<BR /> ghi|blah1|blah2|blah3<BR /> abc|tom^j^smith|23^elms street^manchester^MA|xxxxxx|yyyyyy<BR /> def|E|2|PPO|Male<BR /> ghi|blah1|blah2|blah3<BR /> abc|tom^j^smith|23^elms street^manchester^MA|xxxxxx|yyyyyy<BR /> def|E|2|PPO|Male<BR /> ghi|blah1|blah2|blah3<BR /> abc|tom^j^smith|23^elms street^manchester^MA|xxxxxx|yyyyyy<BR /> def|E|2|PPO|Male<BR /> ghi|blah1|blah2|blah3<BR /> ;<BR /> run; Mon, 20 Oct 2008 12:03:38 GMT https://communities.sas.com/t5/SAS-Programming/How-to-output-data-as-a-single-record/m-p/54651#M11584 GertNissen 2008-10-20T12:03:38Z