turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- SAS Programming
- /
- SAS Procedures
- /
- Proc report

Topic Options

- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

12-07-2010 01:58 PM

Hello if anyone know the solution please reply me

i have a data set with around 40 variables and 20 observarions

i need to produce a report for that in the below mentioned way

1.each observation in a page i.e 20 observations in 20 pages

2.one obervation has only 18 variables and the data and in the remaining 2 variables s missing.

report for this observation should have only 18 variables and the variables with missing data must be removed.

for this program with proc report i need to give all the 40 variable names in the column statement.

is there any other way to solve this without giving the 40 variable names

since i have many data sets with different variable names

Thanks

Sid

i have a data set with around 40 variables and 20 observarions

i need to produce a report for that in the below mentioned way

1.each observation in a page i.e 20 observations in 20 pages

2.one obervation has only 18 variables and the data and in the remaining 2 variables s missing.

report for this observation should have only 18 variables and the variables with missing data must be removed.

for this program with proc report i need to give all the 40 variable names in the column statement.

is there any other way to solve this without giving the 40 variable names

since i have many data sets with different variable names

Thanks

Sid

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

12-07-2010 02:34 PM

Help me here a bit. rows are observations. Variables columns.

You have a data set with 40 variables and 20 observations and you want to report on one observation at a time. OK so far,

But in the 2) portion of your post you have 18 variables, do you mean observations? You want to only include non-missing data in your report?

Perhaps if you gave us a dummy example, it might help us understand. Say 3 rows and 4 columns of made up data.

You have a data set with 40 variables and 20 observations and you want to report on one observation at a time. OK so far,

But in the 2) portion of your post you have 18 variables, do you mean observations? You want to only include non-missing data in your report?

Perhaps if you gave us a dummy example, it might help us understand. Say 3 rows and 4 columns of made up data.

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

12-07-2010 02:50 PM

Art asks good questions. Also, you do not need to post your question in multiple forums. I posted a response to this question in the ODS and Reporting forum.

cynthia

cynthia

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Cynthia_sas

12-07-2010 04:12 PM

@cynthia Sorry....i forgot to mention it. i thought it was a wrong place for posting my question

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to deleted_user

12-07-2010 04:20 PM

Hi:

Generally, PROC REPORT, PROC TABULATE go hand-in-hand with ODS for reporting. So it was an OK place to post your original question.

Did you look at the program I posted??? It shows a similar data scenario - -using SASHELP.CLASS -- but with only 3 rows and 5 variables. However, one of the rows has missing values for 2 of the variables -- so except for the number of rows and the number of variables, the situation in my program will illustrate the fact that you cannot "remove" the column header for the 2 missing values.

cynthia

Generally, PROC REPORT, PROC TABULATE go hand-in-hand with ODS for reporting. So it was an OK place to post your original question.

Did you look at the program I posted??? It shows a similar data scenario - -using SASHELP.CLASS -- but with only 3 rows and 5 variables. However, one of the rows has missing values for 2 of the variables -- so except for the number of rows and the number of variables, the situation in my program will illustrate the fact that you cannot "remove" the column header for the 2 missing values.

cynthia

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Cynthia_sas

12-07-2010 06:34 PM

yes Cynthia i got the answer from your post only

- Mark as New
- Bookmark
- Subscribe
- RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to Cynthia_sas

12-07-2010 04:14 PM

@art i got the answer for my question

one observation has 38 variables means the other 2 variables has missing data in the total 40 variables.

variables are columns and observations are rows

each row has 40 columns

one observation has 38 variables means the other 2 variables has missing data in the total 40 variables.

variables are columns and observations are rows

each row has 40 columns