data want; set have (firstobs=1 obs=10); id1=SUBSTRN(id,13,10); RUN;   given data:   ABC00000012365948952321 ABC00000000000948952321 ABC00000000025369214558   Output want:  12365948952321  948952321 25369214558     I have set of ID's that consist of 23 digits. First 3 letters starts with alphabets and the rest are numbers. I want to pull only the last numbers that starts after zero. Since it's not constant position not sure how to use the function? ... View more

I use max function in Proc SQL its working fine. MIN function not working properly giving wrong results. Some of them giving me 0 instead of values.   example:   min(case when region = 'SOU' then amt else 0 end) as MIN_sou,  min(case when region = 'NOR' then amt else 0 end) as MIN_nor , ... View more

I am trying a run a regular program in SAS using  proc sql; connect to oracle(user=&userid. password=&passwd. path= preserve_comments);   Got an error like: ERROR: Error fetching from cursor. ORACLE error is ORA-19011: Character string buffer too small.   Query looks good and I ran it every week. This time it throws me this error, not sure where to look for in the SQL query.   Apparently program didn't stop, it ran and got the results.  ... View more

Please help! I want to Rank the second variable in this code. data have; input id region; datalines; 10 US 10 CA 10 CA 23 MA 25 MA 45 Ks 50 US 50 SA 65 US ; proc sort data = have; by id; run; data want; set have; by id; if first.id then rank =1; else rank+1; run;   Output needed:   ID  Rank1 Rank2 10   1         1 10   2        1 10   3         2 ... View more

I would like to use the Rank function in Proc sql Getting error, when I use this code RANK() OVER(ORDER BY t.ID DESC) as rank, Output like this, ID New col 10 1 10 2 10 3 23 1 25 1 45 1 50 1 50 2 65 1   ... View more