Search results for query: *

Is there a way to replace multiple missing values in a column with the previous non-misisng value? Here is what a sample dataset would look like: data have; input ProjectID $ Action $ UserID $; datalines; Project1 Started User1 Project1 Update1 User1 Project1 Update2 ...

I've got a situation where I need to try to replace specific combinations of characters in a field with another character. Here is as an example of what the starting field would have in it: data data_tbl; ProcessFlow = 'AbBcCa'; run; I've been given a conversion table with that coverts a...

Is there a way to write a where statement to look at only certain positions in the text of a field? Maybe a example would be best. Something like this works: data want; set have; where (phone = '5555555555' or substr(phone,4,3) = '555'); run; The results are phone numbers that are all 5's...

Is there a way to rename a hyperlink in a SAS generated email? For example I can run: filename outbox email subject="Report website" to="someone@email.com" type='text/html'; data _null_; file outbox; put ' '; put "Here is the link to the reports website."; put ' '; put...

Is there a way to have SAS move or copy/paste an Excel file from one location to another? For example, if I have a file at c:\temp\excel.xls and want to move it to g:\commonfolder\excel.xls. Would I have to use VB for this? thanks, Dave

I have a several SAS programs that create a dataset then then export the data into Excel. Today, after months of no problems, SAS won't export (or import) in Excel97-2002 format. Exporting and importing in Text, CSV, and Excel 5 work fine. Just not Excel97-2002. Anyone else run into an issue...