topic Re: sas report in SAS Enterprise Guide

sas report

Tushh — Fri, 15 Apr 2016 07:04:01 GMT

Hi,

I have one job which generates excel report weekly basis.

now i got assignment like i have to remove ROWS which have zero(0) value in excel report.

i have to delete thows rows only without deleting those colums so can i have any solution on this.

Note: this is sas code which executes daily basis in job& creates excel report.

Now the job is getting failled again and again just because of these zero(0) presents in particular columns so i want to delete that row which have zero(0) into their columns but i dont wanna remove columns .

Thank u

Need immediate solution

Re: sas report

Kurt_Bremser — Fri, 15 Apr 2016 07:23:42 GMT

If column XXXX in a SAS dataset shall not be zero, use

if XXXX ne 0;

(subsetting if) during creation of the dataset.

If you want rows excluded from a report, use this dataset option in the data= part of the PROC statement:

(where=(XXXX ne 0))

Re: sas report

Reeza — Fri, 15 Apr 2016 07:34:49 GMT

We don't have enough information to answer.

If Excel report is generated by proc report for instance, your columns maybe a row I'm your dataset.

The he general premise is to add/modify your WHERE code, filtering records you are not interested in.

Re: sas report

ballardw — Fri, 15 Apr 2016 14:53:45 GMT

Another approach that may be feasible is presummarize data then filter before using the report procedure to format the output.

You will need to provide example data, procedure code and tell us which output rows are not acceptable if you want tested code.

Re: sas report

Tushh — Thu, 21 Apr 2016 07:16:33 GMT

Thank U