Home

GANESHR

Hi, I try to add a filter criteria for the CDD flows select only but it is not working why ? is the filter criteria incorrect? pls advise thanks Ganesh

Stephanvd

An XLSX file updated (not generated) with the SAS XLSX LIBNAME engine does not open successfully in Excel (windows 11), while the code did work in Windows 10. Test: 1. XLSX File created in windows explorer (New -> Microsoft Excel Worksheet) 2. SAS code to add new sheet 'class' from sashelp.class 3. Error message during opening (see appendix): 1. We found a problem with some content in 'excel_win.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes. 2. Excel was able to open the file by repairing or removing the unreadable content. Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Removed Records: Cell information from /xl/worksheets/sheet2.xml part Question: Could you please help with the possible cause, plus a check on how I can verify this and ultimately fix it? Note: By creating the XLSX file from scratch in SAS, it works without issue. Code: /*ERRORS: Update XLSX (Add sheet)*/ libname xls xlsx "<PATH>\test.xlsx"; data xls.class; set sashelp.class; run; libname xls clear ; /*SUCCESSFULL: Create XLSX (Create file)*/ libname xls2 xlsx "<PATH>\test2.xlsx"; data xls2.class; set sashelp.class; run; libname xls2 clear ; Or thoughts: - The internal XML structure of the blank file, created by Windows/Excel, is somehow incompatible with the way the SAS LIBNAME XLSX engine modifies it to insert data - When writing character data, a mismatch between a limited SAS session encoding and Excel's internal UTF-8 requirement, leads to a trans-coding error that corrupts the XML structure.

PhilGUK

In EG, I discovered the Project Properties: Code Submission = Allow parallel execution on the same server check box. I used that to develop a project flow that had 3 or 4 code nodes in series, it then branched to run 6 things in parallel, before returning to run in series. Each of the parallel parts took about 50 mins, so running in parallel saved about 5x50 = 250 min = 4h+. At the time, I thought I found something online that showed the same kind of thing was available with a switch in SAS Studio flows. This blog from 2016 shows something: SAS Studio Parallel Process Flows - SAS Users However, that has .cpf for flows, where we now have .flw for flows and the properties are not the same. I have been asked if flows in Studio can be set up to run the same as I had in EG. I can't find anything that explains if this is possible/how to do it. Is running different parts of a flow in parallel possible in Studio, as it was in EG? What I ended up with in the EG Flow was very much like a flow in SAS Management Console. Separate jobs doing their own thing in a separate WORK session, with SAS MC handling the dependencies. Where the "jobs" shared data/macro variables, I had to take steps to make sure they had the same environment, macro vars and a "shared" work lib (as a perm library) where they could share datasets that previously were in WORK. That flow was complex due to the amount of shared items, but the concept was easy enough to understand and apply. Older versions of Studio appear to have this option, does current version have it hidden away? We are SAS Studio Version: Stable 2025.09 Many thanks Phil

hellohere

I have a zipped file with thousands of text files, and just need readin a few of them. How to readin text file inside a zipped file without zipping?! Is that possible? Say the zipped file name is filezipped.zip and the file inside need be readin is file_0001.txt. What would be the sample code?! I know how to unzip the file within SAS and readin text file.

AndersS

I have a question: What tools are there in the Data-step make a Relative Rounding of a numeric number? I know about the ROUND, ROUNDE and ROUNDZ functions. But they make an Absolute rounding. Example: Population is some countries: 345,123456 34,123456 3,123456 123456 23456 But the user rather wants relative rounding to e.g.3 digits, like 345,000000 34,100000 3,120000 123000 23400 (Yes I have some ideas about to achieve this - if it is not already solved. Please omit any misprint - Some Covid-19 look alike here) /Br Anders Sköllermo - Skollermo in English

Recent Solutions

Featured Article

Featured Webinar

Recent Activity

how can make the filters work on Visual investigator pages

SAS XLSX Export Failure: Character Data Lost in Pre-Created Excel Files (Win11 Environment)

Parallel Execution in SAS Studio Flows on Compute

How to readin text file inside a zipped file without zipping?!

Relative Rounding in the Data step.

Unanswered topics

Connecting to SAS Library via Ole DB connection in Power BI

Endpoint "/svi-alert/alertActions/&actionType" only works when I reset...

Fun With SAS ODS Graphics: Veterans Day

Additional processes after closing SAS Studio

Customer Intelligence Blog Spotlight: Featuring Amazon Bedrock

Creating action buttons in SAS VI viya4

Fall 2025 ESUG Meeting - Agenda and Presentations

caslib vs CAS libref (+ CAS format library)

SAS tool (Task scheduler) not working when to moved to a different fol...

MRM Data related to Model, Model Review, Finding, etc

Registration is open

Call for Content EXTENDED