About aowais

aowais · ‎02-06-2020

It drops the last character: e.g. for code = RWA, it only saves RW, for code = SWE = it only saves SW

aowais · ‎02-06-2020

Hi all, I've written the macro below to run 217 regressions by the variable "code", and save the estimates for each one in a different dataset, and then I want to save the value of the variable "code" itself" in the output dataset generated through the data statement. The problem is the "code" (which is 3 characters) is being included perfectly fine for all but 5 of the 217 datasets, and I can't figure out why. Any thoughts? %macro ln_gdp(code=); proc glm data = two plots = none ; model ln_gdp = year; where code = "&code."; ods output ParameterEstimates=PE_&code.; run; quit; data PE_&code.; set PE_&code.; code = "&code."; run; %mend ln_gdp; ****Executing the macro*****; *Get list of all codes; proc sql; create table all_countries as select distinct code from two; quit; *Run macro; data _null_; *macro_call; set all_countries;* *Build macro call string; str = catt('%ln_gdp(code = ', code, ');'); *Call macro; call execute(str); run;

aowais · ‎07-12-2019

Thank you. This works.

aowais · ‎07-12-2019

I tried that, but it didn't work.

aowais · ‎07-12-2019

Hello, I'm trying to create a variable from two others which should be missing if both are missing, '1' if both are '1' and '0' otherwise. I know how to do this in longhand (see below), but is there a shorter way? data two; set one; if var1 = . and var2 = . then new_var = .; else if var1 = 1 and var2 = 1 then new_var = 1; else new_var = 0; run;

aowais · ‎07-12-2019

Thanks! It works!

aowais · ‎07-12-2019

Hi All, I need to recode a set of 8 variables into a single variable, such that if all 8 are missing then the new variable is missing, but if even one of the variable = '1' then the new variable = '1'; else the new variable = '0'. I know how to that in long hand (see below), but was wondering is there was a better way to do this. data two; set one; if var1 = . and var2 = . and var3 = . and var4 = . and var5 = . and var6 = . and var7 = . and var8 = . then new_var = .; else if var1 = 1 or var2 = 1 or var3 = 1 or var4 = 1 or var5 = 1 or var6 = 1 or var7 = 1 or var8 = 1 then new_var = 1; else new_var = 0; run;

aowais · ‎02-25-2019

The question was multiple response, and data were entered as needed; i.e. KN2 = 1 if respondant answered with 1 AND 2, or 3 or 8; 0 otherwise.

aowais · ‎02-25-2019

Thanks, yes I misread the requirement.

aowais · ‎02-25-2019

Hello, I need to create a variable based on responses from another variable as follows: if KN2 = 1 and 2, or 3, or 8, AND KN3 = 1, 2, or 3 then I2 = 1; esle I2 = 0. Right now I'm using the following code: if ((kn2 = 1 and kn2 = 2) or kn2 in (3,8)) and kn3 in (1:3) then i2 = 1; else i2 = 0; Is there a better way to write this code? Thanks!

aowais · ‎02-04-2019

This worked! Thank you! You were right about the values being the issue. The values included 1, 2, 555 and some missing.

aowais · ‎02-04-2019

Thanks, but this results in all values for public_care = 0...

aowais · ‎02-04-2019

Hi, I am trying to create a binary variable based on the responses in 8 other variables. I'm currently using the following code, which is working, but I was wondering if there is a better way to do this, such as using arrays? data two; set one; if co7_1 = 1 or co7_2 = 1 or co7_3 = 1 or co7_4 = 1 or co7_5 = 1 or co7_6 = 1 or co7_7 = 1 or co7_8= 1 then public_care = 1; else public_care = 0; run;

aowais · ‎01-18-2019

Thank you! This worked!

aowais · ‎01-16-2019

Thank you. Point noted about upper case. When I try your suggestion, it works for the first two variables, but for the last three, all values end up missing...

Online Status	Offline
Date Last Visited	‎02-06-2020 02:19 PM

Re: SAS macro being weird

SAS macro being weird

Re: Recode new variable

Re: Recode new variable

Recode new variable

Re: Recode multiple variables

Recode multiple variables

Re: Creating new variable

Re: Creating new variable

Creating new variable

Re: SAS macro being weird

SAS macro being weird

Re: Recode new variable

Re: Recode new variable

Recode new variable

Re: Recode multiple variables

Recode multiple variables

Re: Creating new variable

Re: Creating new variable

Creating new variable

Re: Creating a single variable from multiple variables

Re: Creating a single variable from multiple variables

Creating a single variable from multiple variables

Re: Recoding multiple variables with three categories at once

Re: Recoding multiple variables with three categories at once