Building a field with proc report

[Abud]

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!!

[Cynthia_sas · Accepted solution]

;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

[Abud]

Tk's!! Cynthia!