04-23-2015 10:58 PM
I am fairly new to SAS.
proc ttest alpha=0.05 h0=14 sides=u DATA = "/folders/myfolders/sasuser.v94/FB1.csv" ;
var Averagetime ;
This is the error
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
43 proc ttest alpha=0.05 h0=14 sides=u DATA = "/folders/myfolders/sasuser.v94/FB1.csv" ;
ERROR: Extension for physical file name "/folders/myfolders/sasuser.v94/FB1.csv" does not correspond to a valid member type.
44 var Averagetime ;
04-24-2015 08:03 AM
Welcome to SAS. You have asked a great question. The simple answer is that the DATA= option is expecting a SAS data set, not a csv file. So before you call the TTEST procedure you should import the csv file into SAS. There are several ways to do it. If you are using a SAS GUI you can run an import wizard (File->Import Data in the Windowing Environment or in Enterprise Guide), or you can use some of the programming techniques in this article:
If you create a SAS data set called FB1 in the WORK libref, then you can use DATA=WORK.FB1 to access the data.
To performa a standard t-test, you will also want to include a CLASS statement in the call to PROC TTEST. The CLASS statement enables you to specify the name of the variable that indicates whenther each observation belongs to Group1 or Group2.
04-27-2015 10:36 AM
i have summary report and detail report,detail report having date prompt ,this prompt get date from summary report using report linking .
but at time of linking (summary report to detail report ) date variable not found in summary report only in cross tab object.
but its properly work in other object like bar chat,line chart etc.
so whats the problem for cross tab for report linking date prompt