topic Re: Record count in sas dataset in SAS Programming

Record count in sas dataset

deleted_user — Mon, 24 Jan 2011 16:30:28 GMT

Hi!

What I want to do is update the Txt column in a Teardata table with the count from a sas dataset.
txt = 'No of apps processed today' || count.
How do I get the count , convert it into varchar so that I can concatenate it with the rest of the text and update the table ?

UPDATE table1
(select count(*) cnt from work.apptable)A;
SET TXT = No of apps processed today' || CAST (A.cnt AS VARCHAR 10),

Thanks!

Re: Record count in sas dataset

deleted_user — Mon, 24 Jan 2011 21:59:42 GMT

Can anyone help please?

Re: Record count in sas dataset

sbb — Mon, 24 Jan 2011 22:32:47 GMT

With a SAS assignment you would use the PUT(,best. -l) to tell SAS to convert a numeric variable to a character-formatted string (left-justified operand "-l" if needed).

Scott Barry
SBBWorks, Inc. Message was edited by: sbb

Re: Record count in sas dataset

Peter_C — Mon, 24 Jan 2011 23:36:09 GMT

are you running SAS9.2 ?
Have you update privilerger for that table?
With option BDIdirectExec; you might be able to use (beware this is untested code)
select count(*) into :cases separated by ' ' from appTable;
%let string = No of apps processed today= &cases ;
update tdata.table1 set txt= "&string"
where row_ID = &row_ID /* to be updated */
;
Otherwise you are back to using explicit pass-thru.
If you've not already seen it, you might find useful "Teradata Processing Tips for SAS Users" at
http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001399962.htm

Re: Record count in sas dataset

deleted_user — Tue, 25 Jan 2011 03:08:16 GMT

Thanks Peter. This worked like a charm!