Anyalpha is used to find the first occurrence of an alphabet in a string.    data want; set have; retain cnt 0;; Num_of_Chars = lengthn(compress(ID,,'d')); *If you want to include special characters(if exist); Num_of_Chars = lengthn(compress(ID,,'ka')); *If you have only alphabets and digits; if Num_of_Chars gt 0 then cnt=cnt+1; call symput("No_Of_Obs",cnt); run; ... View more

data one; set sdtmall1; retain count 0; count = count + 1; call symputx(cats('in',count),memname); call symputx(cats('seq',count),name); run; %put &in1 &in2 &in3; ... View more

1.Remove %sysfunc in your datastep code. 2.intnx is not required in your code.     Remove %sysfunc and intnx functions in the belowline of code call symputx('beta', PUT(intnx('DAY',%SYSFUNC(&d_today.),-1), date9.));   call symputx('beta', PUT(intnx('DAY',&d_today.,-1), date9.)); call symputx('beta', PUT(&d_today.-1, date9.));   Above two lines of code gives the same result.   ... View more

proc sql; Create table Want as select Herd, Cow_Id, count(distinct Cow_Id) as cnt from Have group by Herd having calculated cnt ge 5; quit; ... View more

If the first three variables of a by group are same then your code works. What If the value in var2 of the 2nd row is changed to 1. Try executing your code with the below dataset. data have; input name $ var1 var2 var3; cards; a 1 2 10 a 1 1 10 b 3 56 47 c 4 78 50 ; ... View more

This might work only if there are distinct values in Var3 for each group in name variable because if the values of Var3 are 10 and 10 against the data values "a" in name variable then you will get both the records. ... View more

data FoodQualityData; infile "path/filename.csv" firstobs = 6 dsd; input Plot Cultigen number Rep Loc $ Std _1; run; open your file and check from which line the data starts and mention it in firstobs option. I found only 7 variables in the files. So, I mentioned only 7 variables in the input statement. Ex : if the data starts from 6th line mention firstobs = 6 if it starts from 10th line then firstobs = 10 ... View more

data FoodQualityData; infile "path/filename.csv" firstobs = 6 dsd; input Plot Cultigen number Rep Loc $ Std _1; run; ... View more

data test; y='2018-5-9 13:18:31:377'; if count(y,':') = 3 then do; ind = find(y,':',-1); rep = trim(substr(y,1,ind-1))||'.'||substr(y,ind+1); *For Replacing; trun = substr(y,1,ind-1); *For Truncating; end; run; ... View more

The below code is applicable only if the status var have the below mentioned values. data have; input Account Relation Status $ 10.; cards; 332 1 OPENED 112 1 CLOSED 154 2 UNCLAIMED 144 2 UNCLAIMED 198 3 DORMANT 189 3 DORMANT 157 3 UNCLAIMED 111 4 CLOSED 163 4 CLOSED 127 4 CLOSED ; proc sql; create table want1 as select *, count( distinct status) as diststatcnt from have group by relation; create table want2 as select *, count(status) as statcnt from want1 group by relation, status; create table want3 as select *, count(relation) as relcnt from want2 group by relation; quit;   data want(drop = diststatcnt statcnt relcnt); set want3; length Final_Status $ 15; if status = "OPENED" then final_status = "Open"; if status = "CLOSED" and statcnt = relcnt then final_status = "Close"; if status = "UNCLAIMED" and statcnt = relcnt then final_status = "Unclaimed"; if status in ('DORMANT' 'UNCLAIMED') and diststatcnt = 2 then final_status = "Dormant"; if final_status = " " then final_status = "Open"; run; ... View more