Create a sas dataset from python oanda dataframe using the personal altair slc

Roger DeAngelis_21630

Create a sas dataset from python oanda dataframe using the personal altair slc

Too long to post here, see github

github
https://tinyurl.com/5n7jw3hh
https://github.com/rogerjdeangelis/utl-how-to-create-a-sas-dataset-from-python-panda-dataframe-using-the-personal-altair-slc

SOAPBOX ON

I am new to the Altair SLC

Altair SLC, proc python, does NOT support export/import os sas datasets.
Altair proc R does support export/import of sas datasets.
However, Python can export pandas dataframes to R, using the rds format and
proc R can convert RDS files to sas datasets.

Too long to post here, see github

CONTENTS
1 Macro solution
a. convert panda dataframe to R rds file
b. macro wps_py2sastable ( R rds file from Python to SAS table)
2 hardcode no macro
3 macro & template on end

SOME NOTES ON The Altair SLC

 Proc R cannot exist in a macro

 Proc R cannot be called using call execute

 Proc R cannot be called using dosubl or %dosubl (neither supported)

 Proc R cannot be called using a macro string (like &_init_;)


 Also looks like the SLC does not support parmcards4;

 ERROR: Expected a statement keyword : found "parmcards4"


 Final resolved R code can be included in a macro using %include?

SOPABOX OFF

Nico Chart_21517

Hi Roger,

Thanks for sharing these useful comments.

I can add a quick comment and Altair SLC's implementation of "proc python". You can import a sas data set into a python data frame at the top of the proc python step, and you can export a data frame to a sas data set at the end of the proc python step. Could be useful for some people.

Best Regards,
Nico