Is there a way to use PROC Export to export a data set to a delimited text file using a custom 2 character delimiter?  My data includes a text field with long entries made by users, and frankly I am afraid that one day someone will have a delimiter in their text and throw off everything.  It's happened before.  I am using pipe (|) now, and it works for the time being.  But, in the long run I'd prefer to use something like |# as the delimiter.  I read online that Export does not support DLMSTR which is what this would require, as only the first row has double delimiters when I try using DBMS=DLM.   Is there another programmatic way around this?  I'd prefer not to use the File menu.   Hopefully, a future update will add dbms=DLMSTR to Proc Export. ... View more

Here is what the date looks like currently (character, length of 10):   Date 8/7/2023 9/30/2024 etc....   I tried this below but getting the error "Invalid argument to function INPUT"  Very very baffled as to why this isn't working.  Input is character to numeric, no? New_date = Input(Date, mmddyy10.); /*even tried adding this*/ format New_date yymmdd.; ... View more

I have this code using the across and analysis functions.  I want to add 1 column on the far right side which has the row totals going across, including those for the computed Totals.   If you are wondering about the single letter coding, I used those to re-word some values and found letters to be easier to manage while assigning the visible text in Proc Format.  No numbers because numeric format interfered with the Total labels.   If I have to change something, then I know exactly where to go.    proc report data=TEAM_SUMMARY nowd ; columns Team Activity Month, cnt ; define Team/ group order=data; define Activity/group "Activity" format=$Acty. order=internal; define Month/across "Month in Play" order=data f=$Month.; define cnt/analysis "" f=comma18.0; compute Activity; if Activity= 'J' then do; call define(_row_, "style", "style=[foreground=Red]"); end; if Activity = 'K' then do; call define(_row_, "style", "style=[foreground=Green]"); end; endcomp; break after Team/summarize style=[foreground=black just=r font_weight=bold]; rbreak after /summarize style=Header[background=lightgreen just=c]; compute before Team/style=[background=light grey]; line ' '; endcomp; compute after Team; Activity = 'Team Total'; endcomp; compute after; Activity = 'Grand Total'; endcomp; run;     ... View more

I have aggregated my data to get averages by Month, where I take a date value and use the put function to format the date in a monthyear format: put(Date, monyy7.) as Month I want the data set to be grouped by that, AND ordered by that in sequential order.  However, since this is a character format it is ordering it in alphabetical order.  Is there a numeric equivalent for this, or another way to have my aggregated data in the proper order? I need to have the months spelled out or at least abbreviated as this format does.  I've tried using ORDER BY Date (and leaving it out of the select to get the aggregation), but this gives me duplicates even if I use DISTINCT.  I've also tried using 2 steps by creating the month variable in an unaggregated set and ordering by Date, but that order does not carry over when I create an aggregated set from it.  ... View more

I have several PROC report statements that I want to output to using ODS PDF with approx 2 to 3 per page.  I am using the startpage=no in the first ods file statement and startpage=now where I want to have pagebreaks.  However, when I do this it's only giving me 1 title and footnote per page --those for the first statement.  How do I maintain the individual titles and footnotes for each output on the page?  ... View more