Hello
Let's say that I want to create a data set based on sas_help.class data set.
The new data set will have only 2 columns: Var_name , Var_Value
What is the way to do it?
I expect that the new data set will have 95 rows (because in sas_help.class have 19 rows with 5 columns so 19*5=95)
thanks
... View more
A new update is available for SAS/ACCESS Interface to Microsoft SQL Server , version 9.45 : Hot Fix: M2L006 - Published 21MAY2024 , Download link for M2L006 Component name: DataDirect ODBC Driver for Microsoft SQL Server Related SAS release: 9.4 Issues addressed in M2L006 SAS Note 70800 Writing to Microsoft SQL Server fails with \"ERROR: CLI describe error: [SAS][ODBC 20101 driver][Microsoft SQL Server]...\" This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for M2L006 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
As discussed with the customer, the user need to add/edit some information related to the closed alert. Anyway, in SAS AML8.3 the system does not allowed user to edit the comment of closed alert.
Please help to consider to add the function of 'add/edit comment to alert after the alert is closed' into SAS AML8.3
Thanks!
... View more
Refer to SAS AML8.3, the system is only allow the user to perform any actions on the most recent snapshots (SFEs) for the suspicious activity that has been discovered. This is not allowed the user to add/edit the information of the previous alert. This affects the work process of user in case if the user record the wrong investigation or need to re-investigated the information in the previous alert.
So, the expectation from the customer is, when the new Alert is generated, the user should be able to ‘Edit’ some information in ‘the previous Alert’ such as.. ‘Rate productivity’ to put the comment (in Fired Event Level) for that alert.
... View more
Please I need clarifcation on the code below. Thanks.
"data-type bis enclosed in parentheses and specifies one of the following: CHARACTER (or CHAR) | VARCHAR | INTEGER (or INT)."
proc sql; create table work.discount (Destination char(3), BeginDate num Format=date9., EndDate num format=date9., Discount num); quit;
I expect the data-type should be in parenthesis based on the syntax description above, e.g, Destination (char)(3). Please what am I missing?
... View more