About Rose

Rose · ‎08-05-2011

Thanks Cynthia for the info.. I changed my source dataset accordingly... Thank u Ksharp .

Rose · ‎08-04-2011

Thanks Ksharp.. My source dataset is like Col1 Col2 Col3 DIV A a 1 b 2 DIV B a 2 b 2 DIV C a 5 b 5 I want the report to be in the form DIV A a 1 b 2 Total 3 DIV B a 2 b 2 Total 4 DIV C Total 10 i.e., i want to delete the 2 rows corresponding to DIV C and print the Total only.. Hope I am clear with the requirement nw..

Rose · ‎08-04-2011

Hi, I have a requirement to hide 2 rows in my report, but I need to show the total of these records using 'rbreak summarize' . Since I have to show the total in the report I am not able to delete these records from my source dataset. Is there any option in proc report like if col1 = 'SP" then delete; Please help..

Rose · ‎02-18-2011

Thanx for the response.. Its because of too many rows. My report has 63 rows and 8 columns. These 8 columns fit in a single page. But after 32 rows the report breaks and jumps into the next page.

Rose · ‎02-18-2011

Hi, I am creating a pdf report using ods pdf . The ods pdf contains many proc report procedures generating their corresponding output reports.I want one of the proc reports output in a single pdf page. But the report is so big that it occupies two pages. How can I set the report in a single page? At the same time I dont want to alter the alignment of other reports.

Rose · ‎12-30-2010

Hi, I have a dataset like C0 C1 C2 C3 1 1 1 1 2 2 2 2 3 3 3 3 I want to create a report like C0 C1 C2 C3 Total(rows) 1 1 1 1 3 2 2 2 2 6 3 3 3 3 9 Total(Cols) 5 5 5 15 Total(rows) is the sum of Col1,Col2,Col3 across rows. Total(Cols) is the sum along column where Col0 not =1. Plz help on implementing this.

Rose · ‎12-16-2010

Thanks for the input.. I created a temperory dataset with required columns only. Then used that dataset in my query. It worked fine without the error..

Rose · ‎12-15-2010

I was trying to create a temperory table from a SAS dataset using proc sql. The code was like proc sql ; create table t1 as select columnA from tableA; quit; I got the error ERROR: CLI cursor fetch error: [SAS/ACCESS to SQL Server][ODBC SQL Server Driver]Unicode conversion failed. Also an error message box saying Unable to read SAS report file. Please help on this...

Rose · ‎12-15-2010

Thank u so much . It worked 🙂

Rose · ‎12-10-2010

I want to update tableA.ColumnA with tableB.ColumnB where tableA.id=tableB.id. Can I do this inside a proc sql? I tried the below code proc sql; UPDATE tableA SET ColumnA = ( SELECT ColumnB FROM tableB a WHERE a.id =id) WHERE a.id = id; quit; But this resulted in the error, ERROR: Unresolved reference to table/correlation name a. Message was edited by: Rose

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

how to delete/hide rows in a report using proc report?

how to delete/hide rows in a report using proc report?

how to delete/hide rows in a report using proc report?

Re: ods pdf

ods pdf

proc report

Re: Unable to read SAS report file

Unable to read SAS report file

Re: update statement inside a proc sql

update statement inside a proc sql

how to delete/hide rows in a report using proc report?

how to delete/hide rows in a report using proc report?

how to delete/hide rows in a report using proc report?

Re: ods pdf

ods pdf

proc report

Re: Unable to read SAS report file

Unable to read SAS report file

Re: update statement inside a proc sql

update statement inside a proc sql