Yes, bur first off, please avoid shouting code at us, and finish macro variables with a dot, use the code window, and indentations!! data _null_; a=put(intnx('year',today(),-1),year4.); b=put(intnx('year',today(),0),year4.); call symput("A",a); call symput("B",b); call symput("C",catx('/',a,b)); run; %put A=&a.; %put B=&b.; %put C=&c.; The next question is, why put the today() result in a macro variable at all, or in fact the other two data items?  Each of these elements can simply be found by querying the today() function at the appropriate moment?   ... View more

Set line color to white in style(header) for those you do not want to see: http://support.sas.com/resources/papers/stylesinprocs.pdf ... View more

First I would suggest fixing the replace column, it will just make your code longer if you have it all in one.  Have two columns: FIND     REPLACE low        high   Will make things easier. Second, should it replace all occurrences, what about casing?  What about low in a word, e.g. below? Tranwrd is probably the simplest method, e.g: want=tranwrd(have," low "," high "); I put spaces in so as to get only th word, not be"low" for instance. ... View more

Its very hard to suggest anything else without any knowledge of the whole process.  I see it like (select * from DDS_SRG2.my_table) to download data and then... U may do anything with it. But first - download thim. -- I have no idea what you are talking about.  SAS datasets are not an SQL database, they are files stored on a network drive or locally. Datasets are just files And where're they stored? If i know socket (host ort) and logical dislocation (DDS_SRG2/my_table) how to get file? Even without any SQL.  -- Sorry, what does any of that mean?  SAS datasets are stored on a network drive or locally.  Depends on your setup of which you have told us nothing.  Speak to your SAS people and they should be able to tell you where the data is stored. Don't know this sqoop, perhaps try asking on its forums how to import files? There's no issue to make import. Issue to take data in SAS from outside. -- SAS datasets are just files.  You can use the SAS system to export the data to multiple file types.  It depends what you need.   SAS provides an interface to Hadoop: https://www.sas.com/en_be/software/access-interface-hadoop.html What is it? It's an app or what? Need download and install? I havn't such premissions at my work station. --  Its an additional component of the SAS system.  If you do not know that, then your first point of call should be with the SAS people at your company, they will be able to show you the system, and how to get data in/out. ... View more

SAS provides an interface to Hadoop: https://www.sas.com/en_be/software/access-interface-hadoop.html   Its very hard to suggest anything else without any knowledge of the whole process.  Datasets are just files, so if you know the file structure you could extract data, or convert to CSV and add that way, there are loads of options.  Don't know this sqoop, perhaps try asking on its forums how to import files? ... View more

Just choose one or the other.  If you have to use Excel, then create a template in Excel, create VBA macros to load the data into your template from CSV files.  Then all your SAS has to do is drop out the data to CSV.  Alternatively use SAS for all of it, produce a report with the various items, excluding Excel functionality.  There really is no benefit to try to drive software x from software y.   ... View more

Switch to GTL, you can get the GTL code from what you have by putting: Proc Sgplot data=abc nowall noborder tmplout="c:/text.txt"; In the file c:/text.txt you will find the gtl code which is generated.  Then you add a layout gridded step to that, and add in your other graphs: https://blogs.sas.com/content/?s=gridded   You may also be able to do it with sgpanel: http://support.sas.com/documentation/cdl/en/grstatproc/62603/HTML/default/viewer.htm#sgpanel-stmt.htm   This is the best reference for GTL and sgplot: http://blogs.sas.com/content/graphicallyspeaking/ ... View more

When SAS exports data it does not call Excel functionality like refresh rest of workspace.  Add a simple OnLoad VBA macro to your Excel file so that when it loads it refreshes the workspace: https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.refreshall     ... View more

Sideways to your question, you would save yourself - A lot of coding and maintenance - A lot of processor and storage space Simply by changing your approach to your problem.  I can tell this as soon as I see coding like: data &reg.&i.; and Surp_B_&reg.&i.  This shows that your are creating lots of datasets for the same data and that in those datasets you are creating lots of variables.  Both of these show a badly worked out data modelling structure. Without seeing the data/process in full my suggested change would be to create a record (observation) for each of the data items like: PARAM               RESULT... SURP_B_US_1  .... SURP_B_US_2  ... Then instead of creating a new dataset (i.e. read/writes for each group) use a by group to do the calculations in one simple datastep/means output by your by groups and params, to get one complete results dataset out.  This would give you 1 dataset in, 1 dataset out (1*read/write) and very simple Base SAS which is easy to code and maintain.  The only reason for transposed data is for output purposes and this can be achieved by a proc transpose before proc report. ... View more