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

"DM statement works only in Display Manager environment..."   What we have to do, then, is define Display Manager environment. Aren't all the SAS 9.4 'windows' included?   If we run a script in SAS 9.4, are we running that script in the DM environment?         ... View more

Here's one example.  Neither Anthropic's Claude nor ChatGPT can give me a revision that works: /********** 05.01 Analyze Duads in Batches **********/ %macro analyze_duads_batches;   %do i = 1 %to &num_batches;     %let start_row = %eval((&i - 1) * 1000 + 1);     %let end_row = %eval(&i * 1000);     proc sql noprint;       select duad into :duads_batch separated by ' '       from SAS_1.all_duads       where row_num between &start_row and &end_row;     quit;     %put NOTE: Processing batch &i from row &start_row to &end_row;     %analyze_duads_batch(&duads_batch);   %end; %mend;    /********** 06.01 Analyze Each Duad **********/ %macro analyze_duads_batch(duads_batch);   %let num_duads = %sysfunc(countw(&duads_batch));   %do j = 1 %to &num_duads;     %let duad = %scan(&duads_batch, &j);     %let var1 = %scan(&duad, 1, '_');     %let var2 = %scan(&duad, 2, '_');     %put NOTE: Analyzing duad &duad with variables &var1 and &var2;     proc reg data=SAS_1.train_data outest=SAS_1.results_&duad (keep=_RSQ_ _P_);       model &response_var = &var1 &var2;     run;     /* Check for errors and log the message */     %if &syserr ne 0 %then %do;       %put ERROR: Regression analysis failed for duad &duad.;     %end;     %else %do;       %put NOTE: Successfully processed duad &duad. Results stored in SAS_1.results_&duad.;     %end;   %end; %mend;    /********** 07.01 Execute Duad Analysis **********/ %analyze_duads_batches;     ... View more

"...only then try to turn that code into a macro. That will be a bazillion times easier than creating a macro from scratch."   Likely the LLMs go the macro route from scratch. LLM, "Piece of cake, boys..."     ... View more