topic Re: Long to Wide Clinical Data - SAS 9.4 in SAS Programming https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820905#M324060 I want to be able to see one observation per unique clientID. Wed, 29 Jun 2022 13:37:00 GMT taishayla 2022-06-29T13:37:00Z Long to Wide Clinical Data - SAS 9.4 https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820772#M324014 <P>Hello,</P><P>&nbsp;</P><P>I am trying to determine the best way to handle programming for a clinical data set I have. Below is a simplified view of the current structure of the data I have. What I want is a transposed version of it. The reason I haven't been able to figure out how to transpose it is because a client can have multiple assessments at the 'PRN' timepoint. For similar data, I have been able to output separate datasets based on timepoints and then merge them back together (which worked well because there was one assessment per timepoint - no 'PRN'). I also am not sure how to best handle var1-4 (these are 4 variables that are for each assessment) - which has also made this difficult. There should be one row per unique ClientID. In addition to this, I would like to (eventually) be able to bring the dataset in SAS and update a master existing SAS dataset (based on the desired structure) when a new ClientID is detected OR there is a new survey for an existing client. Any insight would be greatly appreciated.&nbsp;</P><P>&nbsp;</P><P><STRONG>Current Structure:</STRONG></P><TABLE><TBODY><TR><TD>ClientID</TD><TD>timepoint</TD><TD>surveydate</TD><TD>totalscore</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD></TR><TR><TD>1</TD><TD>5th-7th Pregnancy Visit</TD><TD>6/1/2022</TD><TD>1</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR><TR><TD>1</TD><TD>12 Weeks Postpartum</TD><TD>6/2/2022</TD><TD>2</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR><TR><TD>1</TD><TD>Child 16 Months</TD><TD>6/3/2022</TD><TD>3</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR><TR><TD>1</TD><TD>prn</TD><TD>6/4/2022</TD><TD>7</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR><TR><TD>1</TD><TD>prn</TD><TD>6/5/2022</TD><TD>8</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR><TR><TD>2</TD><TD>5th-7th Pregnancy Visit</TD><TD>6/6/2022</TD><TD>8</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR><TR><TD>2</TD><TD>Child 16 Months</TD><TD>6/7/2022</TD><TD>9</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Desired Structure:</P><TABLE><TBODY><TR><TD>Clientid</TD><TD>timepoint1</TD><TD>surveydate1</TD><TD>totalscore</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>timepoint2</TD><TD>surveydate2</TD><TD>totalscore2</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>timepoint3</TD><TD>surveydate3</TD><TD>totalscore3</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>timepoint4</TD><TD>surveydate3</TD><TD>totalscore4</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD><TD>timepoint5</TD><TD>surveydate5</TD><TD>totalscore5</TD><TD>var1</TD><TD>var2</TD><TD>var3</TD><TD>var4</TD></TR><TR><TD>1</TD><TD>5th-7th Pregnancy Visit</TD><TD>6/1/2022</TD><TD>1</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD><TD>12 Weeks Postpartum</TD><TD>6/2/2022</TD><TD>2</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD><TD>Child 16 Months</TD><TD>6/3/2022</TD><TD>3</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD><TD>prn</TD><TD>6/4/2022</TD><TD>7</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD><TD>prn</TD><TD>6/5/2022</TD><TD>8</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD></TR><TR><TD>2</TD><TD>5th-7th Pregnancy Visit</TD><TD>6/6/2022</TD><TD>8</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD><TD>Child 16 Months</TD><TD>6/7/2022</TD><TD>9</TD><TD>Yes</TD><TD>no</TD><TD>yes</TD><TD>yes</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Tue, 28 Jun 2022 20:06:24 GMT https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820772#M324014 taishayla 2022-06-28T20:06:24Z Re: Long to Wide Clinical Data - SAS 9.4 https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820805#M324018 <P>The real question is what do you expect to do with the wide version that you cannot do with the current version.</P> Tue, 28 Jun 2022 20:40:24 GMT https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820805#M324018 ballardw 2022-06-28T20:40:24Z Re: Long to Wide Clinical Data - SAS 9.4 https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820852#M324027 <A href="https://communities.sas.com/t5/SAS-Programming/Large-Dataset-Long-to-Wide/m-p/820714/highlight/false#M323976" target="_blank">https://communities.sas.com/t5/SAS-Programming/Large-Dataset-Long-to-Wide/m-p/820714/highlight/false#M323976</A> Wed, 29 Jun 2022 04:23:56 GMT https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820852#M324027 Ksharp 2022-06-29T04:23:56Z Re: Long to Wide Clinical Data - SAS 9.4 https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820878#M324046 <P>It is impossible to create the structure you want, because each variable name has to be unique.</P> Wed, 29 Jun 2022 09:38:47 GMT https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820878#M324046 andreas_lds 2022-06-29T09:38:47Z Re: Long to Wide Clinical Data - SAS 9.4 https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820905#M324060 I want to be able to see one observation per unique clientID. Wed, 29 Jun 2022 13:37:00 GMT https://communities.sas.com/t5/SAS-Programming/Long-to-Wide-Clinical-Data-SAS-9-4/m-p/820905#M324060 taishayla 2022-06-29T13:37:00Z