Hello I want to calculate sum of fields . One of the fields in the sum is calculated variable. Is there a way to calculate it in one step with SUM function? This way is not working  SUM(case when X<0 then abs(X) else 0 end as calc_X,Y,Z) as Total_Other_Way     Data have; Input Cust_ID X Y Z; cards; 1 -100 50 60 2 200 60 40 3 -300 30 20 4 400 10 90 5 250 80 20 ; Run; proc sql; create table want as select *, case when X<0 then abs(X) else 0 end as calc_X, SUM(calculated calc_X,Y,Z) as Total, SUM(case when X<0 then abs(X) else 0 end as calc_X,Y,Z) as Total_Other_Way from have ; quit; ... View more

Hello In my data set I have two numeric categorical variables . I want to create two way table that calculate freqs. I want to display the categories in the char values (For var Class values-F,C,Y  and for var gender values-Male,Female) I want to control the order of rows and columns in following order-For var Class -C,F,Y and for var genfer-Male,Female What is the way to do it via proc tabulate?   proc format; value classcode_fmt 8='F' 9='C' 11='Y' ; Run; proc format; value classcode_order_fmt 9=1 8=2 11=3 ; Run; proc format; INVALUE classcode_order_ordinal 'C'=1 'F'=2 'Y'=3 ; Run; proc format; value gender_fmt 1='Female' 2='Male' ; Run; proc format; value gender_order_fmt 2=1 1=2 ; Run; proc format; INVALUE gender_order_ordinal 'Male'=1 'Female'=2 ; Run; data have; input class gender; cards; 8 1 9 1 11 1 11 2 11 2 11 1 9 2 8 1 ; Run; proc tabulate data=have format=8.2 MISSING; class class gender; table class='' all, (gender all)*(n=''*f=8.) / rts=10 misstext='0'; run;     ... View more

Hello I want to perform the following task: 1-List all files in specific folder A-Get the files names without the end   (It means that require to see the field fname without the end "sas7bdat") B-Get field of last modified date (Field Last Modified). Currently this field is char and the request is to be date time   2-Delete all files that last modified date is before 31DEC2022   /**********SAS -list all files in specific folder with modified date information********************/ /**********SAS -list all files in specific folder with modified date information********************/ /**********SAS -list all files in specific folder with modified date information********************/ %let filesLocation=/usr/local/SAS/SASUsers/LabRet/Credit_Scoring_Users/R_R; /* get full list of files from &filesLocation. (including all subdirectories) */ /* just to be sure the file "files" is "empty" */ data files_to_get; run; data files_to_get; length root dname $ 2048 filename $ 256 dir level 8; root = "&filesLocation."; retain filename dname ' ' level 0 dir 1; label filename = "file" dname = "folder" ; run; data files_to_get; modify files_to_get; rc1=filename('tmp',catx('/',root,dname,filename)); rc2=dopen('tmp'); dir = 1 & rc2; if dir then do; dname=catx('/',dname,filename); filename=' '; end; replace; if dir; level=level+1; do i=1 to dnum(rc2); filename=dread(rc2,i); output; end; rc3=dclose(rc2); run; /* get files info in "Long" format */ data files_to_get_dates; set files_to_get(where=(dir=0)); fname="tempfile"; rc=filename(fname, catx('/',root,dname,filename)); if rc = 0 and fexist(fname) then do; fid=fopen(fname); infonum=foptnum(fid); do i=1 to infonum; infoname=foptname(fid, i); infoval=finfo(fid, infoname); output; end; fid=fclose(fid); end; rc=filename(fname); drop dir--i; run; /* transforms files info into "Wide" format */ proc transpose data = files_to_get_dates(rename=(filename=fn)) out=files_to_get_dates_T(drop =_name_); by root dname fn notsorted; id infoname; var infoval; run;       ... View more

Hello I want to calculate aggregation simple statistics to different groups. Is there a shorter code that  can produce same results? Maybe via proc format? proc sql; create table Want as select Type, count(*) as nr_rows format=comma28., sum(MSRP) as SUM_MSRP format=comma28., sum(Invoice) as SUM_Invoice format=comma28. from sashelp.cars group by Type union all select 'SUV+Sports' as Type, count(*) as nr_rows format=comma28., sum(MSRP) as SUM_MSRP format=comma28., sum(Invoice) as SUM_Invoice format=comma28. from sashelp.cars where Type in ('SUV','Sports') union all select 'SUV+Hybrid' as Type, count(*) as nr_rows format=comma28., sum(MSRP) as SUM_MSRP format=comma28., sum(Invoice) as SUM_Invoice format=comma28. from sashelp.cars where Type in ('SUV','Hybrid') union all select 'Hybrid+SUV+Sedan+Sports' as Type, count(*) as nr_rows format=comma28., sum(MSRP) as SUM_MSRP format=comma28., sum(Invoice) as SUM_Invoice format=comma28. from sashelp.cars where Type in ('Hybrid','SUV','Sedan','Sports') union all select ' Truck+Wagon' as Type, count(*) as nr_rows format=comma28., sum(MSRP) as SUM_MSRP format=comma28., sum(Invoice) as SUM_Invoice format=comma28. from sashelp.cars where Type in ('Truck','Wagon') union all select 'ALL' as Type, count(*) as nr_rows format=comma28., sum(MSRP) as SUM_MSRP format=comma28., sum(Invoice) as SUM_Invoice format=comma28. from sashelp.cars ; quit; ... View more