I would pull the date in it's current format.  If you need to change it to date9. do it in SAS after you have the dataset. ... View more

Here is a solution: proc sort data=have;by group fields; proc transpose data=have out=want(rename=(_NAME_ = Month col1 = Value fields = Calc));by group fields; ... View more

If the previous application you were using allowed the having and group by clause to be reversed that still looks like the issue.  I would try making this two seperate queries. ... View more

If it's not dependent on date and you only want the 100th obs then this should do it:   data have; infile cards dsd; input field @@; cards; .,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,., .,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,., .,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,., .,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,., .,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,.,. ; data all want; set have; count + 1; if count = 101 then count = 1; output all; if count = 1 then output want; run; ... View more

Your having statement and group by statement are in different orders.  I would try switching that and see if it solves your problem. ... View more

Here is a solution:   data have; input obs4; informat obs4 datetime21.2; format obs4 datetime21.2; cards; 27OCT2015:05:39:48.00 ; data want; set have; format pmonth date9.; pmonth = intnx('month',datepart(obs4),-1,'same'); run; ... View more

Without the right license this will not work.  Using enterprise guide you can either use 'send to' and select excel word or powerpoint, or in the file menu select export. ... View more

Here's some code that gets you back and forth between char and date formats:   data have; format date datetime18.; date = '23OCT2015:10:40:30'dt; date_char = input(put(date,datetime18.),$18.); run; data want; set have(keep=date_char); format date date9.; date = input(put(date_char,$18.),date9.); run; ... View more

Union All will include duplicates.  Union will remove duplicates:   proc sql; create table table1 as select obs2,obs4 from table2 union select obs2,obs4 from table3 union select obs2,obs4 from table4; ... View more

Here is a solution:   data have; input n field$; cards ; 1 y12 2 . 3 . 4 b98 5 . 6 . 7 . ; data want; set have; retain field2; if not missing(field) then field2 = field; if missing(field) then field = field2; drop field2; run; ... View more