Yes there is. If you connect with R to SAS R has its own dataset reader interface what draws through the deleted records too and you can undelete them in R. Another possible option what I have not tried for 25 years - so maybe it does not work anymore - is dBase. As far I remember, dBase export from SAS contained the deleted records too, and you could set them back to undeleted in dBase. There still exists dBase somewhere out there but I did not try it with this version. ... View more

Yes. i was planning a asking a similiar question. I think it's because of the size of my dataset(s); which is why i remove datasets that i no longer need. I found info about managing memory at http://support.sas.com/documentation but I do not know where/how i can change modify options i do not have permission to modify my config file. Managing Memory Specify a Value for MEMLEAVE= When You Invoke SAS Use SYSLEAVE= and PROCLEAVE= to Handle Out-of-Memory Conditions ... View more

As Jaap says, firewall rules are a possble cause of your problem as it is common practice these days to have firewalls around servers. In our SAS environment we have had to change the default firewall timeout to at least 8 hours. ... View more

If you have a library called WORKSPDE for example, to keep from getting the lock error, I did this as an option with filelocks. options filelocks=("%sysfunc(pathname(WORKSPDE))" NONE); ... View more

Hi, You can pass this way..try this... First stored process creating links and passing parameters: proc report data=want nowd ; column  age    ; define age/left; compute age; length nexturl $500; nexturl = "&_URL?_program=/Users/sasdemo/My+Folder/KPPOC/agefiltercode" ||          '&age=' || urlencode(trim(left(age))) ; call define(_col_,"URL",nexturl); endcomp; run; write you filtering code in second SP:(stored process name : agefiltercode) Thanks, Shiva ... View more

Buttons and Textboxes are parts of FORM elements, which either use a POST or GET method, which means they always communicate back to the web server. So the only option you have is to use the GET method to start another run of the STP with different parameters. Once you see a web page created by the STP, the STP has already finished. ... View more

The border colors I want to apply for HTML. But the style property bordercolor is not applying to the HTML. Though it is fine for PDF. Can you help me for HTML? What do you mean to say by "split your table". Like two tables with two different proc report and ODS TEXT in between. ... View more

your original data might be dynamic. it might be updating very frequently. are you getting data from RDBMS? or SAS data mart. There are little chances that your SAS data mart also refreshes very frequently. First confirm where you are getting data? ... View more

Proc compare compares each column from table 1 to table 2 in a row. For example if there is a rundate in table1 and rundate in table2 need not be same even you started to run the code same time to get table1 and table2. For comparing two tables I am sure this is going to be usefulcode. /* first outer join table1 and table2*/ Proc SQL; Create table table1andtable2outerjoin as Select a.id as id_1, a.name as name_1, b.id as id_2, b.name as name_2 From table1 as a   Full Outer Join   table2 as b   on a.id = b.id and      a.name=b.name;   Quit; /*to see rows only in table2 not in table1 you can add more columns for comparison*/   Data tablenew;   Source = 'two';   Length Source $5;   Set table1andtable2outerjoin ;   if missing(id_1) and missing(name_1) then output;   Format Source $5.;   Informat Source $5.;        run; /*to see rows only in table1not in table2 you can add more columns for comparison*/ Data tableold; Source = 'one';   Length Source $5;   Set table1andtable2outerjoin;   if missing(id_2) and missing(name_2)  then output;     Format Source $5.;   Informat Source $5.;   run; /*to see rows side by side*/   Data tablenewold;   Set tablenew tableold;   run; ... View more