Can we connect SASPy to an open/free license to test it out? I don't have SAS installed on my machine, but I would like to try this.   may be limited to SAS9.4 but you can certainly connect SASPy to an OnDemand-For-Academics session which is free [for personal non-commercial use] - and not restricted to academics. Original answer (to save you looking back) states it can be used for Viya test. ... View more

OK - you probably don't need to do this in macro language at all - but assuming you do, the following addresses numerous issues:   It is common to overthink use of macros (especially if you have just come across them) but I would achieve the same result using: Good luck, Enjoy SAS. ... View more

apologies I misunderstood - the +3 finds the position of 'Z' - remove it (or change to +0) to get position of string ... View more

With apologies to Patrick for stealing his test data, perl expressions will do the job but can be difficult to understand - why not just use translate and the method your question suggests:     If the character '#' may also appear in the string then just substitute another printable character - or even a non-printable character such as '00'x ... View more

could use saspy: sas.sd2df('cars','sashelp').to_parquet('/tmp/cars.parquet')   I run in databricks [community edition] which allows me to then write directly to s3 using a dbfs:/mnt mount and following:   dbutils.fs.cp('file:/tmp/cars.parquet','dbfs:/mnt/jgalloway/parquet/cars_from_sashelp.parquet')   but there will be numerous other ways to get your parquet to s3 (WinSCP is another option for this) ... View more

Attached document sas-setup.docx contains Databricks notepad to run saspy from it’s Community Edition which is free for personal non-commercial use – there is a link in the notebook/word document   I start the document with my sascfg_personal.py configuration, then include a copy of the notebook, which I have called sas-setup   This builds on previous use of saspy in Jupyter notebooks and - after a couple of days fine tuning - doesn't require any software on local machine - just sign up for Databricks Community Edition and SAS OnDemand for Academics (or modify the sascfg_personal.py to use with other SAS connections)   Enjoy! ... View more