topic Re: Desafío 2: SAS Macros in Forum en español

Desafío 2: SAS Macros

Berenice25 — Wed, 23 Feb 2022 17:53:52 GMT

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.

Re: Desafío 2: SAS Macros

jcvargasr — Wed, 23 Feb 2022 17:54:56 GMT

Colocando %UpCase

Re: Desafío 2: SAS Macros

rubenvaldez — Wed, 23 Feb 2022 17:55:20 GMT

%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;

Re: Desafío 2: SAS Macros

pcovian — Wed, 23 Feb 2022 17:55:54 GMT

agergar % en la fucnion upcase

Re: Desafío 2: SAS Macros

Lizeth — Wed, 23 Feb 2022 17:56:14 GMT

%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;

Re: Desafío 2: SAS Macros

TomNunez — Wed, 23 Feb 2022 17:56:16 GMT

%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;

Re: Desafío 2: SAS Macros

Karen88 — Wed, 23 Feb 2022 17:56:36 GMT

%Macro Crear_Cars( Parm_Make );

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

Re: Desafío 2: SAS Macros

vmorales — Wed, 23 Feb 2022 17:56:52 GMT

%UpCase

Re: Desafío 2: SAS Macros

HMORALESA — Wed, 23 Feb 2022 17:57:28 GMT

%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)

Re: Desafío 2: SAS Macros

Vairoleto — Wed, 23 Feb 2022 17:57:29 GMT

cambiar

Select( UpCase(Make) );

por

Select( %UpCase(Make) );

Re: Desafío 2: SAS Macros

wiliambejarapi — Wed, 23 Feb 2022 17:57:33 GMT

%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)

Re: Desafío 2: SAS Macros

chapingo — Wed, 23 Feb 2022 17:57:40 GMT

poner %UpCase

Re: Desafío 2: SAS Macros

Ironsss — Wed, 23 Feb 2022 17:57:42 GMT

%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)

Re: Desafío 2: SAS Macros

SaulGT — Wed, 23 Feb 2022 17:58:16 GMT

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

Re: Desafío 2: SAS Macros

SanGuerrero — Wed, 23 Feb 2022 17:58:23 GMT

%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)

Re: Desafío 2: SAS Macros

rarmenta — Wed, 23 Feb 2022 17:58:52 GMT

No esta en mayúsculas "%UPCASE( &Parm_Make )"

Re: Desafío 2: SAS Macros

javibarraza — Wed, 23 Feb 2022 17:59:43 GMT

%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;

Re: Desafío 2: SAS Macros

OLBOYZO — Wed, 23 Feb 2022 17:59:59 GMT

falta % en UpCase

Re: Desafio 2: SAS Macros

Jorge_Adrian — Wed, 23 Feb 2022 18:00:02 GMT

%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)

Re: Desafío 2: SAS Macros

andrea_stgo — Wed, 23 Feb 2022 18:01:33 GMT

%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)