About PhilfromGermany

PhilfromGermany · ‎09-29-2014

Arthur, thanks for suggesting your macro. Will this macro run as part of an automated batch on Windows Server 2008? Or does it really require interactive mode?

PhilfromGermany · ‎09-26-2014

What I am trying to accomplish: I have SAS data and I want to dump that data into an existing macro-enabled excel workbook. I then want to run an Excel Macro which assigns the dumped data records to various cells across multiple work sheets within the workbook. The reason I want to use DDE is because: - I can export SAS data into an existing workbook into a blank sheet - I can issue the run macro command - I can issue a Save as... command. I know that DDE uses Excel 4.0 functions, which are compatible with newer versions of Excel, such as Microsoft Excel 2010. If you know of better alternatives, let me know. Please keep in mind that our platform administrator does not approve of running executables or Perl scripts or python scripts, etc. X commands and signed excel macros are as good as it gets. Jaap, can you provide me with a list of these commands?

PhilfromGermany · ‎09-26-2014

Hi Reeza, thanks for the response. I should have searched for DDE commands, instead of X4ML 🙂 I installed the macrofun.exe and when trying to open the help file, I get the following error: ------------------- Why can't I get Help from this program? The Help for this program was created in Windows Help format, which depends on a feature that isn't included in this version of Windows. However, you can download a program that will allow you to view Help created in the Windows Help format. For more information, go to the Microsoft Help and Support website. ------------------- I'm using MS Excel 2010. Regards Phil

PhilfromGermany · ‎09-25-2014

Hello everyone, I am looking for a list of DDE commands for Microsoft Excel. I searched the Microsoft Download Center and couldn't find anything. I also searched through the forum and only found two posts, of which none mentioned a source or a list of all X4ML commands. Thanks in advance! Phil

PhilfromGermany · ‎09-25-2014

Data_null_, you solution works, so I just went with that. Thanks for everyone's input!

PhilfromGermany · ‎09-22-2014

Ok, so the reason why the output file looked weird was because the record length was too short. I have one very long variable ($800.) so I had to set the record length to 800 as well. Data _null_, would you argue that Arthur's modifications are not necessary? I ran your code and it works well. Also, no blank lines, just the one that Notepad creates automatically when opening the file. I still don't fully understand the code (vnext, link names, ...), which is on of the reasons I always revert back to simple procedures like proc export or just using ODS CVS, but I'm going to try to research these statements and figure out why they are being used. Thanks for everyone's input. Regards Phil

PhilfromGermany · ‎09-22-2014

Hi Arthur, is there a way to use a text qualifier for some columns, using your code? My output didn't look right, using it exactly like that. Also, when using put (_all_) what is the purpose of using (:)? @RW9, you're probably right. Still, I gotta figure out a way to eliminate at least that second blank line.

PhilfromGermany · ‎09-22-2014

@Jaap, when opening the file in Notepad, there is a blank line after the last line of output. When using CSVALL, there are two blank lines. Proc export and data steps using a filename statement produce only one line. One line is better than two lines. No line is better than one line. If having one line is a "Windows thing" then I guess there is no way around it and I'm just going to have to deal with it. Regards Phil

PhilfromGermany · ‎09-22-2014

@data_null_ Could you possibly comment the code (starting from line 4)? Thanks!

PhilfromGermany · ‎09-22-2014

Hi, I am using ods csvall to export a SAS data set to csv. The problem is, at the end of the file SAS (or Windows) inserts a blank row. I think this row is just the result of Windows adding DOS carriage control characters (CR and LF). Is there anyway to prevent this from happening? My code: ods csvall file = "&csv_path.\MyFile.csv" encoding=utf8 options(delimiter=';'); proc print data=work.output noobs; run; ods csv close; I've tried this using proc export or a simple data step with a filename statement, but I get the same result 😞 Thanks!

PhilfromGermany · ‎08-12-2014

Hello, is there an option that allows me to remove the quotation marks that all values (characters AND integers) are enclosed in when exporting to ODS CSVALL via proc print? I've looked everywhere and all I found were programs that users can run after the file has already been created. These programs remove the quotation marks. However, I'd prefer an option. Thanks! Phil

PhilfromGermany · ‎08-07-2014

Wouldn't that cause the same problem, since the data step needs to compile completely before the macro can be referenced?

PhilfromGermany · ‎08-07-2014

Thank you for your response, Astounding. My goal was to do it all in one data step, but after all this is an easy solution and it works. Thanks!

PhilfromGermany · ‎08-06-2014

Hello, I would like just as many array variables in the ouput dataset as there are loops. If the loop only runs three times and creates x1, x2, and x3, I would like to just keep those three variables and not all five. Using a macro that is being created within the same data step does not work and I'm pretty sure I know why. Any suggestions? Thanks! data dummy; checker=3; array x[5] $100.; do i = 1 to 10 while (checker > 0); x = 1 + 2; checker = checker - 1; end; call symputx("i",i); keep x1 - x&i; run; Not sure if this code actually runs. I just recreated something similar to my problem. Regards Phil

PhilfromGermany · ‎10-01-2013

Hello, I have the following data set: ID Status Timestamp 1122 idle 10MAY2013 1122 active 15MAY2013 1122 idle 25MAY2013 1122 closed 01JUN2013 Every time the status of an ID changes, a new record for that ID is being created and a timestamp of when the change occured is added to the record. That is how old statuses get historicized, as can be seen in the table. I would like to add a column that measures how long a certain status has been assigned to an ID. The outcome would look like this: ID Status Timestamp Duration in days 1122 idle 10MAY2013 5 1122 active 15MAY2013 10 1122 idle 25MAY2013 7 1122 closed 01JUN2013 ... The last value (the cell that contains "...") would be created through additional logic, like if last.id then duration=today()-timestamp or something like that. Your help is much appreciated!

Online Status	Offline
Date Last Visited	‎07-29-2016 03:17 AM

VA: Values on y-axis disappearing

Re: Shorten long string, but ensure it remains unique

Re: Shorten long string, but ensure it remains unique

Re: Scheduling recommendation

Shorten long string, but ensure it remains unique

Scheduling recommendation

Monitoring user activity

Re: SAS/ACCESS to Oracle slow queries

Re: SAS/ACCESS to Oracle slow queries

SAS/ACCESS to Oracle slow queries

VA: Values on y-axis disappearing

Re: X4ML commands for DDE with MS Excel

Re: X4ML commands for DDE with MS Excel

Re: X4ML commands for DDE with MS Excel

X4ML commands for DDE with MS Excel

Re: DOS Carriage Return and Line Feed in CSV files

Re: DOS Carriage Return and Line Feed in CSV files

Re: DOS Carriage Return and Line Feed in CSV files

Re: DOS Carriage Return and Line Feed in CSV files

Re: DOS Carriage Return and Line Feed in CSV files

DOS Carriage Return and Line Feed in CSV files

ODS CSVALL - values in quotation marks

Re: Using i counter of loop in keep statement

Re: Using i counter of loop in keep statement

Using i counter of loop in keep statement

How to calculate the difference between two timestamps of different ob...