topic Re: Converting multiple rows per subject to one row per subject in SAS Programming https://communities.sas.com/t5/SAS-Programming/Converting-multiple-rows-per-subject-to-one-row-per-subject/m-p/733083#M228446 <P>Please provide (a portion of) the data following these instructions: <A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_blank">https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/</A></P> Mon, 12 Apr 2021 19:07:04 GMT PaigeMiller 2021-04-12T19:07:04Z Converting multiple rows per subject to one row per subject https://communities.sas.com/t5/SAS-Programming/Converting-multiple-rows-per-subject-to-one-row-per-subject/m-p/733067#M228442 <P>Hi,</P><P>&nbsp;</P><P>I have an Excel file that has two rows of data per subject. I would like to upload this to SAS and change the dataset to one row per subject. Please let me know how this can be done!</P><P>&nbsp;</P><P>Thanks!</P> Mon, 12 Apr 2021 18:38:16 GMT https://communities.sas.com/t5/SAS-Programming/Converting-multiple-rows-per-subject-to-one-row-per-subject/m-p/733067#M228442 wisej 2021-04-12T18:38:16Z Re: Converting multiple rows per subject to one row per subject https://communities.sas.com/t5/SAS-Programming/Converting-multiple-rows-per-subject-to-one-row-per-subject/m-p/733083#M228446 <P>Please provide (a portion of) the data following these instructions: <A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_blank">https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/</A></P> Mon, 12 Apr 2021 19:07:04 GMT https://communities.sas.com/t5/SAS-Programming/Converting-multiple-rows-per-subject-to-one-row-per-subject/m-p/733083#M228446 PaigeMiller 2021-04-12T19:07:04Z