topic Adding a column to a SAS Table in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Adding-a-column-to-a-SAS-Table/m-p/112707#M31179 <HTML><HEAD></HEAD><BODY><P>I&nbsp; am trying to add a column to an existing column and the length is not working right. I have this:</P><P></P><P>proc sql;</P><P>add pl_desc char label='pl_desc' length=40 format=$40.;run;</P><P></P><P>When I look at how the column looks in view, It says length is only 8. </P></BODY></HTML> Wed, 19 Jun 2013 20:55:06 GMT tmm 2013-06-19T20:55:06Z Adding a column to a SAS Table https://communities.sas.com/t5/SAS-Procedures/Adding-a-column-to-a-SAS-Table/m-p/112707#M31179 <HTML><HEAD></HEAD><BODY><P>I&nbsp; am trying to add a column to an existing column and the length is not working right. I have this:</P><P></P><P>proc sql;</P><P>add pl_desc char label='pl_desc' length=40 format=$40.;run;</P><P></P><P>When I look at how the column looks in view, It says length is only 8. </P></BODY></HTML> Wed, 19 Jun 2013 20:55:06 GMT https://communities.sas.com/t5/SAS-Procedures/Adding-a-column-to-a-SAS-Table/m-p/112707#M31179 tmm 2013-06-19T20:55:06Z Re: Adding a column to a SAS Table https://communities.sas.com/t5/SAS-Procedures/Adding-a-column-to-a-SAS-Table/m-p/112708#M31180 <HTML><HEAD></HEAD><BODY><P>I think you are looking for CHAR(40) to create a 40 character variable. without a width specified the default for char is 8</P></BODY></HTML> Wed, 19 Jun 2013 21:04:17 GMT https://communities.sas.com/t5/SAS-Procedures/Adding-a-column-to-a-SAS-Table/m-p/112708#M31180 ballardw 2013-06-19T21:04:17Z