[sas-users] Displaying Output of different widths

Thu Aug 18 13:29:08 EDT 2011

Yes, both character and numeric.  Although, the ones I do not want
displayed are all numeric.

PS - the code below will still create a SAS dataset with blank columns, but
I am working with ODS now to produce PDF output which will not display
those columns.

Aneesah

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

  From:       david.d.chapman at census.gov                                                                                               

  To:         sas-users list for SAS Users Group <sas-users at lists.census.gov>                                                          

  Cc:         sas-users list for SAS Users Group <sas-users at lists.census.gov>, sas-users-bounces at lists.census.gov                      

  Date:       08/18/2011 01:26 PM                                                                                                      

  Subject:    Re: [sas-users] Displaying Output of different widths                                                                    

  Sent by:    sas-users-bounces at lists.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

(Embedded image moved to file: pic15020.jpg)

Connect with us:
(Embedded image moved to file: pic16303.gif)Twitter(Embedded image moved to
file: pic25375.gif)Facebook(Embedded image moved to file: pic00667.gif)
YouTube(Embedded image moved to file: pic25392.gif)Flickr

 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

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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic15020.jpg
Type: image/jpeg
Size: 4056 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/2ff56b09/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic16303.gif
Type: image/gif
Size: 660 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/2ff56b09/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic25375.gif
Type: image/gif
Size: 646 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/2ff56b09/attachment-0001.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic00667.gif
Type: image/gif
Size: 1177 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/2ff56b09/attachment-0002.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pic25392.gif
Type: image/gif
Size: 654 bytes
Desc: not available
URL: <http://lists.census.gov/pipermail/sas-users/attachments/20110818/2ff56b09/attachment-0003.gif>