Recent Activity
Among its many capabilities, the SAS Risk Engine allows users to extend its functionality by incorporating custom functions, enabling organizations to align risk analytics precisely with their unique business requirements.
... View more

- Find more articles tagged with:
- GEL
- SAS Risk Engine
Labels:
0
0
Hello
I have a data set with 2 million rows and 150 columns.
Each customer ID have one row.
The columns are from 3 types of fields-
continuous (such as wealth amount),
count (such as number of active loans),
binary (such as indicator of failure in payments)
CHAR( such as address)
I want to check the data if it has no problems (for example : if a specific field has only null values )
I thoughts about create 3 reports for each type of variable-
For each continuous/count var check-
number of customers with null value
number of customers with value 0
number of customers with POS value
For each binary var check- number of customers with null value number of customers with value 0 number of customers with value 1
For each char var check- number of customers with null value number of customers with not null value
What is the way (code) to create it please?
options missing=.;
Data have;
input CustID x1 x2 x3 w1 w2 B1 B2 C1 $ C2 $ ;
cards;
1 10.1 15 20 0 2 0 0 abx .
2 . . 21.1 0 0 1 1 abx def
3 12 14.4 16 . . 1 1 abx def
4 18 . 20.8 0 0 0 1 abx def
5 . . . 1 3 0 0 . def
;
run;
... View more

0
8
I am running a list, and I used a variable to group the results. However, the grouping labels are missing in the output, so I don't know which table is which! How do I get these titles/labels to show up so that I know which table is which in the list? What am I doing wrong?
... View more

0
1
Dear SAS Community, I have many categorical variables in my data, and I have been using the following analytic procedure to get my 2x2 results with column counts and percentages, but I would like to add brackets separating the counts from the percentages in the form of xx (%) instead of xx %. Below is the code and sample view of the current outputs. /*Obtaining 2x2 counts and percentages for all categorical variables stratified by Age Category Columns */ Proc Freq Data=Analysis; Tables _Char_*Age_Category/Chisq norow nopercent; run; The above code generates results for the variables including column counts and percentages as follows (see sample below). Copying results from each cell and then adding brackets in the word file for each cell takes a lot of time and I would like to find a solution on how to add the brackets, for example, for the first cell to be produced as 9 (1.35). I will be glad to receive assistance and sample code that I can apply to my data for such procedures. Thank you.
... View more

0
4
Hi, I'm a complete and total noob about anything SAS-related, I registered an account just now just to ask this - if posted in the wrong forum I am sorry, please point me to where it belongs or move post accordingly. I have this user who asked me about changing the location of the cfg-file that determines the location of the WORK library -> it's currently saved on an external hard-disk drive, she wants it locally on her computer. I have no idea what a WORK library is and what it entails to change the location of the file that manages it, so I have no idea if I can tell the user if and how we can do that. I've found some complicated articles saying how to do it, but none explicitely confirmed the scope of how it impacts how SAS behaves as seen by the user. Her SAS version is 9.04 (there was a long string of numbers and letters following 9.04, please let me know if that's relevant information to add here) and this is the list of products she has: ---Base SAS Software ---SAS/STAT ---SAS/GRAPH ---SAS/ETS ---SAS/IML ---SAS/Secure 168-bit ---SAS/Secure Windows ---SAS Enterprise Guide ---SAS/ACCESS Interface to PC Files ---SAS/IML Studio ---SAS Workspace Server for Local Access ---High Performance Suite I'm not even sure what others questions, if any, I should ask to ascertain wether or not she can/should do this, and how. Any and all help will be greatly appreciated thank you. Sidenote: I mostly create email accounts, swap monitors and change cables for a living but made the mistake of telling my boss I want to do more. This is the result XD. Please be gentle.
... View more

0
4
Unanswered topics
These topics from the past 30 days have no replies. Can you help?
Subject | Likes | Author | Latest Post |
---|---|---|---|
0 | |||
0 | |||
0 | |||
0 | |||
0 | |||
0 | |||
1 | |||
0 | |||
1 | |||
0 |