topic Need to change the Length of Character Variable in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/Need-to-change-the-Length-of-Character-Variable/m-p/79789#M8919 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have one dataset called Cust_demo whci saved all the customer demographic information such as Cust_name, cust_Address and zip code..etc.. Now initially we have defined address variable as a character with length 8, now since the length of address field started increasing we have to make some more space for address variable suppose 10, so can i change this length of address variable?</P><P></P><P>Also this dataset is quite big almost18-20 gb so i can't take risk to recreate it with new length so any Efficient way without creating new dataset appreciated.</P><P></P><P>Regards,</P><P>Tushar Jagtap.</P></BODY></HTML> Mon, 20 May 2013 11:26:36 GMT Tushar 2013-05-20T11:26:36Z Need to change the Length of Character Variable https://communities.sas.com/t5/ODS-and-Base-Reporting/Need-to-change-the-Length-of-Character-Variable/m-p/79789#M8919 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have one dataset called Cust_demo whci saved all the customer demographic information such as Cust_name, cust_Address and zip code..etc.. Now initially we have defined address variable as a character with length 8, now since the length of address field started increasing we have to make some more space for address variable suppose 10, so can i change this length of address variable?</P><P></P><P>Also this dataset is quite big almost18-20 gb so i can't take risk to recreate it with new length so any Efficient way without creating new dataset appreciated.</P><P></P><P>Regards,</P><P>Tushar Jagtap.</P></BODY></HTML> Mon, 20 May 2013 11:26:36 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Need-to-change-the-Length-of-Character-Variable/m-p/79789#M8919 Tushar 2013-05-20T11:26:36Z Re: Need to change the Length of Character Variable https://communities.sas.com/t5/ODS-and-Base-Reporting/Need-to-change-the-Length-of-Character-Variable/m-p/79790#M8920 <HTML><HEAD></HEAD><BODY><P>you can use proc sql;</P><P>proc sql;</P><P>alter table have</P><P>modify colname char(xxx) format=$xxx.;</P><P>quit;</P></BODY></HTML> Mon, 20 May 2013 12:30:30 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Need-to-change-the-Length-of-Character-Variable/m-p/79790#M8920 DBailey 2013-05-20T12:30:30Z Re: Need to change the Length of Character Variable https://communities.sas.com/t5/ODS-and-Base-Reporting/Need-to-change-the-Length-of-Character-Variable/m-p/79791#M8921 <HTML><HEAD></HEAD><BODY><P>Thanks DBailey..</P></BODY></HTML> Mon, 20 May 2013 13:12:33 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Need-to-change-the-Length-of-Character-Variable/m-p/79791#M8921 Tushar 2013-05-20T13:12:33Z