Permalink![Invalid Member Name For File Sas Invalid Member Name For File Sas](/uploads/1/2/6/3/126348092/735175939.jpg)
Sign up
File library.member.DATA has too long a member name for the V6 engine This message appears when you use PROC COPY to move a data set whose name exceeds eight characters from a source computer that is running SAS 9 to a SAS 6 library. The output of tagsets.excelxp is XML, so files should have an extension of.xml. Newer versions of Excel complain when you want to open a XML file with a.xls extension. Maxims of Maximally Efficient SAS Programmers.
Join GitHub today
![Invalid Member Name For File Sas Invalid Member Name For File Sas](/uploads/1/2/6/3/126348092/735175939.jpg)
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
![Invalid file names windows Invalid file names windows](http://www.zeisscamera.com/images/Pict6.jpg)
Find file Copy path
Cannot retrieve contributors at this time
*1.1. Identify which of the following variable names are valid SAS names: |
Height |
HeightInCentimeters |
Height_in_centimeters |
Wt-Kg |
x123y456 |
76Trombones |
MiXeDCasE |
Height, HeightInCentimeters, Height_in_centimeters, x123y456, & MiXeDCasE are all valid SAS variable names. |
*1.2 In the following list, classify each data set name as valid or invalid: |
Clinic |
clinic |
work |
hyphens-in-the-name |
123GO |
Demographics_2006 |
Clinic, clinic, work, and Demographics_2006 are all valid data set names. hyphens-in-the-name and 123GO are both invalid data set names. |
*1.3 You have a data set consisting of Student ID, English, History, Math, and Science |
test scores on 10 students. |
a. The number of variables is __________ |
b. The number of observations is __________ |
a) The number of variables is 5. |
b) The number of observations is 10. |
*1.4 True or false: |
a. You can place more than one SAS statement on a single line. |
b. You can use several lines for a single SAS statement. |
c. SAS has three data types: character, numeric, and integer. |
d. OPTIONS and TITLE statements are considered global statements. |
a) True |
b) True |
c) False |
d) True |
*2.1.You have a text file called stocks.txt containing a stock symbol, a price, and the |
number of shares. Here are some sample lines of data: |
File stocks.txt |
AMGN 67.66 100 |
DELL 24.60 200 |
GE 34.50 100 |
HPQ 32.32 120 |
IBM 82.25 50 |
MOT 30.24 100 |
a. Using this raw data file, create a temporary SAS data set (Portfolio). Choose |
your own variable names for the stock symbol, price, and number of shares. In |
addition, create a new variable (call it Value) equal to the stock price times the |
number of shares. Include a comment in your program describing the purpose of |
the program, your name, and the date the program was written. |
b. Write the appropriate statements to compute the average price and the average |
number of shares of your stocks. |
a); |
dataportfolio; |
input Stock $ Price NumberOfShares; |
Value = Price*NumberOfShares; |
datalines; |
AMGN 67.66100 |
DELL 24.60200 |
GE34.50100 |
HPQ 32.32120 |
IBM 82.2550 |
MOT 30.24100 |
run; |
proc print data=portfolio; |
title'Portfolio'; |
*The purpose of this program is to show the value of the current stocks. |
Nick Lipanovich 4/4/2013; |
* b); |
title'Averages'; |
proc meansmean data=portfolio; |
var Price NumberOfShares; |
run; |
*2.4 What is wrong with this program? |
001 data new-data; |
002infile prob4data.txt; |
003input x1 x2 |
004 y1 = 3(x1) +2(x2); |
005 y2 = x1 / x2; |
006 new_variable_from_x1_and_x2 = x1 + x2 – 37; |
007run; |
Note: Line numbers are for reference only; they are not part of the program. |
There is a hyphen in the datasetname. |
Theinfiledoesnotprovideacompletepathtothetextfile. |
Thereisn'tasemicolonaftertheinputstatement. |
Thereneedstobeasterisksbetweenthe3andx1 & the2andx2inline4inorderforthemtobemultiplied. |
*3.1Youhaveatextfilecalledscores.txtcontaininginformationongender (M or F) |
andfourtestscores (English, history, math, and science). Eachdatavalueis |
separatedfromtheothersbyoneormoreblanks. Hereisalistingofthedatafile: |
Filescores.txt |
M80828588 |
F94928896 |
M96888992 |
F95 . 9292 |
a. WriteaDATAsteptoreadinthesevalues. Chooseyourownvariablenames. Be |
surethatthevalueforGenderisstoredin1byteandthatthefourtestscoresare |
numeric. |
b. Includeanassignmentstatementcomputingtheaverageofthefourtestscores. |
c. WritetheappropriatePROCPRINTstatementstolistthecontentsofthisdata |
set. |
; |
datascores; |
infile'C:UsersNickDocumentsMy SAS Files(32)scores.txt'; |
input Gender $ English History Math Science; |
run; |
title'Test Scores'; |
proc print data=scores; |
run; |
title'Test Means'; |
proc meansmean data=scores; |
var English History Math Science; |
run; |
Copy lines Copy permalink