[sas-users] Displaying Output of different widths

[david.d.chapman at census.gov]

Are the variables both character and numeric?
 

David D. Chapman
Chief, Quality Assurance Staff
Economic Planning and Coordination Division
U.S. Census Bureau - Economic Statistics
Office: 301-763-6535
Cell: 703-498-5782
E-mail: david.d.chapman at census.gov 

Connect with us:




From:
aneesah.n.williams at census.gov
To:
sas-users list for SAS Users Group <sas-users at lists.census.gov>
Date:
08/18/2011 12:47 PM
Subject:
Re: [sas-users] Displaying Output of different widths
Sent by:
sas-users-bounces at lists.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



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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/9809ffbe/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 4056 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/9809ffbe/attachment-0001.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 660 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/9809ffbe/attachment-0004.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 646 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/9809ffbe/attachment-0005.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1177 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/9809ffbe/attachment-0006.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 654 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/9809ffbe/attachment-0007.gif>