[sas-users] Displaying Output of different widths

[aneesah.n.williams at census.gov]

Currently all states are in the same dataset.  The biggest problem is that
each state has a varying number of relevant variables (some states only 2,
others 200) and this can change from year to year.  So, for me to go
through each state to determine which variables are relevant for each,
would be quite tedious.  I'm looking for a solution that can help me to
avoid that.  I was thinking there was some way to create a macro list of
variable names that are completely blank, by state.  Then I could use that
macro in a drop statement.  But, I'm not really sure how to do that.

Thanks,

Aneesah

======================
Aneesah Williams
Statistical Methods Branch
Governments Division
U.S. Census Bureau
301-763-5995



                                                                                                                                       
  From:       b.nathaniel.miller at census.gov                                                                                            
                                                                                                                                       
  To:         sas-users list for SAS Users Group <sas-users at lists.census.gov>                                                          
                                                                                                                                       
  Date:       08/18/2011 12:42 PM                                                                                                      
                                                                                                                                       
  Subject:    Re: [sas-users] Displaying Output of different widths                                                                    
                                                                                                                                       
  Sent by:    sas-users-bounces at lists.census.gov                                                                                       
                                                                                                                                       






Hi Aneesah,

Are all states in the same dataset? Would you want each state to have its
own dataset with only its relevant variables, or is your preference for all
states to remain in a single dataset?

Nate

                                                                           
 From:        aneesah.n.williams at census.gov                                
                                                                           
 To:          sas-users at lists.census.gov                                   
                                                                           
 Date:        08/18/2011 12:23 PM                                          
                                                                           
 Subject:     [sas-users] Displaying Output of different widths            
                                                                           
 Sent by:     sas-users-bounces at lists.census.gov                           
                                                                           







I have an output data set by state with hundreds of variables, not all of
which are valid for every state.  Can anyone help me to display on those
columns that are nonblank for each state?

Thanks,

======================
Aneesah Williams
Statistical Methods Branch
Governments Division
U.S. Census Bureau
301-763-5995

_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users

_______________________________________________
sas-users mailing list
sas-users at lists.census.gov
http://lists.census.gov/mailman/listinfo/sas-users