To load a sas table into Python is easy with the pandas module in Python, i.e. pd.read_sas. For documentation of that, see this link: https://www.marsja.se/how-to-read-sas-files-in-python-with-pandas/  Now my problem is the following:  I have SAS tables that I want to read into Python, this is easily done with pd.read_sas.  Then I will do some work in Python and would finally like to export the data frame to a Sas file directly, is this possible to do?  Note: I am aware of that the latest version of VIYA can handle Python code inside a SAS session but this is not relevant since in my organization we will not have the latest VIYA version.  Edit: Writing proc setinit; run; I get the following: Current version: 9.04.01M5P091317 ... View more

I am writing a macro function that takes dates as input. Here is an example demonstrating what I would need:  /* In "General", this is how the macro should work. Example available below */ %macro MyDemonstrationMacro(Arg1, Arg2) %let FirstDate = &Arg1. /* Same as first argument */ %let SecondDate = &Arg2. /* Same as second argument */ %let Third_Date = Function(Arg1) /* Follows from first argument BUT another format and first day in the month */ %let Fourth_Date = Function(Arg2) /* Follows from second argument BUT another format and first day in the month AFTER */ %mend MyDemonstrationMacro /*Example: This is more concretly the rules and values that I would like to extract. */ %macro MyDemonstrationMacro(202106, 202110) %let FirstDate = 202106 /* Same as first argument */ %let SecondDate = 202110 /* Same as second argument */ %let Third_Date = "01jun2021"d /* Follows from first argument BUT another format and first day in the month */ %let Fourth_Date = "01nov2021"d /* Follows from second argument BUT another format and first day in the month AFTER */ %mend MyDemonstrationMacro Any advice on how I could achieve this functionality, i.e. getting the Third_Date and Fourth_Date with the input that I provide? This is obviosuly possible since it follows a logical rule.  ... View more

I am writing a macro of the form:  %macro MacroCompareTables(base, compare, formatshort); %if &formatshort NE 0 or &formatshort NE 1 %then %do; %put ERROR: formathsort should be 1 (for short version) or 0 (for long version).; %end; /* Here I would like to do validation on the tables base and compare provided. For example if no libname assigned then it should be from work. If the tables not found in work, I would like to tell the user that no such table available in the work. Any suggestion on good things to do here?*/ %if &formatshort = 1 %then %do; proc compare briefsummary warning base=&basem compare=&comparem; run; %end; %if &formatshort = 0 %then %do; proc compare base=&basem compare=&comparem; run; %end; %mend MacroCompareTables; Normally, I try to "control" (validate) for all possible misstakes i can come up with. One possible error in this macro is that the tables are not in the work library, any advice on how I could validate for this?  ... View more

I have a SAS data set, let's call it MyDataTable, of the following schematic form (it has like 10 millions rows so all months for the last 20 years are covered):  Observation  Period  1 201101 2 201102 3 201103 4 201104 5 201105 6 201106 7 201107 8 201108 9 201109 10 201110 11 201111 12 201112   The Period column has the format: $6.   Now, I would dynamically like to extract some observations each month in a table called MyDesiredData. So for example:  Assuming now we stand in year 2011:  In january I would like to extract observation 1 with period 201101 In februari I would like to extract observation 2 with period 201102 . .  .    My try was something like:  data MyDesiredData; set MyDataTable(where=(period=put(today(),yymn6.))); run; Any suggestions?  ... View more

So far I have used %include statements for my macros, so I wanted to experiment with Autocall libraries since this seems to be better.  I have read the documentation but I still cannot figure out how to do it...  What I have done:  filename MacLib "MyDir"; /* Directory containing the macros */ options mautosource sasautos=MacLib; When trying to run my macro (lets say it is called MyMacro) it does not work? The log says:  WARNING: Apparent invocation of macro MyMacro not resolved. Why? Specific examples on how to set up autocall libraries would be appreciated.  ... View more

I have written some general purpose macros that often are used in my organization (around 10 people).  What we do now is to include the macros by an %include statement (which I have understood is "not the way to do it"). What I would like to do is to make those 10 macros be available to everyone in the organization (around 10 people) as soon as they open up SAS Enterprise Guide. Is this possible to achieve?  ... View more