when you run this     71         libname pg1 "/home/kedward50/EPG194/data"; do you see this NOTE: Libref PG1 was successfully assigned as follows:        Engine:        V9        Physical Name: /home/kedward50/EPG194/data ... View more

@KEDWARD50 remove the /* */ that is around your library assignment. the system needs the libname reassigned.  your first error should clean up the remaining errors.     ... View more

Data have; input string $25.; cards; AB001234 C01403 D00003456 ; Data want; set have; new_string = COMPRESS (string,0 ); run; ... View more

      libname mylib '/home/XXX/learn'; data sales; set mylib.sales (keep = TotalSales Region); if Region = 'North' then Weight = 1.5; else if Region = 'South' then Weight = 1.7; else if Region = 'West' then Weight = 2.0; else if Region = 'East' then Weigth = 2.0; End; run; Title 'Region and TotalSales'; proc print data=sales; run; title; ... View more

this link should have the solution you are asking for. https://communities.sas.com/t5/SAS-Programming/selecting-data-in-the-first-30-days-since-first-date/m-p/256824#M49254   ... View more

That is great @cmemtsa that @karolis_b solution works for your request. Please mark the appropriate solution as an excepted solution so that the tread is closed.   ... View more

you should allow for a space in front of LP to catch only those at the end of the string. try this I only included a space for LP.     data test; input cname $60.; CNAME1 = compbl(translate(CNAME, " ", ";.,:()-/")); CNAME2=prxchange('s/\s\S{1,2}\s*$//o', 1, CNAME1); CNAME3 = prxchange("s/\b(INC|PA|PLC|II|III|U S|BV|MI|MICA|1 LLC|B V|GR|SP|LLC|US|USA| LP|CORP|LTD|LT|CO|NV| LP|L P|LL|IN|IND|COR|SA|KG|F K|F K A|AB)\b//o", -1, CNAME2); CNAME4=prxchange('s/\&$//',-1,strip(CNAME3)); cards; TEXAS GENCO LP LP MINERAL LLC A G SIMPSON AUTOMOTIVE & A G SIMPSON AUTOMOTIVE A A G SIMPSON AUTOMOTIVE I A G SIMPSON AUTOMOTIVE C A G SIMPSON AUTOMOTIVE U A G SIMPSON AUTOMOTIVE H A G SIMPSON AUTOMOTIVE H A G SIMPSON AUTOMOTIVE PA A G SIMPSON AUTOMOTIVE INC ; ... View more

That way of doing it works. here is a link to the same code you have provided that has the solution.   https://communities.sas.com/t5/SAS-Procedures/How-to-set-all-missing-values-to-zero-for-all-variables/td-p/41478   ... View more