@richardmgb,   If you have an issue, let's please open a new topic.  This topic from 2017 is dead, dead, dead.  🙂   thanks,   Jim ... View more

Thanks so much. I will try the procedures that you mentioned here.  ... View more

Thank you. I changed the missing codes back to missing.    1) I tested my respons (charge), and it is gamma distribution.    Below is my code for the model. proc genmod data=have;     class ;     model charge=year gender race ageGroup/dist=gamma link=log lrci; run;  I did not include marital_status in the model since the p-value greater than 0.05 (I use alpah=0.05). By applying the code into my real data, I have Pr>ChiSq for the intercept 0.8109. I am not sure what shall I do with the intercept since the p-value is so big.    You mentioned scoring method. I am wondering shall I use logistic regression for my model and test all the selection methods: forward, backward, stepwise, and score?    2) I also need to predict the total charges by year. I am thinking to use linear regression to build the model by proc reg with model charge=year. Thanks for any suggestions or hints.    ... View more

You opened rhe file in Word and then saved as a txt file? That should have stripped the RTF tags.  ... View more

Oh... I see. So that's stored in a CLOB in Oracle. That's gonna be tricky.   I've never been in your situation so can't speak out of experience. Just throwing some thoughts: - Everything I've proposed in my last post assumed that you have direct access to the RTF document as a file; but that's not the case - You would need to read the CLOB into multiple rows in SAS as a SAS variable can only hold 32KB. It's possible to do but needs some extra coding. - There must be a reason that someone stores the RTF's in Oracle. If you're just after something like number of hits for a search term then may be there is Oracle Text available and you could run your queries in-database and then just get the result back. I've never used Oracle Text so not sure how and if this could be called out of a remote SAS process.   What I would try first: Make things work directly in-database (using SQL developer; using Oracle Text). Only once things work try and call it out of a SAS session. ... View more

Thanks everyone for your replying. My database has more than 500 tables. We do not have a detailed data dictionary. I could enter the database as a front user to check for each table and find out the code. However, this is not an efficient way. Thank you for your input and the useful informaton.  ... View more

Actually, if its one workbook then @ballardw solution is correct, use the SHEET_INTERVAL option in ODS TAGSETS.EXCELXP Also, I don't know how that would be organized as CSV, would it be one group per CSV file so multiple CSV files? ... View more

Hi ... since you can use CAT functions with numeric data, how about a different data step ... data First; input ID :$3. type :$1. rev1-rev4; cnt_0 = count(catt(of rev:),'0'); cnt_m = count(catt(of rev:),'.'); cnt_1 = count(catt(of rev:),'1'); drop rev:; cards; 101 a 0 0 . 1 101 b 1 1 0 0 101 c 0 .  1 0 102 b 1 0 1 0 102 c 1 0 .  1 102 d .  1 1 0 ; Searching for Variable Values with CAT Functions: An Alternative to Arrays and Loops http://www.albany.edu/~msz03/epi697/ho/cat_find_rev.pdf and ... http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/TASS/Zdeb-CATFunctions.pdf ... View more