topic Re: Regarding Datafiles restore in SAS Programming

Regarding Datafiles restore

rajenr — Thu, 25 May 2017 12:32:12 GMT

Hi Friends,

I Would like to know that the sas SAS7BDAT File (.sas7bdat) can be restored to the previous version or the date by using sas programmings.

If yes please proivde sas codings for the same.

Re: Regarding Datafiles restore

Kurt_Bremser — Thu, 25 May 2017 12:49:18 GMT

Unless you added generations to the dataset, you have no way to recreate an earlier version of a SAS dataset by SAS means, short of re-running the code that produced the dataset in the first place. When SAS rewrites a dataset, the previous version of the dataset is deleted.

So your best bet is a multi-generation backup from which you can restore the wanted version.

Re: Regarding Datafiles restore

RW9 — Thu, 25 May 2017 12:55:54 GMT

I would suggest if your at the stage where your trying to restore something from old version in anything other than toal fail, then your to late in the process. Look at it earlier on, have a central data area, where users copy data out to working areas. I.e. prevent the need to rollback before it happens. Ok, it wont cover all eventualities, but should minimize them.

Re: Regarding Datafiles restore

Reeza — Thu, 25 May 2017 14:22:50 GMT

If you have a system type backup, ie Windows backup you may be able to restore previous version by using PowerShell commands that you can execute within SAS.

Re: Regarding Datafiles restore

rajenr — Fri, 26 May 2017 06:13:56 GMT

Hi Reeza,

Thanks for your kind reply. Please provide codings for the same.

Thanks..

Re: Regarding Datafiles restore

Kurt_Bremser — Fri, 26 May 2017 06:25:47 GMT

@rajenr wrote:

Hi Reeza,

Thanks for your kind reply. Please provide codings for the same.

Thanks..

How you do the restore depends on the backup you have set up, so that is completely up to you. Remember that this will be a Windows task, while this forum here deals with SAS.

Re: Regarding Datafiles restore

rajenr — Fri, 26 May 2017 06:31:35 GMT

Hi,

I would like to restore the dataset based on the windows backup(like previous day). Request you to provide codings for the same.

Thanks...

Re: Regarding Datafiles restore

Kurt_Bremser — Fri, 26 May 2017 06:37:22 GMT

https://support.microsoft.com/en-us/help/17127/windows-back-up-restore

Re: Regarding Datafiles restore

rajenr — Fri, 26 May 2017 06:47:40 GMT

Hi KurtBremser,

Thanks for your advise. I would like to restore the datasets using SAS programmings. As suggested by Reeza it can be possible by using PowerShell commands in SAS. Kindly help on this..

Thanks

Re: Regarding Datafiles restore

Kurt_Bremser — Fri, 26 May 2017 07:08:24 GMT

Powershell is Windows programming. You need to solve that part first, before you have something that you can call from SAS with call system, X or filename pipe.

So I recommend to solve the restore from a commandline, and once that works, write the corresponding system call in SAS.

There is no generic SAS interface to operating system backup/restore commands (like the SAS file functions that allow you to deal with files without knowing the OS commands).

Re: Regarding Datafiles restore

rajenr — Fri, 26 May 2017 07:30:50 GMT

Hi,

Thank you so much..

Opening an excel using SAS

rajenr — Wed, 31 May 2017 13:43:31 GMT

Hi Friends,

I tried with the below code for open an excel. But it does it provides any output. I could see the log window without error. Please check and help on this. Here with i have attached screenshot of log Window.

%MACRO Sleep(pSeconds);

DATA _NULL_;

vVar1=SLEEP(&pSeconds);

RUN;

%MEND;

/* Macro to open Excel */

%MACRO Open_Xls();

OPTIONS NOXWAIT NOXSYNC MISSING='';

X "C:\Program Files\Microsoft Office\Office14\excel.exe";

%sleep(2);

%MEND;

Note: Excel path is correct.

Re: Opening an excel using SAS

rajenr — Wed, 31 May 2017 13:47:14 GMT

Hi team,

I have checked with the below path also. But it does not open an excel file.

%MACRO Open_Xls();

OPTIONS NOXWAIT NOXSYNC MISSING='';

X "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE";

%sleep(2);

%MEND;

%MACRO Sleep(pSeconds);

DATA _NULL_;

vVar1=SLEEP(&pSeconds);

RUN;

%MEND;

/* Macro to open Excel */

%MACRO Open_Xls();

OPTIONS NOXWAIT NOXSYNC MISSING='';

X "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE";

%sleep(2);

%MEND;

Re: Opening an excel using SAS

Kurt_Bremser — Wed, 31 May 2017 13:52:58 GMT

The problem with the X statement in SAS is that it does not deliver anything back from the commandline.

You can try this to capture OS responses:

filename oscmd pipe "your command 2>&1";

data _null_;
infile oscmd;
input;
put _infile_;
run;

the 2>&1 reroutes error output to standard output; all responses will now end up in your SAS log.

As it is, your code would just open an instance of Excel on the PC without doing anything further; is this what you intend to do?

Re: Opening an excel using SAS

RW9 — Wed, 31 May 2017 14:21:58 GMT

What is it your trying to do? Why do you need to open Excel?

Re: Opening an excel using SAS

Reeza — Thu, 01 Jun 2017 03:19:11 GMT

What are you trying to do? Opening an Excel with the code you've shown will do exactly that, open Excel which is pretty useless.

Also, you have macro's shown but you're not actually calling them. Consider a macro similar (but not the same) as a function in another language. You've created the function but you haven't used it. You also may have an 'order of operations' issue. You define the SLEEP macro after it's used in the OPEN_XLS macro.

Do note that DDE requires the XCMD option to be enabled and usually doesn't work on server environments because they're Unix not Windows and those are Windows commands. Also, it's ancient. That doesn't mean it's not useful, just that it's ancient, finicky and I wouldn't build anything with this today.

%MACRO Sleep(pSeconds); 
   DATA _NULL_; 
     vVar1=SLEEP(&pSeconds); 
   RUN; 
%MEND; 

%MACRO Open_Xls();
   OPTIONS NOXWAIT NOXSYNC MISSING='';
    X "C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE";
    %sleep(2);
%MEND;


%open_xls;

Re: Opening an excel using SAS

rajenr — Thu, 01 Jun 2017 12:24:47 GMT

@Reeza,

Actually my concern is need to restore datasets using sas program. I tried for for t he same. As suggested by you and @Kurt_Bremser, i tried to restore the datasets using commands in command prompt. But i didn't get the commands for the same. While searching regarding this i could see some VB codings for restore the SQL database files.

So i planned to use those commands in Excel. But while running the SAS program the excel macro also need to run. If i can open the excel file then i will able to run the macro easily. So only i tried to open the file using the given commands. But i couldn't. Here i have some concerns, same are listed below.

1. Need to restore the datasets using SAS program.

2. If it is possible ways to do that and coding for the same.

Please help on this...

Re: Opening an excel using SAS

RW9 — Thu, 01 Jun 2017 12:31:46 GMT

You seem to be going round in circles. Start by defining - where did the data come from originally? If you have the source files then re-import the data, if you don't have the source data, and you have removed the files, then you need ot go back to your IT and see if they have an automatic back up. It hard to say as we have no information on your process other than your trying to restore something. You need to provide all the infomation around the problem so we can know as well.

Re: Opening an excel using SAS

Kurt_Bremser — Thu, 01 Jun 2017 12:49:36 GMT

As already stated, you absolutely need to solve the "restore from commandline" issue first. If you can't do it from there, you can't do it, period. Involving another silly mechanism like Excel just to run a VB script borders on the insane.

How to run VB scripts from the commandline:

https://technet.microsoft.com/en-us/library/ee156587.aspx

(BTW, this is the first result of a google search for "run vb script from the commandline".

The same search also reveals lots of usable hints for the task)