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!!
;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
;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
Tk's!! Cynthia!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.