SAS Support Communities

Hello, I have a folder of 14 text delimited files that I need to import into SAS. Is it possible to import them all in at the same time rather than one at a time and is there any sample code and macro that anyone could recommend? Is there possibly a way to loop through each file from 1 to 14 and pull all 14 of the files in simultaneously? ... View more

Is it possible to get just the single column average of a dataset output into a separate variable without using Proc Means?. I need to obtain the average of the OBP column in the attached spreadsheet( see Column G highlighted with an average of 0.337829493 in cell Q10) and then append it to the end of that same dataset. It can be done in Excel successfully but when I average it in SAS, I get the average for each individual player in the data set and just need that one combined OBP average of 0.337829493  as a variable to append it to the original data set. My code is listed below. Also what would be best to use to append it, Would I just use PROC APPEND?  Thanks in advance for any help with this       PROC IMPORT DBMS=xlsx OUT=more_rate replace DATAFILE="/folders/myfolders/sasuser.v94/baseball_more_rate.xlsx"; GETNAMES=YES; RUN; data more_avg2; set work.more_rate; TotalOBP=sum(OBP); AverageOBP=TotalOBP/217; drop TotalOBP; run;       PROC IMPORT DBMS=xlsx OUT=more_rate replace DATAFILE="/folders/myfolders/sasuser.v94/baseball_more_rate.xlsx"; GETNAMES=YES; RUN; data more_avg2; set work.more_rate; TotalOBP=sum(OBP); AverageOBP=TotalOBP/217; drop TotalOBP; run; PROC IMPORT DBMS=xlsx OUT=more_rate replace DATAFILE="/folders/myfolders/sasuser.v94/baseball_more_rate.xlsx"; GETNAMES=YES; RUN; data more_avg2; set work.more_rate; TotalOBP=sum(OBP); AverageOBP=TotalOBP/217; drop TotalOBP; run;   PROC IMPORT DBMS=xlsx OUT=more_rate replace DATAFILE="/folders/myfolders/sasuser.v94/baseball_more_rate.xlsx"; GETNAMES=YES; RUN; data more_avg2; set work.more_rate; TotalOBP=sum(OBP); AverageOBP=TotalOBP/217; drop TotalOBP; run;   ... View more

I'm trying to format these values with 3 decimal places but I keep getting the leading zeroes in front of the decimal place   I'm using the following code   format AVG 9.3; format SLG 6.3; format OBP 9.2; format ISO 6.3; format AVG 9.3; format SLG 6.3; format OBP 9.3; format ISO 6.3;   format AVG 9.3; format SLG 6.3; format AVG 9.3; format SLG 6.3; format AVG 9.3; format SLG 6.3; format OBP 9.2  I have attached the Excel output from SAS, please take a look at the AVG, SLG,  OBP and ISO columns O, P,Q and R on the attached spreadsheet and advise ... View more

data baseball4; set work.baseball; array NumVar _numeric_; do over NumVar; if NumVar=. then NumVar=0; end; format AVG 6.3; format SLG 6.3; MIN=SALARY< 500000; MAX=SALARY<=10000000; OBP=H+HBP/PA; format OBP 6.3; ISO=SLG-AVG; format ISO 6.3; SP=SO/PA; format SP percent7.1; BA=H/AB; format BA 6.3; IF SALARY >=MAX THEN Salary_Description='Filthy Rich'; ELSE Salary_Description='none'; if SALARY < MIN then sal_type ='Less than League Minimum'; /* ELSE if SALARY >= MIN then sal_type='Filthy Rich'; */ ELSE sal_type='middle'; run; Hi, I'm not getting any errors in my code, but can someone look at the attached assignment and let me know if there is a better or more efficient way to write this according to the assignment criteria. Thanks, much appreciated!         ... View more