I have a table with a dummy var set to 0 for all rows EXCEPT the rows most recently sent for each person.  In that case the dummy var should be set to 1.   The dummy var is incorrectly set to 1 for more than just the most recently sent row so I need to reset the dummy var to zero for all rows EXCEPT the rows most recently sent by each person.   I have a var called report_time and can ID the most recently sent row by using max(report_time).   The following syntax did not work: proc sql; update table1 set dummy_var = case when max(report_time) = report_time then dummy_var=1 else dummy_var = 0 end; group by person order by report_time desc, person asc; quit;   below end is the following: ERROR: The value expression referenced by column dummy_var can not directly contain a summary function.   Below group is the following: ERROR 180-322: Statement is not valid or it is used out of proper order. ... View more

The default library for my SAS VA query output table is a Public LASR library. I have a project folder in my SAS Folders where I would like to store my output table. What do I need to do in order to be able to choose a library that will direct my output table to my project folder? In SAS VA's Data Preparation I can change the query's output location, but not the output table's library from the default.   I think I need to register a library in SAS Management Console in order to make it available for use for my output table but I need help figuring out the steps.  I know how to start the New Library Wizard in SAS MC, but am not sure if I should choose SAS LASR Analytic Server Library or SASHDAT Library, or if I should not even be choosing a High-Performance Analytics option.   Is there a document that explains each step of SAS MC's Plug-ins Data Library Manager's New Library Wizard and each option in each step?     Is there an easier way to create a non-default library that can be used for the SAS VA query's output table?  ... View more

My column totals truncate even though there is enough space for them to diplay.  The totals appear even if in report viewer I make the column width SMALLER.  How can I get totals to display properly in report designer so that my end user does not have to play with the column width to see the totals? ... View more