The SAS Output Delivery System and reporting techniques

Building a field with proc report

Accepted Solution Solved
Reply
Contributor
Posts: 46
Accepted Solution

Building a field with proc report

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


Accepted Solutions
Solution
‎08-28-2012 02:56 PM
SAS Super FREQ
Posts: 8,744

Re: Building a field with proc report

;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

View solution in original post


All Replies
Solution
‎08-28-2012 02:56 PM
SAS Super FREQ
Posts: 8,744

Re: Building a field with proc report

;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

Contributor
Posts: 46

Re: Building a field with proc report

Tk's!! Cynthia!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 246 views
  • 0 likes
  • 2 in conversation