@AlanC wrote: Old to new:   Sas Windows (DMS) EG SAS Studio   Best to worst (balance of technical vs functionality):   EG SAS Studio DMS   Preferred by seasoned SAS users:   DMS EG SAS Studio   Pick your platform. If I had my druthers, I would use EG. Best mix, powerful, sharp developers, etc. SAS Studio looks really good but early loaf in oven. Try it out and watch the progress. Long-term? Probably the winner but could be a bit out. DMS is like ISPF. Takes some getting used to so I wouldn't try unless you are a seasoned SAS pro. It is not better, just an old security blanket a lot of us like.   My opinion, YMMV. Don't forget the BATCH that ran before any of the interfaces and than many organizations use for many tasks still. That is still the heart of the beast. ... View more

What type of 'notes' are you looking for? That is a broad request, and could mean training materials, or documentation, or usage and problem notes, etc.  ... View more

If you have background in System Administration or any other BI platform administration I would suggest start with the SAS 9.4 or Viya Admin guide. Its a good place to understand the basic architecture and different components that are required to administer a SAS Platform. Then you can add on with respective admin guide for the products installed at your site. As advised by other you can also enroll in the various training programs that SAS offers. ... View more

The SAS Install Centre is a good place to start reading when developing your understanding of SAS architecture: https://support.sas.com/en/documentation/install-center/94.html  ... View more

Well, SAS is SAS and Python is Python - and the libname statement is SAS and not Python.  ...but the two can talk with each other. https://support.sas.com/en/software/saspy.html https://blogs.sas.com/content/sasdummy/2017/04/08/python-to-sas-saspy/  ... View more

@SRINIVAS_N ,   Yes, you can install SAS on your local machine or connect to the remote server. Please see the configuration step here: https://sassoftware.github.io/saspy/install.html ... View more

My understanding is that `file print;` directs the output to a print file not the log. Removing that statement means the output would go to the log, not the file. But perhaps I don't understand your issue.   EDIT:   You need to also remove your %abort statement, it ends your process so you never reach the data _null_ step.  This mostly works, I think your timing is off, but you can play around to adjust that to your needs.   %macro checkds(dsn, time_to_check_in_sec=30, check_interval_in_sec=10); %*set start time to track looping time; %local startdttm; %let startdttm=%sysfunc(datetime()); %*loop control start; %do %while(%sysfunc(sum(%sysfunc(datetime()), -&startdttm))<&time_to_check_in_sec); *check if data set exists; %if %sysfunc(exist(&dsn)) %then %do; proc print data=&dsn; run; %goto done; %end; %put &=startdttm; %* not sure this works the way you think it does; data _null_; call sleep(&check_interval_in_sec, 1); stop; run; %end; *outputs the error message if data set does not exist; data _null_; put "ERROR: Data set &dsn. does not exist"; run; %*exit for loop when data is found. Could also just be logic from %else condition; %done: ; %mend checkds; *check macro execution; %checkds(sashelp.class); %checkds(sashelp.class_not_exist); ... View more

Is this close enough to being dynamic?   set dsn_20: ;   It takes all data set names that begin with "dsn_20" ... View more

Instead of several macro call you can change your %apps() macro code to loop through years if that possible. If not find the below code that might work.   %macro loop_years(yyyymm=); %do i=%substr(&yyyymm,1,4) %to %sysfunc(year(%sysfunc(today()))); %do j=%sysfunc(ifc(&i=%substr(&yyyymm,1,4),%substr(&yyyymm,5,2),01)) %to %sysfunc(ifc(&i=%sysfunc(year(%sysfunc(today()))),%sysfunc(month(%sysfunc(today()))),12)); %let month_j=%sysfunc(putn(&j,z2.)); %apps(&i&month_j); %end; %end; %mend loop_years; %loop_years(yyyymm=201305); ... View more

What loop?  Please show the code that implements the loop. ... View more

@SRINIVAS_N wrote: Intially all the tables are in external Using libname tables are stored in local location.if dataset are existed no problem,if dataset are not there then it has search for dataset for 15mins From where do you know the dataset names you are looking for? Do you have them in a dataset, or in an external file, or are they fixed and can be hardcoded into the program? Or do you want to do something with any dataset that exists in the library, regardless of its name? ... View more

42 maybe consider having 6 pints of beer and 4 packets of peanuts to provide the needed muscle relaxation and protein reserves you'll need for hyperspace travel the certification exam.     In all seriousness get logged onto your system and click around. Pay a bit of attention to things inside the SAS Environment Manager, perhaps read the documentation of this part of the system. I sat the PA certification a few years ago so it wasn't in the version I did but I'm told by people who've sat it recently that quite a few of the questions refer to things in the SAS Environment Manager. ... View more

Hi,  Really need more details of what you are attempting to do, as it is still unclear. From this post it looks like you might be attempting to pass a parameter/argument from Unix into a SAS program You can do this by using the SYSPARM invocation option, which the SAS program can then read via the SYSPARM macro variable, further details can be found here ... View more

IMO, the macro approach is not so bad. But I would do it differently: %macro Year_data(year); data data_&year; set one; where year=&year; %if &year=%sysfunc(date(),year4.) %then format date date9.; %else format date mmddyy10.; ; run; %mend; proc sql noprint; select distinct cats('%year_data(',year,')') into :macrocall separated by ';' from one; quit; &macrocall; ... View more

You can either set up a Control-M agent on your SAS server, or follow the advice found on google for "Control-M agentless host". Most important: get cooperation from your datacenter people who run Control-M. ... View more