About KevinC_

KevinC_ · ‎02-08-2013

Thank you everyone for the helpful information! I decided to use the Call Sleep function and it worked beautifully. Thank you again for all your input

KevinC_ · ‎02-07-2013

Thank you DBailey. I changed the code to sleep(60*60*10) and it started right away too. Isn't that 10 minutes? Thanks.

KevinC_ · ‎02-07-2013

Hello Everyone, I would like to delay the start of the execution of a sas program by 10 minutes. I added this data _null_ step at the beginning of my sas code. But the program starts right away. How do I delay the execution of a program by a specified amont of time? data _null_; sletp = sleep(60*10); run; data aaa; ......... rest of the sas program. I appreciate any input you may have!

KevinC_ · ‎01-02-2013

Hello Everyone, I am trying to create a column label as a 3-letter month followed by 2-digit year (i.e. Dec-12). I currently use this code: label new_month = "%sysfunc(today(),monname3.)-%sysfunc(today(),year2.)"; The code works as long as I use today(). But I would like to use the 'process_date'(a time stamp date) instead of today(). I have started by trying out the month portion first. And it does not seem to work: label new_month = '"%synfunc(datepart(process_date),monname3.)"; Instead of creating the label 'Dec-12' it is displaying '%synfunc(datepart(process_date),monname3.)' as the label. I get a warning "Apparent invocation of macro SYNFUNC not resolved". Does anyone have any suggestions on how I can make the label to show 'Dec-12' using a timestamp date ? Thank you very munch

KevinC_ · ‎12-27-2012

Thank you Ksharp for your suggestion. I have modified my code according to your suggestion. The code still sits there without generating any output or errors. I wonder if my Unix environment has been 'setup' to handle proc import. Is there some kind of command(s) I need to run in my Unix folder before using proc import?

KevinC_ · ‎12-26-2012

Thanks for your reply. Since this is an automated process, both approaches (a Unix-reconizable directory or FTP) will need to require no manual intervention. That is the part I am having difficulties with. I can easily FTP the file or run proc import from PC SAS. Is there a way to automatically FTP a file from a windows directory to a UNIX directory - meaning including it as part of the code? Thank you.

KevinC_ · ‎12-26-2012

I have the correct network mapping. I looked up the FTP stuff and don't really know how it applies to my situation. Does Proc Import even work on Unix?

KevinC_ · ‎12-26-2012

Thank you, HaiKuo. I ran your code and received an error stating "the physical file does not exist". It seems to look for the file on the Unix server and can't find it. This is part an automated program so manual upload is not preferred. Any other suggestions? I really appreciate your help!

KevinC_ · ‎12-26-2012

Thank you, Ksharp. Here is a sample of the text file I am trying to import. It is tab delimited. Hence the 'DBMS=TAB replace" in my code. "ID" "Client" "C_Code" "0001298477" "743" "41" "0003876533" "654" "20" Any suggestions? Thanks again.

KevinC_ · ‎12-24-2012

Hello Everyone, I am trying to 'import' a text file from PC to Unix. I have tried using the code below with no success. I wonder if anyone knows a different approach? Proc Import out = DNL database= "c:\My Docs\Denials.txt" DBMS=TAB Replace; Getnames=Yes; Datarow=2; Run; When I submit this code from Unix it just sits there without generating an error code or any output. I always end up killing the job later. Does anyone have any suggestions on how to get data from PC to Unix? This needs to be done within a SAS program, meaning no manual intervention, as this is an automated process. I really appreciate any input!

KevinC_ · ‎12-06-2012

Thank you Robert and Tom for your input! Both of your suggestions make great sense. I will try them out when I get in. Robert, thank you for manually typing the code in here. Your input is greatly appreciated! Thank you both

KevinC_ · ‎12-05-2012

Hello Everyone, I am trying to combine two sas datasets horizontally and i would like the new output file have columns placed in certain order. I use RETAIN to set the order of the columns as shown below. However, the output i get is not what I expected. The column 'new_month' from in_file2 should be placed as the last column. For the sake of simplying the discussion, i have listed the column names. Does anyone have any suggestions on how I can list the columns in the desired order? Thank you very much any any input ! Data new_file; retain _name _step _m: new_month; set in_file1; set in_file2; run; In_file1: _Name _Step _m1 _m2 _m3 .... _m11 In_file2: new_month Output: _Name _Step new_month _m1 _m2 _m3 ... _m11 Desire Output: _Name _Step _m1 _m2 _m3... _m11 new_month

KevinC_ · ‎11-27-2012

Thank you Cynthia! I changed the single quotes to double quotes and it worked! I really appreciate your help!

KevinC_ · ‎11-27-2012

Hello everyone, I am using tagsets.excelxp to push a dataset from Unix to Excel. I am trying to use a macro for the 'sheet_name' within the options as shown below. The macro variable 'year' has the value of 2012 and it works everywhere else. The proc report and the rest of the code works too. The only issue is the sheet name is showing up in the output Excel as "&year" instead of the value it should be (2012). Does anyone have any suggestions on how to use the macro variable on the 'sheet_name'? I really appreciate any input you may have. Thank you ods listing close; ods tagsets.excelxp file = "&work_path.ytd_&year.xls" options(embedded_titles='No' sheet_interval= 'none' sheet_name='&year' gridlines='Yes' wraptex='Off' suppress_bylines = 'yes' ) style=sansprinter; proc report data = ****** ****** ods tagsets.excelxp close;

KevinC_ · ‎10-14-2012

Thank you Tom and Arthur! Both of your codes worked beautifully!! Thank you so much for your help. I really appreciate it !!! Tom, Your code always seems so slick and simple. Your input is always greatly appreciated ! Kevin

Online Status	Offline
Date Last Visited	‎06-01-2017 04:12 PM

Macro Error Question

Re: Passing a comma delimited variable to a Macro

Re: Passing a comma delimited variable to a Macro

Passing a comma delimited variable to a Macro

Re: Proc Report Date Format

Proc Report Date Format

Read a zipped Excel file ??

MAP data at the CBSA level ??

Re: X command in PC SAS

Re: X command in PC SAS

Import a password protected Excel doc

Re: Import a password protected Excel doc

Re: Sleep Question

Re: Sleep Question

Sleep Question

%sysfunc Question

Re: Import Files from PC to Unix

Re: Import Files from PC to Unix

Re: Import Files from PC to Unix

Re: Import Files from PC to Unix

Re: Import Files from PC to Unix

Import Files from PC to Unix

Re: Retain Question

Retain Question

Re: Tagsets.excelxp Question

Tagsets.excelxp Question

Re: Proc Format Help! (_Label_)