This appears to the start of the macro.  Seems this might be where the error is.  If so, it needs to be edited in some way.  The error (??) is probably preventing the macro from being 'compiled' in the current session: %macro sweet_spot_and_confidence_all_folds( libname=SAS_1, response_variable=i_016, predictor1=i_127, predictor2=i_128, k_folds=5, report_file=final_report_%sysfunc(today(), yymmdd10.).txt );     ... View more

Sometimes ChatGPT just simply falls short when it comes to advanced macros.  Terribly frustrating.  Error after error after error. I let Claude have a look, and Claude sometimes magically finds the solution.  Unreal.  No errors in the execution. But, generally ChatGPT seems to have an edge over Claude.  And!!!  ChatGPT allows attaching more types of stuff.  INCLUDING SAS DATASETS THEMSELVES!!!!   ... View more

Similar to talking with a human:  If you use grade school talk, you don't get far.  If you use post grad talk, you get lots further.    ChatGPT and Claude are able to carry on quite well at the post grad level.  Not true of most humans. ... View more

Some of the 'labels' exceeded the length SAS allows as variable names.  Thus, had to go the short-version route.   Very fortunately, SAS permits 'labels', and shows those in many procedures.     ... View more

There are 'labels' included in the SAS dataset(s).  These labels are way more descriptive of the columns than the short variable names I was forced into.  I just hate losing these labels. But, alas, we must, apparently.  I don't know that .parquet even supports such labels anyway.   Was worth a try. ... View more

Well, that would explain it.  I'm just a regular person, more or less.   So, we don't have access to the advanced stuff, like converting a small SAS dataset to .parquet format.   Bummer.   ... View more

Well, when I tried out the suggestion, just got errors:   69 cas mySession; ERROR: The request to start or connect to a session failed. Specify a UUID to connect to an existing session or specify a session name, port and host name to start a session. 70 71 proc casutil; ERROR: A connection to the Cloud Analytic Services session could not be made. ERROR: An error has occurred. 72 save casdata="cleaned_data" 73 casout="cleaned_data.parquet"; ERROR: An error has occurred. 74 run;   Seems more is needed.   ... View more

Uhh, me?   It wasn't hard simply signing up.   I generally use PC SAS 9.4.   On this one occasion I needed a .parquet file, and Python was having a hard time with the conversion.  I discovered SAS Viya has the ability to convert to .parquet.  So, this one time I thought I'd give it a try.     ... View more

LOL.  No SAS Admins here... So, in other words, no luck converting the SAS dataset through SAS Studio? I wouldn't think accomplishing such a simple procedure would have restrictions.   Any suggestions to get around this, and accomplish it via the SAS site here??   ... View more

Or even a .txt file.   Easy peasy.   ... View more

I did indeed.  Works nicely.  Thank you! However, I'd still prefer PC SAS end up with the Log window top-most.   Such a simple request.   ... View more

I prefer to drag my SAS scripts from Windows Desktop (or Explorer) to the SAS Log window.   One after another.   That's why I would prefer PC SAS to end up with the Log window on top at the end of running a script.  Just one less hassle.   ... View more

Yep, SAS 9.4, what I said at the outset should work, but doesn't. /* Command to switch to the Log window and maximize it */ dm 'log; wmaximize;';   Perhaps give it a try in some script.  Put it at the end of the script. The objective is to end up with the 'Log' window on top, maximized.   Maybe DM commands do not work from scripts?   ... View more