About RedMcCallen

RedMcCallen · ‎10-20-2017

Yup... I see that now. I was just unaware that the BY statement would do that to the IN function. It's these types of things that makes me like SAS so much. It's just the macros that drive me crazy. From years of programming statistical software in a language, macro programming is just something that I can't fit my mind to because it just seem so over-complicated and lacking in functioning well with base code.

RedMcCallen · ‎10-20-2017

Ok... I executed this code and I see what it does now. Thank you. I did not realize the BY statement would treat it as separate instances for each element inside the IN function. I like this better because it keeps the code simple and efficient, which is always what I am looking for over elegance and showing off as a number of programmers like to do. I think I still have the problem -a minor one- which is that I wanted the title of each of the eight offices to show up after the Country of Birth title. Not sure I can get that here, but that is a minor issue.

RedMcCallen · ‎10-20-2017

The intent of the code is to produce a frequency output for each of the eight offices. I don't want to write eight Proc Freq code blocs for each office,. From the way I read the use of the in function here it is treating it like a single evaluation for any of the eight offices. And if one of the offices evaluates true for the in function, then produce the output.

RedMcCallen · ‎10-20-2017

That throws a whole number of errors.

RedMcCallen · ‎10-20-2017

I have used arrays in evaluation statement before that were inside of loops, and they worked. The following worked: %let topMetros = array topMetros[10] $5 metro1-metro10 ("35620" "31080" "33100" "16980" "41860" "47900" "26420" "19100" "41940" "14460"); %macro count(toomany); %do i = 1 %to &toomany; data geog.uscis_ois_lpr_s5_mtr&i. (drop = metro:); set geog.uscis_ois_lpr_s5_metros; &topMetros; if CBSA_CODE = topMetros[&i.] then output geog.uscis_ois_lpr_s5_mtr&i.; run; %end; %mend count; %count(10);

RedMcCallen · ‎10-20-2017

Hi, All. I am trying to streamline my code to use a single frequency procedure code bloc one inside a loop of 8 iterations. But as always with the macros, it is something that should work, but there is something about the chewed bubblegum, duct-taped, cotton-plugged wiring of the way SAS manages macros that is not working. The following code is based off a similar routine that I wrote that used macro variable in the IF statement -and worked- but does not here. I have tried multiple ways of specifying the values in the array, as well as worked with the ampersands and quotes to no avail. %let officeCodes = array officeCodes[8] $3 code1-code8 (ZAR ZCH ZHN ZLA ZMI ZNK ZNY ZSF); %macro count(toomany); %do i = 1 %to &toomany; proc freq data = risk.rapsPending_s2a (where = (RARCASE_CCO_CODE_2 = "&&officeCodes[&i.]")) order = freq; format RARAPPL_CNTRY_OF_BIRTH_CODE $cntry.; tables RARAPPL_CNTRY_OF_BIRTH_CODE / missing; title "Country of Birth"; run; %end; %mend count; %count(8); I get the following message. From everything I know and looked up, it should work. I really hate the way SAS implements macros…. Seems like they just kept gluing cotton on to duct-tape balls that held loose wiring together given the way this software developed. It’s always the macros. NOTE: No observations were selected from data set RISK.RAPSPENDING_S2A. NOTE: There were 0 observations read from the data set RISK.RAPSPENDING_S2A. WHERE 0 /* an obviously FALSE WHERE clause */ ; NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Ron

RedMcCallen · ‎11-14-2016

Can't believe I missed that! I was focusing on the main bloc. But still, I am an editor and should have caught that. Thanks.

RedMcCallen · ‎11-14-2016

22 GOPTIONS ACCESSIBLE; 23 %let topMetros = array[10] $5 metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' 23 ! '14460'); 24 25 %macro count(toomany); 26 %do i = 1 %to &toomany; 27 data geog.uscis_ois_lpr_s5_mtr&i. (drop = metro:); 28 set geog.uscis_ois_lpr_s5_metros; 29 &topMetros; 30 31 if CBSA_CODE = topMetros[&i.] then 32 output geog.uscis_ois_lpr_s5_mtr&i.; 33 34 run; 35 36 %end; 37 %mend count; 38 %count(10); ERROR: Undeclared array referenced: array. NOTE 138-205: Line generated by the macro variable "TOPMETROS". 38 array[10] $5 metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460') _ 22 ERROR 22-322: Syntax error, expecting one of the following: +, =. NOTE: Line generated by the macro variable "TOPMETROS". 38 array[10] $5 metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460') _ 200 ERROR 200-322: The symbol is not recognized and will be ignored. NOTE: Line generated by the macro variable "TOPMETROS". 38 array[10] $5 metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460') _______ 68 ERROR 68-185: The function METRO10 is unknown, or cannot be accessed. 2 The SAS System 15:19 Monday, November 14, 2016 NOTE: Line generated by the macro variable "TOPMETROS". 38 array[10] $5 metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460') _______ 388 ERROR 388-185: Expecting an arithmetic operator. NOTE: Line generated by the macro variable "TOPMETROS". 38 array[10] $5 metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460') _______ 76 ERROR 76-322: Syntax error, statement will be ignored. ERROR: Undeclared array referenced: topMetros. ERROR: Variable topMetros has not been declared as an array. NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 3537:113 WARNING: The variable 'metro:'n in the DROP, KEEP, or RENAME list has never been referenced. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set GEOG.USCIS_OIS_LPR_S5_MTR1 may be incomplete. When this step was stopped there were 0 observations and 36 variables. WARNING: Data set GEOG.USCIS_OIS_LPR_S5_MTR1 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds

RedMcCallen · ‎11-14-2016

Nope, now get the following error message. NOTE: Line generated by the macro variable "TOPMETROS". 38 array[10] $5. metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460') ___ 22 200 ERROR: Undeclared array referenced: array. NOTE: Line generated by the macro variable "TOPMETROS". 38 array[10] $5. metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460') _______ 68 ERROR 22-322: Syntax error, expecting one of the following: +, =. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 68-185: The function METRO10 is unknown, or cannot be accessed.

RedMcCallen · ‎11-14-2016

I can't get the formatting to come out right. All I get is this tiny box to put anything into regardless of browser that I use. However, the above code does not work, keep saying that I have an undeclared array referenced: topMetros.

RedMcCallen · ‎11-14-2016

All, I am trying to reference a global array so that I can output a series of files based on the matching of values in a variable. Below is the code: %let topMetros = array[10] $5. metro1-metro10 ('35620' '31090' '33100' '16980' '41860' '47900' '26420' '19100' '41940' '14460'); %macro count(toomany); %do i = 1 %to &toomany; data geog.uscis_ois_lpr_s5_mtr&i.; f CBSA_CODE = topMetros[&i]. then output geog.uscis_ois_lpr_s5_mtr&i.; %end; %mend count; %count(10); run; When I do I get an error message of the following: "180: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 180-322: Statement is not valid or it is used out of proper order."

RedMcCallen · ‎11-08-2016

data etn.table3; set etn.table2; by BEN_AGE; array year [1973:2011] yr1973-yr2011; array ayear [1973:2011] ayr1973-ayr2011; if AGE = 0 then do; do i = 1 to dim(year); ayear[i]= year[i]; end; end; else ayr1973 = yr1973; run;

RedMcCallen · ‎11-08-2016

Yes, the code works, technically it throws no errors. However, it does not transfer the values from the old variable to the new variable. All the cells are empty. There is no error message to post.

RedMcCallen · ‎11-08-2016

The statements in the if bloc need to be transferring values from one variable to another, which just using arrays does not accomplish. I tried the above code before and I got empty cell values. My main objective is to cycle through one variable name var1 to varN, transferring the values in each variable to the corresponding newVar1 to newVarN. For example, in the first iteration the value in yr1973 needs to be transferred into ayr1973. Then for the second iteration the value of yr1974 needs to be transferred into ayr1974... the process continues until 2011. I cannot get the code to recognize yr1973 and ayr1973 as variables.

RedMcCallen · ‎11-08-2016

The statements in the if bloc need to be transferring values from one variable to another, which just using arrays does not accomplish. I tried the above code before and I got empty cell values. My main objective is to cycle through one variable name var1 to varN, transferring the values in each variable to the corresponding newVar1 to newVarN.

Online Status	Offline
Date Last Visited	‎10-20-2017 04:33 PM

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Macro Loop with Array Value in Where Statement

Re: Referencing Global Arrays in Data Step

Re: Referencing Global Arrays in Data Step

Re: Referencing Global Arrays in Data Step

Re: Referencing Global Arrays in Data Step

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Re: Macro Loop with Array Value in Where Statement

Macro Loop with Array Value in Where Statement

Re: Referencing Global Arrays in Data Step

Re: Referencing Global Arrays in Data Step

Re: Referencing Global Arrays in Data Step

Re: Referencing Global Arrays in Data Step

Referencing Global Arrays in Data Step

Re: Automating Sequential Variable Processing

Re: Automating Sequential Variable Processing

Re: Automating Sequential Variable Processing

Re: Automating Sequential Variable Processing