Hello I want to print in proc report only rows with BMI between 19 and 21 What  is the way to do it? proc report data=sashelp.class nowd; column name weight height BMI; define name / display; define weight / display; define height / display; define bmi / computed format=4.1 'BMI'; compute bmi; bmi = weight/(height*height)*703; endcomp; run;       ... View more

Hello Let's say that I want to check for each char var what is its max length and then reduce the length of each var to its maximum length. I have started write the code but I need to do more 2 steps and I need the advice/help here /**DETERMINE THE MAX LENGTH FOR EACH CHAR VAR**/ /***Apply the rule that if max len is higher then current len than reduce the var len****/   %macro RRR(data=); %local data_upcase library_name member_name character_vars length_character_vars num_charvars i; %let data_upcase = %upcase(&data); %let member_name=%scan(&data_upcase, -1, %str(.)); %let library_name=%scan(&data_upcase, 1, %str(.)); %if &library_name = &member_name %then %let library_name=WORK; /**COPY CHARACTER VARIABLE NAMES AND LENGTHS TO MACRO VARIABLES; TERMINATE IF NO CHARACTER VARIABLES**/ proc sql noprint; select name, length into :character_vars separated by ' ', :length_character_vars separated by ' ' from dictionary.columns where libname="&library_name" and memname="&member_name" and type = "char"; %let num_charvars=&sqlobs; quit; /**If the data set has no character variables, notify the user and terminate**/ %if &num_charvars=0 %then %do; %put NOTE: No char variables in data set &data, macro ends; %return; %end; /**DETERMINE THE MAX LENGTH FOR EACH CHAR VAR**/ /***Apply the rule that if max len is higher then current len than reduce the var len****/ ... View more

Hello I am running via SAS code to check when a table was created (And when was updated ). This table is located in  TeraData. What is the reason that I see No information on this information proc contents data=tcrmseg.gal_hravot_brzel_2023;Run; /**Other Way**/ proc datasets library=TCRMSEG; contents data=gal_hravot_brzel_2023; run;     ... View more

Hello I run this code  proc sql; create table WANT as select Company_Code,Company_Code_Desc, count(*) as nr_Transactions format=comma23., count(distinct Branch_Cust_IP) as nr_Customers format=comma23., sum(AMOUNT)/1000000 as AMOUNT format=comma23. from r_r.Have group by Company_Code,Company_Code_Desc ; quit; I get this error ERROR: Index TEMPINDX cannot be created on file WORK.'SASTMP-000000169'n because the length of the index value (30640 bytes) is too large. The index page size (currently 32767) must be large enough to store three index values plus a small overhead structure. Reduce the length of the index value or use the IBUFSIZE= option to increase the index page size (up to a maximum of 32,767 bytes). ERROR: :Unable to create temporary index while processing summary functions. What does it mean? HOw can I solve it?                 ... View more

Hello Let's say that I want to Rename data set tbl1 (in work library) into tbl2 (in work library) then the code will be : proc datasets library=WORK; change tbl1=tbl2 ; run; Let's say that I want to Rename data set tbl1 (in permanent library R_R) into tbl2 (in permanent library R_R) then the code will be : proc datasets library=R_R; change tbl1=tbl2 ; run; My question: Let's say that I want to COPY data set tbl1 (in WORK library) into tbl1 (in permanent library R_R)  - what is the code to do it? Please note that the data set is very big(25 million rows and 20 columns) and running  the following code will be too heavy and not efficient DATA R_R.tbl1; SET WORK.tbl1; Run; proc delete data=WORK.tbl1;Run;     ... View more

Hello, I have a SAS data set with 15 columns and 20 million rows. I want to use sort+nodupkey in order to delete duplicate rows. I run this short query and it is running  long time (More than 20 minutes) and still didn't finish. Any idea what to do in order to speed up the query? proc sort data=r_r.My_tbl (Where=(Event_Id ne .)) out=Want nodupkey dupout=x; by Event_Id; run; ... View more

Hello I want to create multiple macro variables based on data set that contain 2 colums: column 1 is Macro var name Column 2 is the value that the macro var will get for example: Macro var M0 will get value 2309 Macro var M1 will get value 2308 and so on What is the way to do it please? I think that I did it well but when I write %put &&m&n..;  to see the last macro var then I get  warning and cannot see its value.Why??? WARNING: Apparent symbolic reference M not resolved. 26 %put &&m&n..; &m.. %let startMon=2012; %let LastMon=2309; data _null_; date_start=mdy(mod(&startMon,100),1,floor(&startMon/100)); date_end=mdy(mod(&LastMon,100),1,floor(&LastMon/100)); n = intck('month',date_start,date_end); call symputx('n',put(counter,best.)); call symputx('date_start',put(date_start,best.)); call symputx('date_end',put(date_end,best.)); format date_start date_end date9.; run; data want_month; date=&date_start.; end_date=&date_end.; YYMM=input(put(date,yymmn4.),best.); format date end_date date9.; do while (date<=end_date); output; date=intnx('month', date, 1, 's'); YYMM=input(put(date,yymmn4.),best.); end; format date YYMMN4.; drop date end_date; run; proc sort data=want_month; by descending YYMM ; Run; DATA want_month2(DROP=seq); SET want_month; seq = _N_-1; Macro_Var_Name=CATS("M",seq); RUN; data _null_; set want_month2; call symputx(Macro_Var_Name,YYMM); run; %put &M0; %put &M1; %put &M33; %put &&m&n..;/******Why WARNING: Apparent symbolic reference M not resolved??????***/ ... View more