Re-align data in SQL Server from SAS

[kimomakano]

I have successfully got my SAS data into SQL Server, but all of the data appears to be left-aligned, even numeric values. Is there a way to re-align the data so it is consistent with SQL data?

[Rabbit]

I'm not sure what your question is. If you're pulling the data from SQL Server, then it is "SQL Data". You're going to have to define that term more precisely.

[kimomakano]

Sorry for any misunderstandin g.
The original source of my data is a SAS data pull.
I sent it to our SQL server since that is the primary tool for data usage.
However, when i view the imported SAS data in SQL, all the values are left-aligned, including the numeric.
Is there a way to right-align the numeric fields?

[Rabbit]

You probably imported the data as strings. Convert the fields to numeric data types. You can either alter the table or create a view.