Desafío 2: SAS Macros

[Berenice25]

2. El contenido parcial de la tabla SASHELP.CARS es el siguiente:

Make Type MSRP
----------------------------
Acura SUV $36,945
Acura Sedan $23,820
Acura Sedan $26,990
Audi Sedan $25,940
Audi Sedan $35,940
Audi Sedan $31,840
Audi Sedan $33,430
BMW SUV $37,000
BMW SUV $52,195
BMW Sedan $28,495
BMW Sedan $30,795

Se ejecuta la siguiente defición y llamado de macro:

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;
Set SASHelp.Cars;
Select( UpCase(Make) );
When( "&Parm_Make" ) Output &Parm_Make;
Otherwise;
End;
Run;

%Mend Crear_Cars;

%Crear_Cars(Audi)


Y el LOG indica que la tabla final WORK.AUDI "NO TIENE REGISTROS"

7 %Macro Crear_Cars( Parm_Make );
8
9 Data &Parm_Make;
10 Set SASHelp.Cars;
11 Select( UpCase(Make) );
12 When( "&Parm_Make" ) Output &Parm_Make;
13 Otherwise;
14 End;
15 Run;
16
17 %Mend Crear_Cars;
18
19 %Crear_Cars(Audi)

NOTE: There were 428 observations read from the data set SASHELP.CARS.
NOTE: The data set WORK.AUDI has 0 observations and 15 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

Se detecta que el error se corrige colocando una SENTENCIA MACRO que está ausente.

Envíe la definción de la macro corregida.

[jcvargasr]

Colocando %UpCase

[Ironsss]

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;

Set SASHelp.Cars;

Select( %UpCase(Make) );

When( "&Parm_Make" ) Output &Parm_Make; Otherwise; End;

Run; %Mend Crear_Cars; %Crear_Cars(Audi)

[rubenvaldez]

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;
Set SASHelp.Cars;
Select( %UpCase(Make) );
When( "&Parm_Make" ) Output &Parm_Make;
Otherwise;
End;
Run;

%Mend Crear_Cars;

[pcovian]

agergar % en la fucnion upcase

[Lizeth]

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;
Set SASHelp.Cars;
Select( %UpCase(Make) );
When( "&Parm_Make" ) Output &Parm_Make;
Otherwise;
End;
Run;

%Mend Crear_Cars;

[TomNunez]

%Macro Crear_Cars( Parm_Make);

Data &Parm_Make;
Set SASHelp.Cars;
Select( %UpCase(Make));
When("&Parm_Make") Output &Parm_Make;
Otherwise;
End;
Run;

%Mend Crear_Cars;

[Karen88]

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;
Set SASHelp.Cars;
Select( %UpCase(Make) );
When( "&Parm_Make" ) Output &Parm_Make;
Otherwise;
End;
Run;

[vmorales]

%UpCase

[HMORALESA]

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;
Set SASHelp.Cars;
Select( UpCase(Make) );
When( "%UPCASE( &Parm_Make )" ) Output &Parm_Make;
Otherwise;
End;
Run;

%Mend Crear_Cars;

%Crear_Cars(Audi)

[Vairoleto]

cambiar

Select( UpCase(Make) );

por

Select( %UpCase(Make) );

[wiliambejarapi]

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;
Set SASHelp.Cars;
Select( %UpCase(Make) );
When( "&Parm_Make" ) Output &Parm_Make;
Otherwise;
End;
Run;

%Mend Crear_Cars;

%Crear_Cars(Audi)

[chapingo]

poner %UpCase

[SaulGT]

Colocando el %upcase en el when, por ejemplo when ("%UPCASE(&Parm_Make)" output &Parm_Make;

[SanGuerrero]

%Macro Crear_Cars( Parm_Make );

Data &Parm_Make;
Set SASHelp.Cars;
Select( UpCase(Make) );
When( "%UPCASE(&Parm_Make)" ) Output &Parm_Make;
Otherwise;
End;
Run;

%Mend Crear_Cars;

%Crear_Cars(Audi)