topic Re: Create variable in SAS Programming

Create variable

Thalitacosta — Fri, 27 May 2022 19:37:39 GMT

I'm in trouble to create the variable "score" in the table "gini&k.2", because what sas creates is:

gini score BA

0,2 . .

And what I need:

gini score

0,2 BA

Follows the code:

%macro ks_gini(perf, escores);

%do k=1 %to %sysfunc(countw(&escores));
%let escore0 = %scan(&escores, &k);

proc sort data = base_filtro (keep= &escore0. &perf.) out=sort_&escore0.;
by &escore0.;
run;

/*GINI*/

proc freq data=sort_&escore0. noprint;
tables &perf.*&escore0./ measures;
output out=gini&k. measures;
run;

data gini&k.2;
set gini&k. (keep= _SMDCR_ rename=(_SMDCR_=gini));
length score $20;
score = &escore0.;
FORMAT gini COMMAX20.3;
run;

proc append data=gini&k.2 base=gini;run;

%end;

%mend ks_gini;

Re: Create variable

andreas_lds — Fri, 27 May 2022 19:49:36 GMT

Please post the complete log using "insert code" button to preserve formatting. Don't forget to activate mprint and symbolgen before executing the macro.

Re: Create variable

ballardw — Fri, 27 May 2022 19:56:14 GMT

Since you have given us no data, no definition for any of the macro variables, no example of the macro call with its parameters or a log entry showing what ran, I am afraid there is not much we can do with out more details.

I have a strong suspicion that for at least some of the values in you Escores macro variable that this line fails because of data type.

score = &escore0.;

If you &escore0. value does not include quotes then it will be treated as the name of a variable. Which almost certainly does not exist at the point this line executes because you have kept only one variable in the source set and renamed it to Gini. If your log shows notes about some oddly named variable you do not recognize as "Unitialized" that is almost certainly what happened.

I have a strong suspicion as well that if you showed an example of the starting data set and the desired result there is much easier way to accomplish this as it appears that you are basically transposing data.

Example data should be in form of a data step as well.

Re: Create variable

Reeza — Fri, 27 May 2022 20:03:19 GMT

Add the following:

options mprint symbolgen;

Run the macro code again, show the code run, the macro call and the log.

As posted, hard to tell what you're doing or where it could be going wrong.