topic Re: sql in SAS Procedures

sql

deleted_user — Tue, 01 Mar 2011 19:29:41 GMT

Hi ,

I need to remove from the output file all ID that have an alpha at the beginning of their id number.

currently in the program ,
provnos = substr(provno,1,15);

Current ID Modify ID
A119966-A85 119966-A85
A119966-B85 119966-B85
A121065-A31 121065-A31
A123206-A18 123206-A18
A123206-B18 123206-B18

Thanks in Advance

Re: sql

SAS83 — Tue, 01 Mar 2011 19:40:17 GMT

data x;
length currentID$ 15.;
input CurrentID$;
cards;
A119966-A85
A119966-B85
A121065-A31
A123206-A18
A123206-B18
;
run;
data y;
set x;

new = substr(CurrentID,2,12);
run;

Re: sql

deleted_user — Tue, 01 Mar 2011 19:58:45 GMT

Ravi,

Can you let me know wat to do in this case if we need to remove just A on the report,

Current ID Modify ID
1196645 889765
789765 879643
A119966-A85 119966-A85
A119966-B85 119966-B85
A121065-A31 121065-A31
A123206-A18 123206-A18
A123206-B18 123206-B18

Thanks,
sudha

Re: sql

polingjw — Tue, 01 Mar 2011 20:43:49 GMT

if anyalpha(currentid)=1 then currentid=substr(currentid, 2);

Re: sql

deleted_user — Tue, 01 Mar 2011 21:01:43 GMT

Thanks Poling .. Its working