cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
TaniaRTP
‎01-05-2024
  • 15 Posts
  • 2 Likes Given
  • 1 Solutions
  • 6 Likes Received

Re: Need to insert line break in Excel using PROC EXPORT

by Obsidian | Level 7 in SAS Programming
‎12-29-2023 06:27 PM
‎12-29-2023 06:27 PM
Thank you @Patrick for your feedback and for simplifying my life with CATX function tip.   The output structure was developed & approved several years ago; one row per event. Now, I am adding a few additional columns however these columns are not the focus of the list and won't be used for filtering. The end users need to see a list of which ConMeds were taken within 30 days of the event, what terms are in the subject's Med Hx, etc.   When I saw that you were able to wrap in your environment with '0A'x, it was evident that something else was wrong with my environment or the program. ... View more

Re: Need to insert line break in Excel using PROC EXPORT

by Obsidian | Level 7 in SAS Programming
‎12-29-2023 05:05 PM
‎12-29-2023 05:05 PM
This should've been accepted as solution.   After seeing another user's response that wrap text also worked for them, I started reviewing. One of the last manipulations was to strip unprintable characters. ... View more

Re: Need to insert line break in Excel using PROC EXPORT

by Obsidian | Level 7 in SAS Programming
‎12-27-2023 04:47 PM
1 Like
‎12-27-2023 04:47 PM
1 Like
Thank you for your advice. I previously used '0A'x to force a break. I inserted "0D0A"x too. Neither worked with the Carriage break (also called Wrap Text) feature in Excel.     ... View more

Need to insert line break in Excel using PROC EXPORT

by Obsidian | Level 7 in SAS Programming
‎12-22-2023 03:12 PM
‎12-22-2023 03:12 PM
I am creating an Excel workbook and for a specific cell within a worksheet, I need to insert line breaks/wrapping to make it more readable.   As an example, my variable MHDEETS has this value and looks like this within Excel 01. Seasonal allergy /Ongoing 02. Appendicectomy YYYY/YYYY 03. Hypoxia YYYY-MM/Ongoing  04. Hypoxia YYYY-MM-DD/YYYY-MM-DD 05. Right ventricular failure YYYY-MM-DD/YYYY-MM-DD 06. Atrial flutter YYYY-MM-DD/YYYY-MM-DD   however, I'd like for it to appear like below:   01. Seasonal allergy /Ongoing 02. Appendicectomy YYYY/YYYY 03. Hypoxia YYYY-MM/Ongoing  04. Hypoxia YYYY-MM-DD/YYYY-MM-DD 05. Right ventricular failure YYYY-MM-DD/YYYY-MM-DD 06. Atrial flutter YYYY-MM-DD/YYYY-MM-DD   Here is the simple SAS code proc export data=finalae outfile="&maindir.Output\STUDYID Serious and non-serious AEs &tlfdt..xlsx" label replace dbms=xlsx ; sheet='STUDYID_AE_MH_CM' ; run ;   Does anyone have suggestions on how I can do this? Any help would be appreciated. ... View more

Re: SAS 9.4 exporting corrupted XLSX files

by Obsidian | Level 7 in SAS Programming
‎02-12-2019 11:54 AM
‎02-12-2019 11:54 AM
I was able to use this function on all character variables and no longer got the corrupt xlsx file.  I read in an Excel sheet (my source which had query response text from sites all over the world), manipulated & summarized the data, then needed to output it back to a workbook with other sheets. ... View more

Re: Problem with content in Excel using ODS EXCEL and PROC REPORT

by Obsidian | Level 7 in ODS and Base Reporting
‎11-15-2018 11:39 AM
‎11-15-2018 11:39 AM
I was able to pinpoint it as observation #405 out of 473 by restricting observations.  Because all of my datasets were doing similar, I tried using another dataset to determine if was the same subject or site causing the issue.  There doesn't appear to be a clear culprit here. ... View more

Problem with content in Excel using ODS EXCEL and PROC REPORT

by Obsidian | Level 7 in ODS and Base Reporting
‎11-14-2018 05:36 PM
‎11-14-2018 05:36 PM
I am receiving an error similar to this previous post:   https://communities.sas.com/t5/SAS-Analytics-U/Proc-print-to-an-Excel-file-produces-corrupt-file/td-p/330048   I am using PROC REPORT and ODS EXCEL to create a .xlsx file but when I go to open it, I receive this message.                 If I click YES, and open, then I get output which contains only the fields which are numeric.                 My results window within SAS Studio do show that the characters printed.                 I don't think there's an issue with the data (but I could be wrong), because I can use PROC EXPORT and all character variables are present & populated.  I just can't use EXPORT because I need highlighting & formatting.   Here is the code: ods excel file="&outfile" options(sheet_name="x") ; proc report data=annot nowd headline headskip split='*' missing spacing=1 style(header)=[font=('Arial',8pt)] style(column)=[font=('Arial',8pt)]; define color / display noprint; compute color; if color='Green' then call define(_row_, "style", "style=[background=lightGreen]"); else if color='Red' then call define(_row_, "style", "style=[background=lightRed]"); else if color='Yellow' then call define(_row_, "style", "style=[background=Yellow]"); else if color='White' then call define(_row_, "style", "style=[background=White]"); endcomp; run; ods excel close ;   Does anybody have suggestions on how I should proceed or what is causing my error?   Many thanks in advance. ... View more

Re: How do I get rid of invalid characters error?

by Obsidian | Level 7 in SAS Studio
‎09-17-2018 12:13 PM
2 Likes
‎09-17-2018 12:13 PM
2 Likes
The format was created within the program so it wasn't being read from an external file.     I looked at old PDFs, and I can't ascertain what the purpose of the format was.  The previous output displayed as 0 and 1 (the raw values), not special characters, so I think omitting the format is fine.  I truly thank you for your replies & assistance. ... View more

Re: How do I get rid of invalid characters error?

by Obsidian | Level 7 in SAS Studio
‎09-17-2018 12:03 PM
2 Likes
‎09-17-2018 12:03 PM
2 Likes
Thank you Reeza for the reminder.  I hadn't looked at variables causing the issue, only observations.     It was the variable MATCHX. There was a format being applied (don't know why).  I commented out the format and it works perfect! ... View more

Re: How do I get rid of invalid characters error?

by Obsidian | Level 7 in SAS Studio
‎09-17-2018 12:01 PM
‎09-17-2018 12:01 PM
Thank you Reeza for the reminder.  I hadn't looked at variables causing the issue, only observations.     It was the variable MATCHX. There was a format being applied (don't know why).  I commented out the format and it works perfect!   value matchx 0='B4'x 1='D6'x; ... View more

Re: How do I get rid of invalid characters error?

by Obsidian | Level 7 in SAS Studio
‎09-17-2018 11:44 AM
‎09-17-2018 11:44 AM
I'm unaware if SAS was recently updated.   ... View more

Re: How do I get rid of invalid characters error?

by Obsidian | Level 7 in SAS Studio
‎09-17-2018 11:40 AM
‎09-17-2018 11:40 AM
Thank you. I have checked my session encoding (UTF-8).  I have also specified the encoding option everywhere --- PROC REPORT DATA=xxx(encoding=yyyy) --- all my work datasets   I tried each of these encoding options:  UTF-8, asciiany and "session".   Additionally, I tried to confirm if it was a particular observation by deleting observations various ways, but still get the error:   ERROR: Invalid characters were present in the data. ERROR: Invalid characters were present in the data. ERROR: An error occurred while processing text data.   I switched to Enterprise Guide & ran it with encoding=utf8, asciiany and they both ran without error, producing a PDF.  Any other thoughts? ... View more

Re: How do I get rid of invalid characters error?

by Obsidian | Level 7 in SAS Studio
‎09-06-2018 02:56 PM
‎09-06-2018 02:56 PM
Yes, I've attached the log.   No, the programs did not move from Unix to Windows.  The way it's setup here, we have access to both EG & SS.  We connect remotely to SAS servers, so even though the program was built in EG, when I open it using SS, I'm accessing the EG program from the same remote location/servers.  I did not have to copy/paste.   Thanks again! ... View more

How do I get rid of invalid characters error?

by Obsidian | Level 7 in SAS Studio
‎09-06-2018 02:17 PM
‎09-06-2018 02:17 PM
I'm extremely new to SAS Studio and SAS EG and I'm trying to takeover inherited programs.  I've been using PC SAS for years.  The program was written originally using SAS EG, however, I'm trying to switch to SS.  If I submit the code in SAS EG, it works without issue.    When I submit the exact same code via SS, I get the following error, when the code is trying to write the WORK dataset out to a PDF using PROC REPORT.  ERROR: Invalid characters were present in the data. ERROR: Invalid characters were present in the data. ERROR: An error occurred while processing text data. NOTE: The SAS System stopped processing this step because of errors.   There were not any issues reading the datasets from external source to WORK dataset.  The error only popped up at the PROC REPORT. proc report data=fjoin nowd headline headskip split='*' missing spacing=1    style(header)=[font=('Arial',8pt)]    style(column)=[font=('Arial',8pt)];    column order1 order2 order3 matchx       ("Data Management (Rave EDC as of &ravedt.)" dm_subno dm_begin dm_text dm_end dm_fromcopy)       ("Drug Safety (Argus as of &argusdt)" ds_event ds_begindt ds_text ds_enddt ds_isclosed) stdyday color;    by order1;    define order1 / order noprint;    define order2 / order noprint;    define order3 / order noprint;    define matchx      / display width=1 format=matchx. center ' ' style(column)=[font=('Symbol',8pt)];    define dm_subno    / display width=6 format=z6. center 'Subject*Number' style(column)=[cellwidth=0.6in];    define dm_begin    / display width=6 format=$20. center 'Onset*Date' style(column)=[cellwidth=0.9in];    define dm_text     / display width=35 left flow 'Preferred Term/*Reported Term/*Causality' style(column)=[cellwidth=1.95in];    define dm_end      / display width=6 format=$20. center flow 'Resolved*Date' style(column)=[cellwidth=0.9in];    define dm_fromcopy / display width=8 format=1. center 'CRF Is*Copy?' style(column)=[cellwidth=0.5in];    define ds_event    / display width=15 format=$20. left flow 'Case*Number' style(column)=[cellwidth=0.6in];    define ds_begindt  / display width=6 format=$11. center 'Onset*Date' style(column)=[cellwidth=0.9in];    define ds_text     / display width=35 left flow 'Preferred Term/*Reported Term /*Causality' style(column)=[cellwidth=1.95in];    define ds_enddt    / display width=6 format=$11. center 'Resolved*Date' style(column)=[cellwidth=0.9in];    define ds_isclosed / display width=8 format=$yesno. center 'Case Is*Closed?' style(column)=[cellwidth=0.5in];    define stdyday     / display width=5 format=best8. center 'Study*Day' style(column)=[cellwidth=0.5in];    define color       / display noprint;    compute color;       if color='Red' then call define(_row_, "style", "style=[background=lightRed]");       else if color='Yellow' then call define(_row_, "style", "style=[background=Yellow]");    else if color='Green' then call define(_row_, "style", "style=[background=lightGreen]");       else if color='White' then call define(_row_, "style", "style=[background=White]");    endcomp;    break after order1 / skip; run; Can somebody please help by pointing me to what option(s) I need to play around with? Many thanks in advance. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-05-2024 03:48 AM
Likes given to
View All
Likes from
View All
Quick links