#good_job, @Kurt_bremser! ... View more

#kudoSAS @AHMED_alAttar! ... View more

kudos!! #August_fix @ShelleySessoms ... View more

@JBailey, did you suddenly get extra weight added to your like? ... View more

@Patrick, something tells me that @SASUser1001 won't be trolling for Azure information here for a little while longer - ... View more

@novinosrin, I think you could improve the SQL query like so:   proc sql; create table want as /*(drop=rn)*/ select a.studyID, a.Var1,   /*ifn(min(rn)=a.rn,b.var2,0)*/ /*I'm getting confused as to what the initial intent was but I'll come back to this Var2 selecting later*/   from ( select studyid, var1, monotonic() as rn from have1 ) a /*var1_table*/, have2 b /*var2_table*/ where a.studyid=b.studyid   group by a.studyid   order by studyid, rn;   quit; ... View more

I'm wondering is there a way to do this with pure SQL i.e. using a proc sql statement? ... View more

and kind of like the Belmont Stakes this year. ?::O) ... View more

Touche, the Flash! ... View more

@Chris_Hemedinger, 'ja ever notice how in NotePad++ the sql Language overlay jives real well with SAS? There's another but since most of the work I do with SAS is more than likely SQL-related (proc_sql_is_your_friend, where are you now? B|) ... View more

if _n_=1 then continuous_month=month; else continuous_month+1   Help! I'm being overtaken by hackers, copycat hacker no less - ... View more

for FYI's sake, this code/view of the data was useful to me as I started using proc sql to get stats similar to what proc datasets or proc contents does. ... View more

if only iMac-aroni and cheese pro-Csecco were a thing... (rofl):D ... View more