topic not able to create new colums from previous table into new table in New SAS User

topic not able to create new colums from previous table into new table in New SAS User https://communities.sas.com/t5/New-SAS-User/not-able-to-create-new-colums-from-previous-table-into-new-table/m-p/895498#M39808 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rashi13_0-1695410845510.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/88232i271C8A02A052EB39/image-size/medium?v=v2&px=400" role="button" title="rashi13_0-1695410845510.png" alt="rashi13_0-1695410845510.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rashi13_1-1695410875539.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/88233i29536653FC85E8A9/image-size/medium?v=v2&px=400" role="button" title="rashi13_1-1695410875539.png" alt="rashi13_1-1695410875539.png" /></span></P><P> </P> Fri, 22 Sep 2023 19:28:23 GMT rashi13 2023-09-22T19:28:23Z not able to create new colums from previous table into new table https://communities.sas.com/t5/New-SAS-User/not-able-to-create-new-colums-from-previous-table-into-new-table/m-p/895498#M39808 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rashi13_0-1695410845510.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/88232i271C8A02A052EB39/image-size/medium?v=v2&px=400" role="button" title="rashi13_0-1695410845510.png" alt="rashi13_0-1695410845510.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rashi13_1-1695410875539.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/88233i29536653FC85E8A9/image-size/medium?v=v2&px=400" role="button" title="rashi13_1-1695410875539.png" alt="rashi13_1-1695410875539.png" /></span></P><P> </P> Fri, 22 Sep 2023 19:28:23 GMT https://communities.sas.com/t5/New-SAS-User/not-able-to-create-new-colums-from-previous-table-into-new-table/m-p/895498#M39808 rashi13 2023-09-22T19:28:23Z Re: not able to create new colums from previous table into new table https://communities.sas.com/t5/New-SAS-User/not-able-to-create-new-colums-from-previous-table-into-new-table/m-p/895503#M39809 <P>Looks like it worked to me.</P> <P>Since you did not give a name to the new character variable you created PROC SQL made up one for you.</P> Fri, 22 Sep 2023 20:04:32 GMT https://communities.sas.com/t5/New-SAS-User/not-able-to-create-new-colums-from-previous-table-into-new-table/m-p/895503#M39809 Tom 2023-09-22T20:04:32Z