I want to replicate this excel graph in SAS to reuse in macro. I want to use both rrc and frc as responses to the stack proc sgplot data=main_subset; vbar sam / response =  rrc  group=rep groupdisplay = cluster seglabel datalabel  stat=mean dataskin=gloss;   xaxis display=(nolabel noticks) discreteorder=data FITPOLICY=STAGGERROTATE;   yaxis label="reads";*grid; run; sam rrc frc rep MES_TreatA 229 1641852 R1 MES_TreatA 258 1152647 R2 MES_TreatB 187 929301 R1 MES_TreatB 530 2556723 R2 MES_TreatC 482255 574857 R1 MES_TreatC 534623 728475 R2 MES_TreatD 1015145 599958 R1 MES_TreatD 1987144 244161 R2 MES_TreatE 564 1838329 R1 MES_TreatE 209 2189893 R2   Thank you ... View more

I've a dataset that has wrong dates created off of a excel drag function. How can I compare and identify the dates that are exactly one day apart in the sequence to alert the team? Thank you ProductID Date_shipped P3456 10/2/2023 R2342 10/3/2023 H9875 10/4/2023 L5543 10/5/2023 ... View more

data t1; input id1 $3. id2 $5.; cards; 123 hkg5 689 yukq 567 khnx ; run; data t2; input id1 $3. id2 $5.; cards; 123 hkg5 569 yukq 567 khnt ; run;   I want to get mis-matched records from t1 and t2 where the id1 is different in two tables for id2 values, In the above example I just want to retrieve 567 khnt what is the best way to compare two columns from two tables? trying to replicate the following query that is working fine in other application.. select t1.custid,t2.custid,t2.id2,ord_date from t2 left join t1 using(id2)where t2.custid != t1.custid       Thank you ... View more

I want to send a report to myself every weekday even if the counts are zero.. My code so far.. proc sql; create table cars_temp as select make, origin, count(*) as total from sashelp.cars group by make, origin; quit; options emailsys=smtp emailhost=xxxxxxxxx emailport=25; filename temp email to = ( 'xxx@xxxxx.xom' ) from='xxx@xxxxx.xom' subject="Daily discrepancies - &rptdt." type="text/html" ODS html body=temp style = journal; TITLE justify= left "Below counts are calculated based on Yesterday's Date "; *ods html text = ""; PROC REPORT DATA=cars_temp nowd HEADLINE HEADSKIP SPLIT='*' style (report) = {background = white font_face = "Verdana" font_size = 7pt just=left } style (column) = {background = white CELLHEIGHT = 2.5% font_face = "Verdana" font_size = 7pt just=left} style (header) = {foreground = cx5e2750 font_face="Verdana" font_size = 8pt just=left background = white} ; column A B C ; define A / group width= 15 "Region * ID"; define B / group width= 30 "Region * Name"; define C / mean width= 30 "Total # * of items "; run; ods html text=" Daily  counts"; ods html text = "."; ods _all_ close;   Thank you ... View more

I have two fields datesent (Ex: 2022-01-13) is text field with length 32767 and collection_date(Ex:22JAN2022) is number with Date9. format would like to compare and get line list of records where datesent < collection_date   Tried the following to convert datesent but it's not working.. data temp2; set temp; format datesent1 date9.; datesent1 = input ( datesent, date9.); run; ... View more

When I run my program first time, proc export gives me messages like log window full.. windows is full and must be cleared. Select File, Print, Save, Clear.   For next several runs it does not give me that message again in the SAS session. How can I suppress that message programmatically or any other configurations.   Thank you ... View more