I am aware that formats follow variables however, I would like to know if there is a way  to have two formats under one variable? For example, the code below pulls data in and  all variables are character variables. The data is split into two datasets and formatted.  The two datasets are then stacked to create one variable called estimate. The estimate  variable should hold numeric values which are comma formatted and decimal values. However,  the decimals are dropped because the variable is now based on the comma value.    data have; input year $ number $ percent $; cards; 2018 515 29.1 2018 4526 33.3 2018 26518936 56.1 ; run;   /*Create two separate datasets: 1)numbers with comma format 2)percent with decimal format*/ data number (drop=percent number); set have; estimate = input(number,best.); format estimate comma10.0; run;   data percent (drop=number and percent); set have; estimate = input(percent,best.); run;   /*Stack datasets*/ data wrong; set number percent; run;   This is what I get using the above code: Year Estimate 2018 515 2018 4,526 2018 26,518,936 2018 29 2018 33 2018 56   This is what I would like to have:  Year Estimate 2018 515 2018 4,526 2018 26,518,936 2018 29.1 2018 33.3 2018 56.1 Does a way exist to make this dataset happen? ... View more