About clarkchong1

clarkchong1 · ‎03-27-2019

Ah. That's obvious, wasn't it? Thank you!

clarkchong1 · ‎03-26-2019

Starting with a dataset similar to the following (with unknown number of columns / rows, but one of the column's name is ds_name): DATA foo; INPUT ds_name $ m1 m2 m3; DATALINES; ds1 1 2.1 3 ds2 3 4.7 5.3 ; RUN; How to automatically create a generic macro program that creates the following datasets? DATA ds1; INPUT m1 m2 m3; DATALINES; 1 2.1 3 ; RUN; DATA ds2; INPUT m1 m2 m3; DATALINES; 3 4.7 5.3 ; RUN; Thanks!

clarkchong1 · ‎03-26-2019

This works like magic! Thank you! More reference on MACRO quoting: https://blogs.sas.com/content/sgf/2014/08/15/macro-quoting-made-easy/

clarkchong1 · ‎03-26-2019

That's a great idea! How do one then combine text1 and text2 below to get text3? %LET text1 = a b; %LET text2 = c d; %LET text3 = a b c d; Thanks!

clarkchong1 · ‎03-26-2019

Thanks for the suggestion! I need to execute a macro functions with various input, with input defined by items in a comma delimited list supplied by the user. So I can't just do it in a data step.

clarkchong1 · ‎03-22-2019

I have the following macro variable definitions: %LET text1 = a; %LET text2 = %STR(b,c,d); What do I need to do to create text3 from &text1 and &text2, which is equivalent to assigning: %LET text3 = %STR(a,b,c,d); ? I need the resulting text3 to be able to be used as &value in the following sample code: http://support.sas.com/kb/26/155.html Thank you!

clarkchong1 · ‎01-02-2019

I know that SAS creates ROC curve and calculate AUROC for free when I run PROC LOGISTIC. According to this blog, Area Under Precision-Recall Curve is more appropriate in quantifying discrimination power of a model than AUROC. https://machinelearningmastery.com/roc-curves-and-precision-recall-curves-for-classification-in-python/ I tried searching online but could not find any instructions for plotting the curve or calculating AUPRC in base SAS (with SAS/STAT). Is there a built-in function for it? If not, how can we implement this? I am using SAS 9.4M4 with SAS/STAT 14.2 Thank you!

clarkchong1 · ‎06-27-2017

I am using SAS 9.4. The documentation for HPLOGISTIC said that its focus were to fit and score large datasets. I am wondering what is the optimal to use it to a) fit a model b) then use the model to score some future datasets I could think of at least two ways: i) use OUTEST option then capture the parameter output with ODS, then use INEST with 0 iteration in a future LOGISTIC / HPLOGISTIC statement ii) use the CODE option to generate the code for future scoring Which one is more preferred? Or is there a better third way? Thank you!

clarkchong1 · ‎06-21-2017

Thank you! It worked beautifully! Thanks also for telling me about the SASHELP library, I didn't previously know what is in it 🙂 A follow-up question, does HPLOGISTIC has OUTMODEL or this can be implemented using ODS as well? Thanks!

clarkchong1 · ‎06-20-2017

Hi Reeza, While HPLOGISTIC also has OUTEST, it seems that the functionality is completely different. The OUTEST switch doesn't allow specification of a output estimate dataset. For example, the following code would fail: PROC HPLOGISTIC DATA=&in_ds._binned_data OUTEST=parms; TITLE &in_title; CLASS &in_independent_class; MODEL &in_dependent(DESCENDING)= %DO j=1 %TO &in_num_cont; var&j._miss_ind /* NOT Commented out for comparison */ %DO k=2 %TO &in_num_bins; var&j._bin&k._ind %END; %END; RUN; Any suggestion?

clarkchong1 · ‎06-19-2017

I am using SAS 9.4. Does PROC HPLOGISTIC has an option similar to OUTEST of PROC LOGISTIC? I know HPLOGISTIC has CODE option which would produce the SAS code to score a future datset, but my concern is to output the parameter estimates in a format easily manipulatable by a downstream process for automation. Could this be done in HPLOGISTIC, say by using an ODS statement to capture them? Thank you!

Online Status	Offline
Date Last Visited	‎04-05-2019 05:45 PM

Re: How to create a macro variable with comma-delimited values from tw...

How to automatically create dataset with name equal to values of a col...

Re: How to create a macro variable with comma-delimited values from tw...

Re: How to create a macro variable with comma-delimited values from tw...

Re: How to create a macro variable with comma-delimited values from tw...

How to create a macro variable with comma-delimited values from two ma...

How to create the Precision-Recall Curve and calculate AUPRC in SAS?

Optimal way to use model previously fitted in HPLOGISTIC to score new ...

Re: Can PROC HPLOGISTIC output Parameter Estimate to a SAS dataset

Re: Can PROC HPLOGISTIC output Parameter Estimate to a SAS dataset

Re: How to create a macro variable with comma-delimited values from tw...

Re: How to create a macro variable with comma-delimited values from tw...

Re: How to create a macro variable with comma-delimited values from tw...

Re: Can PROC HPLOGISTIC output Parameter Estimate to a SAS dataset

Re: How to create a macro variable with comma-delimited values from tw...

How to automatically create dataset with name equal to values of a col...

Re: How to create a macro variable with comma-delimited values from tw...

Re: How to create a macro variable with comma-delimited values from tw...

Re: How to create a macro variable with comma-delimited values from tw...

How to create a macro variable with comma-delimited values from two ma...

How to create the Precision-Recall Curve and calculate AUPRC in SAS?

Optimal way to use model previously fitted in HPLOGISTIC to score new ...

Re: Can PROC HPLOGISTIC output Parameter Estimate to a SAS dataset

Re: Can PROC HPLOGISTIC output Parameter Estimate to a SAS dataset

Can PROC HPLOGISTIC output Parameter Estimate to a SAS dataset