About KevinC_

KevinC_ · ‎06-01-2017

Hello, I get the following errors when executing themacro bbb. the errors come from the line colored in red. Any suggestions would be greatly appreciated. thank you in advance. ERROR: Required operator not found in expression: wrd&i. in (&word_list.) ERROR: The macro BBB will stop executing. rsubmit; %macro bbb(i); %if wrd&i. in (&word_list.) %then %do; var&j. = wrd&i.; %let j = %eval(&j. + 1); %end; %mend; endrsubmit; rsubmit; %macro all_rf; data data5; set data4; %let j = 1; %do i = 1 %to 60 ; %bbb(&i.); %end; run; %mend; %all_rf; endrsubmit;

KevinC_ · ‎02-04-2016

Thank you everyone for your input again! I used user24feb's suggestion and it worked for me. Thank you user24feb! :)

KevinC_ · ‎02-04-2016

Thank you all for your help! I tried some of your suggestions and changed my Where statement as below : WHERE (Trans_Type_CD in (&&&tran_cd.)) Where (Trans_Type_CD in (%Sysfunc(TranWrd("&tran_cd.",%Str(, ),%Str(", "))))) The rest of the query remains the same. I got this error: ERROR: All positional parameters must precede keyword parameters Any suggestions? Thank you!

KevinC_ · ‎02-03-2016

Hello Everyone, I am trying to pass a comma delimited macro variable to a macro. I get an error that says " ERROR: More positional parameters found than defined. " Does anyone have any suggestions on how to make this macro work? Thank you very much in advance. %MACRO test(cd); Proc SQL; Create Table AAA as SELECT DISTINCT Customer_ID, amount FROM Cust_Transaction Where (Trans_Type_CD in (&cd.)) ;QUIT; %MEND; %let Trans_cd = 1387-D, 1419-D, 1383-D; %test(&Trans_cd);

KevinC_ · ‎06-29-2015

Thank you dcruik and Cynthia. Cynthia, The sas runs on unix and uses tagsets.excelxp. It's supposed to be an automated process without manual intervention. I went ahead with dcruik's suggestion to change the column format in an earlier dataset. It seems to have worked. Thank you both for your input.

KevinC_ · ‎06-29-2015

Hello Everyone, I am trying to display the datepart of a date column in proc report and format it as mmddyy10.. The column currently has the hour minute second: 30MAR2015:00:00:00 My code looks like this: Proc Report data = infile; define cut_id / format = $10.; define sale_date / format = mmddyyd10.; run; When I run this code the sale_date column looks like this in Excel: ********** How do I have the sale_date column formatted as mmddyy10? Thank you very much for any input you may have!

KevinC_ · ‎04-01-2015

Hello Everyone, I am trying to read an Excel file that has been zipped. The Excel file name is new_file.xlsx. It has been zipped and sits in c:\docs\new_file.zip. How do I read this file without manually unzipping it first? I have tried Proc Import and x command. Here is my attempt using x command: "cd C:\Program Files\7-Zip\"; '7z.exe e -o C:\docs\OUTPUT.xlsx C:\docs\new_file.zip'; When I run this code I don't get any errors. It does not seem to produce any output either. Any suggestions would be greatly appreciated. Thank you!

KevinC_ · ‎03-27-2015

Hello everyone, I am trying to map my data at the CBSA level. I was going to use the sashelp.zipcode dataset. But it doesn't include CBSA data. Is there another SAS dataset that include CBSA? Is there a way to get around this? Thank you for any input you have!

KevinC_ · ‎02-18-2015

Thank you Tom, ballardw, and SASKiwi. Tom, I restarted a new SAS session and now I was able to see more info in the log. The problem was one of the letters in the file name had an incorrect case. It works like a charm now. Thank you everyone!

KevinC_ · ‎02-18-2015

Thanks Tom, I ran your code and it did not display anything from _infile_. There was no errors in the log. In fact, the only thing I see in the log was "Remote submit to XXX commencing" and "Remote submit to xxx complete". Any other suggestions? Just to make myself clear, I run this from PC (Not on Unix). Hence, I call it 'PC SAS'.

KevinC_ · ‎02-18-2015

Hello Everyone, I am trying to remove a permanent SAS dataset stored in a Unix directory from PC SAS. I enclose the code in Rsubmit and Endrsubmit; For testing purpose, I try to remove just one file first. When I run the code it has no errors. But it does not remove the dataset either. Can anyone tell me what I am doing wrong? Thank you very much for any input you may have! rsubmit; %macro remove; x "rm /users/apps/cust_folder/customers1.sas7bdat"; %mend; endrsubmit; rsubmit; %remove; endrsubmit;

KevinC_ · ‎02-11-2015

Thank you guys for your input. Reeza, I added a sleep command and ran the code one line at a time and I got it to work! One major difference I made was that I added a VBA macro (Refresh) to the Excel, and I added a 'RUN' command. I am glad this works. However, if anyone has suggestions on how to tackle this in a different way I would love to hear it. Thank you Reeza, RW9 again! Here is the code that worked : options noxwait noxsync; data _null_; rc=system('start excel'); run; filename cmds dde 'excel|system'; data _null_; file cmds; put "[open(""\\&path\&f_name..xlsm"")]"; PUT '[RUN("Refresh")]'; put "[save()]"; put "[quit()]"; run;

KevinC_ · ‎02-11-2015

Hi Reeza, oops, yes, the first dataset got cut off. Here it is: data _null_; path = trim("C:\My_Doc"); f_name = "Customer1"; Call SYMPUTX('path', path, 'G'); Call SYMPUTX('f_name', f_name, 'G'); run; Btw, the sheet that contains the pivot is named "Pivot1". I hope I referenced it properly. Thanks!

KevinC_ · ‎02-10-2015

Hello Everyone, I am trying to refresh an Excel Pivot from SAS. I get this error : Physical file does not exist, excel | system. The code opens Excel but it just sits there. Any input would be greatly appreciated! Here is my SAS code: data _null_; "C:\My_Doc"); "Customer1"; Call SYMPUTX('path', path, 'G'); Call SYMPUTX('f_name', f_name, 'G'); run; options noxwait noxsync; data _null_; rc=system('start excel'); run; filename cmds dde 'excel|system'; data _null_; file cmds; put "[open(""\\&path\&f_name..xlsm"")]"; put '[workbook.activate("Pivot1")]'; put '[select("R3C1")]'; put '[pivot.refresh()]'; put "[save()]"; put "[quit()]"; run; quit;

KevinC_ · ‎01-13-2015

Hello Everyone, I am looking at a code and trying to understand how the macro gets triggered. Program A has a %include that references program B. Program B has 3 macros in it. Nowhere in Program A or Program B do I see those 3 macros being referenced with %macro_name. Based on what I understand, a macro gets executed when you use %macro_name to trigger it. I don't see the 3 macro names referenced in any program. How does the code trigger the 3 macros in this case? Please let me know if I am not clear. Thank you!

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

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

X command in PC SAS

Re: Refresh Excel Pivot from SAS ??

Re: Refresh Excel Pivot from SAS ??

Refresh Excel Pivot from SAS ??

Can you trigger a macro by using a %include ??