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?
kimomakano
Last Activity: Apr 7 '15, 10:24 PM
Joined: Apr 17 '14
Location:
-
Re-align data in SQL Server from SAS
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? -
Thanks Rabbit,
But it is not working for me, I forgot to clarify that this is only a subset of the data. There are multiple values for ID as well.
When I return the max of date1, grouped by date2 I lose some of the values for date1, I don't want that.Leave a comment:
-
Delete date values if not MAX date
I have a set of data that has two dates for each row.
The second set of dates is repetitive in some cases.
I only want the last(MAX) date retained for this second set of dates.
The raw data shows:
ID Date1 Date2
312 1/12/2013 1/18/2013
312 1/12/2013 1/29/2013
312 1/21/2013 1/29/2013
312 1/25/2013 1/29/2013
312 1/21/2013 2/20/2013
312 1/25/2013 2/20/2013
...
No activity results to display
Leave a comment: