topic Re: Using SAS Studio Online to Convert A Dataset in SAS Software for Learning Community

Using SAS Studio Online to Convert A Dataset

NKormanik — Sun, 07 Jul 2024 07:16:37 GMT

proc casutil;
save

casdata="cleaned_data"

casout="cleaned_data.parquet";
run;

Getting errors. Suggestions greatly appreciated:

69 proc casutil;

ERROR: A connection to the Cloud Analytic Services session could not be made.

ERROR: An error has occurred.

70 save casdata="cleaned_data" casout="cleaned_data.parquet";

ERROR: An error has occurred.

71 run;

Re: Using SAS Studio Online to Convert A Dataset

Kurt_Bremser — Sun, 07 Jul 2024 07:49:56 GMT

You need to correctly initiate a CAS session first. Your SAS admins will assist you in this.

Re: Using SAS Studio Online to Convert A Dataset

NKormanik — Sun, 07 Jul 2024 21:27:10 GMT

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??

Re: Using SAS Studio Online to Convert A Dataset

SASKiwi — Sun, 07 Jul 2024 22:10:17 GMT

Have you had any training at all on using Viya?

Here's a link to the CAS doc about starting a CAS session. I recommend you read up about getting started with Viya if you aren't sure of the steps. I've never used Viya myself but these pages look easy to follow.

Re: Using SAS Studio Online to Convert A Dataset

Kurt_Bremser — Sun, 07 Jul 2024 23:10:08 GMT

And who set up your SAS environment in your organisation?

Re: Using SAS Studio Online to Convert A Dataset

NKormanik — Mon, 08 Jul 2024 01:02:14 GMT

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.

Re: Using SAS Studio Online to Convert A Dataset

SASKiwi — Mon, 08 Jul 2024 02:26:34 GMT

You refer to "SAS Studio Online" so I can only guess you are using SAS Viya for Learners. Is this correct? If so then the links I provided earlier should help you get started.

Re: Using SAS Studio Online to Convert A Dataset

NKormanik — Mon, 08 Jul 2024 02:47:30 GMT

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.

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.

Re: Using SAS Studio Online to Convert A Dataset

SASKiwi — Mon, 08 Jul 2024 05:01:39 GMT

I've moved your post here where users of SAS Viya for Learners are more likely to see it.

Re: Using SAS Studio Online to Convert A Dataset

JackieJ_SAS — Mon, 08 Jul 2024 21:51:17 GMT

Hi,

SAS Studio is the interface you use to access SAS. The SAS Studio interface can be used with two SAS products- SAS 9.4 and SAS Viya. Online versions of both of these exist. SAS OnDemand for Academics runs SAS 9.4 software. SAS Viya for Learners | SAS runs SAS Viya software.

The PROC CASUTIL code you mentioned will not run in SAS 9.4 software. It will only run in SAS Viya.

In order to use SAS Viya for Learners, you need to be an academic faculty, student, or staff and have a SAS profile with an email address affiliated with an academic institution. Do you have that?

If not, it sounds like you have SAS 9.4 on your computer, but not SAS Viya. Unfortunately, this means the PROC CASUTIL code you mentioned is not going to run on your system.

Re: Using SAS Studio Online to Convert A Dataset

NKormanik — Mon, 08 Jul 2024 23:51:44 GMT

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.

Re: Using SAS Studio Online to Convert A Dataset

Tom — Tue, 09 Jul 2024 01:15:14 GMT

Convert the SAS dataset to a CSV file

https://documentation.sas.com/doc/en/pgmsascdc/v_052/pgmgs/p14twtiyode7jhn18sqqmm68vccf.htm

and then use Python to make a parquet file.

https://robertochiosa.medium.com/a-python-guide-to-compress-csv-data-into-parquet-8c797136aa38

Re: Using SAS Studio Online to Convert A Dataset

NKormanik — Tue, 09 Jul 2024 01:36:35 GMT

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.

Re: Using SAS Studio Online to Convert A Dataset

Tom — Tue, 09 Jul 2024 12:05:45 GMT

As always with a CSV file you should make a separate file that describes the variables since there is no place in the CSV file to store labels, or type, or length, or format, etc.

It is also not hard to make the CSV file using the labels as the column headers. But I have no idea how that would impact the usefulness of the parquet file to have descriptions instead of names for the variables.

Re: Using SAS Studio Online to Convert A Dataset

NKormanik — Tue, 09 Jul 2024 20:15:20 GMT

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.