I work with at form thats use dynamic sas in a front end excel solution.  When tagattr formula i used with a if clause excel puts #Navn (danish) #NA in a correct code. See code exampel. If use of F2 without any changed correct formula has been used.  The code is in danish because we use excel2016 in danish - and because autotranslation in xml with excel function length or upper return error i xml to excel.  The english is   [tagattr="format:#,##0 formula:if(length(RC[-4])>0,RC[-2]*RC[-3],0)"] ; Full danish code with tabulate= ;  (danish excel syntax) gives error. It doesn't matter if tagattr is written in define or compute.  The full code i want to use is tagattr="formula:hvis(længde(RC[-1])>0,j5*(Satser!B4/100),0)" so that the user make input (here cell=j5) and return the right values. "Sater!b4" is a reference to another worksheet. The code is correct, but in excel is #Navn/#NA shown. How can i show the results in var=testhvis with out the #Navn error?     ods excel file="&udadhoc.\test_tagattr.xlsx"; proc report data=sashelp.class out=testcase ; column sex height weight testudenhvis testhvis ; define sex / group; define height / analysis sum; define weight / analysis sum; define testudenhvis / computed style(column)=[tagattr="format:#,##0 formula:RC[-1]*RC[-2]"] ; define testhvis / computed style(column)=[tagattr="format:#,##0 formula:hvis(længde(RC[-4])>0,RC[-2]*RC[-3],0)"] ; rbreak after / summarize ; run; ods excel close; Sex Height Weight testudenhvis testhvis F 545,3 811 442.238 #NAVN? M 639,1 1089,5 696.299 #NAVN?   1184,4 1900,5 2.250.952 #NAVN? ... View more

SAS Skill Builder for Students is a powerful tool for university students to learn the necessary skills to begin a career in analytics. ... View more

Team Name TMG Track Manufacturing Use Case As a manufactuer .  we have a tons of instructions to all our employees.  So we would to use SAS GenAI to create a chatbot that can reply fast to doubts and help new employees to understand the procedures. Technology SAS Viya Region EMEA Team lead Marilio Meireles Team members *@DuarteO @MariaFJ  Social media handles   Is your team interested in participating in an interview? N Optional: Expand on your technology expertise     ... View more

A new update is available for SAS/ACCESS Interface to Teradata , version 9.46 : Hot Fix: N5V001 - Published 18SEP2024 , Download link for N5V001 Component name: SAS/ACCESS Interface to Teradata Related SAS release: 9.4   Issues addressed in N5V001 SAS Note 64142 Teradata Parallel Transport performance is slower with TTU 16.10 than it was with TTU 15.0 SAS Note 64150 SAS/ACCESS® Interface to Teradata does not retrieve the correct number of rows when the number of rows exceeds 4.2 billion SAS Note 64600 \"ERROR: Teradata insert: Invalid timestamp\" might occur when you apply a SAS/ACCESS® Interface to Teradata hot fix to SAS® 9.4 maintenance releases SAS Note 66794 A WHERE clause for a Teradata BIGINT column generates the message \"...Precision error in FLOAT type constant or during implicit conversions...\" SAS Note 69574 Trying to read in a Teradata table that contains a variable defined as a DATE data type might generate a conflicting data type error SAS Note 70963 SAS/ACCESS® Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.20 with SAS® 9.4M6 in Linux and Microsoft Windows environments This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for N5V001   Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes. ... View more