topic Re: Building a field with proc report in ODS and Base Reporting

Building a field with proc report

Abud — Tue, 28 Aug 2012 15:54:42 GMT

Hello everybody!

Can I build a field with the function SUBSTR in the proc report ?

I'm trying to do something like this, but it doesn't working.

proc report data=rsm_negs;

col Mercado Qtd Fin papel;

define Mercado / group;

define qtd / sum;

define fin / sum;

define mercadoria / group computed;

compute mercadoria;

mercadoria = substr(Papel,1,3);

endcomp;

run;

Tk's in advanced!!

Re: Building a field with proc report

Cynthia_sas — Tue, 28 Aug 2012 18:56:58 GMT

;Hi:

The left to right order of your items in the COLUMN statement will be important. I do not see MERCADORIA in your COLUMN statement and I am not on a system where I have SAS to test with, but if you had this:

col Mercado Qtd Fin papel mercadoria;

with MERCADORIA appearing after PAPEL in the COLUMN statement, then you should be able to do this in a COMPUTE block:

define mercadoria / computed "Mercadoria";

compute mercadoria / character length=3;

mercadoria = substr(Papel,1,3);

endcomp;

You cannot have a usage of GROUP -and- COMPUTED in your DEFINE statement for MERCADORIA. So if you need to collapse rows for summarizing based on the first 3 characters of PAPEL, you might need to create MERCADORIA as a variable in your dataset.

cynthia

Re: Building a field with proc report

Abud — Wed, 29 Aug 2012 14:40:43 GMT

Tk's!! Cynthia!