Turn on suggestions

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

Showing results for

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

Options

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

Posted 12-07-2010 01:58 PM
(1216 views)

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

6 REPLIES 6

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

yes Cynthia i got the answer from your post only

- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content

@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

**Available on demand!**

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.