Isma1

Question

Which of the following statements correctly describes a delimited raw data file? Select all that apply.

Answer 1

It is external to SAS.

Answer 2

It is not software-specific.

Answer 3

The values are arranged in columns.

Answer 4

The values are separated by spaces or other characters.

Answer 5

The values are labeled with field names.

Answer 6

a. SAS creates an input buffer only if reading data from a raw data file.

Answer 7

At compile time, the PDV holds the variable name, type, length, and initial value.

Answer 8

The descriptor portion of the data set is the first item that SAS creates during the compilation phase

Answer 9

a. SAS reads data from the raw data file into the PDV.

Answer 10

The size of the input buffer adjusts automatically based on the length of the input record.

Answer 11

At the bottom of the DATA step, SAS writes the contents of the PDV to the output SAS data set.

Answer 12

length $ SalesRep 18;

Answer 13

length SalesRep 18;

Answer 14

length SalesRep $ 18;

Answer 15

length SalesRep=18;

Answer 16

data work.mydata; infile 'filepath/sales.csv'; length SalesRep $ 18; input Amount SalesRep $ Customer $; run;

Answer 17

data work.mydata; infile 'filepath/sales.csv' input Amount SalesRep $ Customer $; length SalesRep $ 18; run;

Answer 18

A SAS informat provides instructions for reading nonstandard values.

Answer 19

A SAS informat provides a length for character variables.

Answer 20

A SAS informat must include a period.

Answer 21

A SAS informat controls the way nonstandard data values are stored in a SAS data set.

Answer 22

A SAS informat must include a numeric value to specify the width of the input field.

Answer 23

data work.mydata; input Amount SalesRep $ Customer $; datalines; 250.35 Phelps Torres 178.50 Deng Horekova ;

Answer 24

data work.mydata; datalines; 250.35 Phelps Torres 178.50 Deng Horekova input Amount SalesRep $ Customer $; ;

Answer 25

prints a ruler and the raw data record in the SAS log

Answer 26

stops processing the program

Answer 27

assigns a missing value to the variable that the invalid data affects

Answer 28

prints a note about the error in the SAS log

Answer 29

rints the variable values in the corresponding SAS observation in the SAS log

Answer 30

Sales Manager

Answer 31

Regional Manager

Answer 32

$123,293.50

Answer 33

06/15/2008

Answer 34

the length of the variable's first value

Answer 35

the assignment statement

Answer 36

the LENGTH statement

Answer 37

all of the above

Answer 38

YEAR(SAS-date)

Answer 39

MONTH(SAS-date)

Answer 40

WEEKDAY(SAS-date)

Answer 41

TODAY(SAS-date)

Answer 42

data work.bonus; set orion.sales; if Country='US' then Bonus=500; else if Country='AU' then Bonus=300; run;

Answer 43

data work.bonus; set orion.sales; if Country='US' then Bonus=500; else Bonus=300; run;

Answer 44

if Points=70 then Grade='pass';

Answer 45

if Grade>=70 then Points='pass';

Answer 46

if Points>=70 then Grade=pass;

Answer 47

if Points>=70 then Grade='pass';

Answer 48

set empscn(rename(Country=Location)) empsjp(rename(Region=Location));

Answer 49

set empscn(rename=(Country=Location)) empsjp(rename=(Region=Location));

Answer 50

set empscn rename=(Country=Location) empsjp rename=(Region=Location);

Answer 51

Merging combines observations from two or more data sets into a single observation in a new data set.

Answer 52

SAS can merge data sets based on the position of observations in the original data set or by the values of one or more common variables.

Answer 53

Match-merging is merging by values of one or more common variables.

Answer 54

To match-merge data sets, all input data sets must be sorted or indexed on the BY variables.

Answer 55

All of the above

Answer 56

data newsales; set products sales; run;

Answer 57

data newsales; set sales products; run;

Answer 58

data newsales; set sales; set products; run;

Answer 59

all of the observations from managers, and only those observations from staff with matching values for EmpID

Answer 60

all of the observations from staff, and only those observations from managers with matching values for EmpID

Answer 61

all observations from staff and all observations from managers, whether or not they have matching values

Answer 62

only those observations from staff and manager with matching values for EmpID

Answer 63

You cannot specify more than two data sets in the SET statement.

Answer 64

There are too many sets of parentheses in the RENAME= option.

Answer 65

You cannot specify multiple variables in the RENAME= option.

Answer 66

The BY statement is missing.

Answer 67

only the observations from staff that have no match in managers

Answer 68

only the observations from managers that have no match in staff

Answer 69

all observations from both managers and staff, whether or not they match

Answer 70

no observations

Answer 71

comma between NOCUM and NOPERCENT

Answer 72

forward slash before the TABLES statement options

Answer 73

an equals sign after the TABLES statement variable

Answer 74

none of the above

Answer 75

PROC MEANS

Answer 76

PROC PRINT

Answer 77

PROC PRINT

Answer 78

PROC MEANS

Answer 79

PROC UNIVARIATE

Answer 80

proc print data=sales.totals; var ProdNum Sales Region; run;

Answer 81

proc freq data=sales.totals; tables ProdNum Sales Region; run;

Answer 82

proc univariate data=sales.totals; run;

Answer 83

PROC PRINT

Answer 84

PROC MEANS

Answer 85

PROC UNIVARIATE

Answer 86

a. NEXTROBS=

Answer 87

b. NLEVELS

Answer 88

c. NOPRINT

Answer 89

ods; proc freq data=orion.staff; tables Manager_ID; run; ods close;

Answer 90

ods listing; proc freq data=orion.staff; tables Manager_ID; run; ods listing close;

Answer 91

ods destination; proc freq data=orion.staff; tables Manager_ID; run; ods destination close;

Answer 92

6 observations, 4 variables

Answer 93

6 observations, 3 variables

Answer 94

12 observations, 4 variables

Answer 95

Nothing happens because the value does not match any value listed in a WHEN expression.

Answer 96

The observation is written only to the check data set.

Answer 97

The observation is written to all three output data sets

Answer 98

select; when (2) Bonus=Salary*.6; end;

Answer 99

select (Promotion); when (Promotion=2) Bonus=Salary*.6; end;

Answer 100

select (Promotion); when (2) Bonus=Salary*.6; end;

Answer 101

data ratings(keep=CarType MPG); set car(drop=CarID); MPG=Miles/Gallons; run;

Answer 102

data ratings; set car(drop=CarID); drop Miles Gallons; MPG=Miles/Gallons; run;

Answer 103

data new(firstobs=100 obs=200); set old; run; proc print data=new(obs=50); run;

Answer 104

data new; set old(firstobs=100 obs=200); run; proc print data=new(obs=50); run;

Answer 105

data mnthtot; set orion.aprsales; retain SaleAmt 50; Mth2Dte=Mth2Dte+SaleAmt; run;

Answer 106

data mnthtot; set orion.aprsales; retain Mth2Dte 50; Mth2Dte=Mth2Dte+SaleAmt; run;

Answer 107

Sort the input data.

Answer 108

Set the accumulating variable to its initial value at the start of each BY group.

Answer 109

Increment the accumulating variable.

Answer 110

Output only the last observation of each BY group.

Answer 111

data mnthtot; set orion.aprsales; retain Mnth2Date; Mth2Dte=Mth2Dte+SaleAmt; run;

Answer 112

data mnthtot; set orion.aprsales; retain Mth2Dte 0; Mth2Dte=Mth2Dte+SaleAmt; run;

Answer 113

Total_Retail_Price+Sales2Dte;

Answer 114

Sales2Dte+Total_Retail_Price;

Answer 115

Sales2Dte=Sales2Dte+Total_Retail_Price;

Answer 116

A change in the value of LAST.JobCode causes the value of LAST.Gender to change.

Answer 117

A change in the value of LAST.Gender causes the value of LAST.JobCode to be set to 1.

Answer 118

Both LAST.JobCode and LAST.Gender are stored in the new data set.

Answer 119

The data sets listed in the SET statement must be indexed or sorted by the values of the BY variable(s).

Answer 120

The DATA step automatically creates two new variables, FIRST. and LAST., for each variable in the BY statement

Answer 121

The FIRST. and LAST. variables identify the first and last observation in each BY group, respectively.

Answer 122

The FIRST. and LAST. variables have values of 0 when SAS is processing an observation with the first occurrence of a new value for those variables, and a value of 1 for the other observations.

Answer 123

FIRST.BY-variable=0 LAST.BY-variable=0

Answer 124

FIRST.BY-variable=1 LAST.BY-variable=0

Answer 125

FIRST.BY-variable=1 LAST.BY-variable=1

Answer 126

FIRST.BY-variable=0 LAST.BY-variable=1

Answer 127

Output the first observation of each BY group.

Answer 128

Set the accumulating variable to zero at the start of each BY group.

Answer 129

Increment the accumulating variable with a sum statement (automatically retains).

Answer 130

if first.jobtype;

Answer 131

if last.jobtype;

Answer 132

if first.jobtype then output;

Answer 133

if last.jobtype then output=1;

Answer 134

$234,908.00

Answer 135

input Item $9. @20 Quantity 3.;

Answer 136

input Item $9. +10 Quantity 3.;

Answer 137

input Item $9. +11 Quantity 3.;

Answer 138

input Fname $ Lname $ / Address $20. / City $ State $ Zip $;

Answer 139

input Fname $ Lname $ /; Address $20. /; City $ State $ Zip $;

Answer 140

input / Fname $ Lname $ / Address $20. City $ State $ Zip $;

Answer 141

column input

Answer 142

formatted input

Answer 143

none of the above

Answer 144

. standard free-format data

Answer 145

standard data in fixed fields

Answer 146

nonstandard data in fixed fields

Answer 147

input Item $9. @20 Quantity 3.;

Answer 148

input Item $9. +10 Quantity 3.;

Answer 149

. input Item $9. +11 Quantity 3.;

Answer 150

input @14 Fname $10. @1 Lname $10./ Department $7./ Salary comma10.;

Answer 151

input @14 Fname $10. @1 Lname $10. #2 Department $7. #3 Salary comma10.;

Answer 152

both a and b

Answer 153

An INPUT statement without a trailing @ executes.

Answer 154

The next iteration of the DATA step begins.

Answer 155

both a and b

Answer 156

Load the next file in the input buffer.

Answer 157

Load the next field in the input buffer.

Answer 158

Load the next record in the input buffer.

Answer 159

none of the above

Answer 160

The pointer position does not change.

Answer 161

No new record is loaded into the input buffer.

Answer 162

The next INPUT statement for the same iteration of the DATA step continues to read the same record.

Answer 163

All of the above

Answer 164

Functions are used in SAS statements.

Answer 165

A function is written by specifying the function name followed by the function arguments.

Answer 166

. Function arguments must be enclosed in parentheses.

Answer 167

All function arguments are variables.

Answer 168

. propcase(Name,'*');

Answer 169

propcase(Name,' *');

Answer 170

propcase(Name,'* ');

Answer 171

PERSONNEL DIRECTOR

Answer 172

scan(Text,-1)

Answer 173

scan(Text,6)

Answer 174

scan(Text,6,', ')

Answer 175

find('She sells seashells? Yes, she does.','she')

Answer 176

find('She sells seashells? Yes, she does.','she','i')

Answer 177

find('She sells seashells? Yes, she does.','she',22)

Answer 178

find('She sells seashells? Yes, she does.','she',-10)

Answer 179

Dept=substr(PUR,1,3);

Answer 180

substr(Dept,1,3)='PUR';

Answer 181

PUR=substr(Dept,1,3);

Answer 182

none of these

Answer 183

Country=tranwrd('Burma','Myanmar');

Answer 184

Country=tranwrd(Country,Burma,Myanmar);

Answer 185

Country=tranwrd(Country,'Burma','Myanmar');

Answer 186

RestAvg=mean of Rest1-Rest4;

Answer 187

RestAvg=mean(Rest1 Rest2 Rest3 Rest4);

Answer 188

RestAvg=sum(Rest1,Rest2,Rest3,Rest4);

Answer 189

RestAvg=mean(Rest1,Rest2,Rest3,Rest4);

Answer 190

data after; set before; Examples=int(Examples); run;

Answer 191

data after; set before; Examples=round(Examples); run;

Answer 192

both a and b

Answer 193

The values of the numeric variables TotalPay and Commission are converted to character values because these variables are used in a character context.

Answer 194

The values of the character variable Pay are converted to numeric values because this variable is used in a numeric context.

Answer 195

TargetNo=input(Target,comma6.);

Answer 196

TargetNo=input(Target,comma7.);

Answer 197

TargetNo=put(Target,comma6.);

Answer 198

TargetNo=put(Target,comma7.);

Answer 199

a. mean(Var1,Var4)

Answer 200

b. mean(Var1-Var4)

Answer 201

c. mean(of Var1,Var4)

Answer 202

d. mean(of Var1-Var4)

Answer 203

a. Total=sum(of Year1-Year4);

Answer 204

b. Total=sum(of Year2--Year4);

Answer 205

c. Total=sum(of Year:);

Answer 206

d. All of the above

Answer 207

Decrease=round(PctDec,1);

Answer 208

Decrease=ceil(PctDec);

Answer 209

Decrease=floor(PctDec);

Answer 210

Decrease=int(PctDec);

Answer 211

SAS converts the values of PayRate to numeric values. No message is written to the log.

Answer 212

SAS converts the values of PayRate to numeric values. A message is written to the log.

Answer 213

SAS converts the values of Hours to character values. A message is written to the log.

Answer 214

put(Level,3.)

Answer 215

input(3.,Level)

Answer 216

put(3.,Level)

Answer 217

input(Level,3.)

Answer 218

Location=Dept||'/'||put(SiteNum, $3);

Answer 219

Location=Dept||'/'||put(SiteNum,4);

Answer 220

Location=Dept||'/'||put(SiteNum,3.1);

Answer 221

Location=Dept||'/'||put(SiteNum,4.1);

Answer 222

put(comma10.2,Base)

Answer 223

put(Base,comma10.2)

Answer 224

input(Base,comma10.2)

Answer 225

input(comma10.2, Base)

Answer 226

putlog 'customer'=;

Answer 227

putlog 'Note: write this in the log';

Answer 228

putlog write this in the log;

Answer 229

putlog customer $quote13.;

Answer 230

putlog customer=;

Answer 231

write text to the log

Answer 232

write the values of all the variables to the log

Answer 233

write formatted values to the log

Answer 234

write all the logic errors to the log

Answer 235

infile work.catalog end=last;

Answer 236

infile work.catalog end.last;

Answer 237

infile catalog end=last;

Answer 238

infile catalog end.last;

Answer 239

Write text to the log.

Answer 240

Write formatted values to the log.

Answer 241

Write all the logic errors to the log.

Answer 242

Write the values of all the variables to the log.

Answer 243

putlog Title $quote20.;

Answer 244

putlog Title $quote22.;

Answer 245

putlog Title $quote30.;

Answer 246

Books, last of books, and the values of all the variables for the last observation

Answer 247

Books, last of books, and the values for all the variables in all observations

Answer 248

The values of all the variables for the last observation

Answer 249

do while(Capital ge 500000);

Answer 250

do while(Capital=500000);

Answer 251

do while(Capital le 500000);

Answer 252

do while(Capital>500000);

Answer 253

Each DO statement must have a corresponding END statement.

Answer 254

Each DO loop must have its own index variable.

Answer 255

Each DO loop must use the same increment value.

Answer 256

Each DO loop can contain iterated SAS statements.

Answer 257

This loop executes infinitely

Answer 258

do i=8, 10, 4, 14;

Answer 259

do i=.30 to .20 by -.1;

Answer 260

do i=(x+10) to x;

Answer 261

do i=-1 to -3 by -1;

Answer 262

When you create an array in one DATA step, you can reference it by name in another DATA step.

Answer 263

An array can contain a mixture of numeric and character variables if they are explicitly named.

Answer 264

An array exists only for the duration of the DATA step.

Answer 265

It is a good practice to name the array the same name as one of the variables in the array

Answer 266

array{*} Ans1-Ans10;

Answer 267

array quiz{6} Q1 Q2 Q3 Q4 Q5 Q6 Q7;

Answer 268

array fruit{*} Apples Pears Grapes Bananas Oranges;

Answer 269

quiz array{7} Q1-Q6;

Answer 270

array test{*} T1 T2 T3 T4 T5;

Answer 271

array test{5} T1-T5;

Answer 272

array test{*} _numeric_;

Answer 273

all of the above

Answer 274

do i=1 to 8; wt{i}=wt{i}*2.2046; end;

Answer 275

do i=1 to *; wt[i]=wt[i]*2.2046; end;

Answer 276

do i=1 to 8; Weight{i}=Weight{i}*2.2046; end;

Answer 277

array Comp{25};

Answer 278

array compute{25} Comp1-Comp25;

Answer 279

array comp{25} $;

Answer 280

array comp{*} Comp1-Comp25;

Answer 281

array country{3} _temporary_ ('AU','NZ','US');

Answer 282

array country{3} $ 2 _temporary_ (AU,NZ,US);

Answer 283

array country{3} $ 2 _temporary_ ('AU','NZ','US');

Answer 284

It is an executable statement.

Answer 285

It can be used to create variables.

Answer 286

It must contain either all numeric or all character elements.

Answer 287

It must be used to define an array before the array name can be referenced.

Answer 288

array grades{*} Q1 Q4 Q7 Q8 Q12 Q15;

Answer 289

array sites{3} $10;

Answer 290

array trials{*} _numeric_;

Answer 291

array exp{5} _temporary_ (93 85 77 69 61);

Answer 292

All of the above

Answer 293

This statement creates a temporary array of character variables.

Answer 294

This statement creates an array of all previously defined character variables in the DATA step.

Answer 295

Nothing. This is not an accurate ARRAY statement.

Answer 296

do i=1 to 4;

Answer 297

do until i=4;

Answer 298

do while i le 4;

Answer 299

The variables are added to the program data vector during the compilation of the DATA step.

Answer 300

You do not need to specify the array elements in the ARRAY statement.

Answer 301

By default, all character variables are assigned a length of eight.

Answer 302

Only character variables can be created.

Answer 303

if InProd=1 or InCost=1;

Answer 304

if InProd=0 or InCost=0;

Answer 305

if InProd=0 and InCost=0;

Answer 306

FIRST.Order, LAST.Order

Answer 307

FIRST.Customer, LAST.Customer

Answer 308

FIRST.Customer_ID, LAST.Customer_ID

Answer 309

libname bonus "&path/BonusGift.xls"; proc print data=bonus.Supplier; run;

Answer 310

libname bonus "&path/BonusGift.xls"; proc print data=bonus.'Supplier$'n; run;

Answer 311

The MERGE statement must refer to permanent data sets.

Answer 312

The variables in the BY statement can be in only one of the data sets.

Answer 313

Only two data sets can be specified in the MERGE statement.

Answer 314

When you use the MERGE statement with the BY statement, the data must be sorted or indexed on the BY variable.

Answer 315

if yellow=1 and purple=1 or pink=1;

Answer 316

if yellow=0 or purple=0 or pink=0;

Answer 317

if yellow=1 and purple=1 and pink=1;

Answer 318

if yellow=1 or purple=1 and pink=0;

Answer 319

libname mymusic 'Allmusic.xls';

Answer 320

libname mymusic 'C:\Entertainment\Allmusic.xls';

Answer 321

libname mymusic 'C:\Entertainment\Allmusic';

Answer 322

libname mymusic 'C:\Entertainment\Allmusic' filetype='excel';

Answer 323

data ensemble.merged; merge ensemble.spring(keep=blue) ensemble.summer; by fabric; run;

Answer 324

data ensemble.merged; merge ensemble.spring(blue=navy) ensemble.summer; by fabric; run;

Answer 325

data ensemble.merged; merge ensemble.spring(rename=(blue=navy)) ensemble.summer; by fabric; run;

Answer 326

(drop=ID Name Amount)

Answer 327

(output ID Name Amount)

Answer 328

(keep=ID Name Amount)

Answer 329

(in=ID Name Amount)

Answer 330

assignment

Answer 331

SAS data sets

Answer 332

the SAS registry

Answer 333

SAS catalogs

Answer 334

SAS programs

Answer 335

proc format lib=work cntlin=sasuser.citycode; run;

Answer 336

proc format lib=sasuser cntlin=citycode; run;

Answer 337

proc format lib=work cntlin=citycode; run;

Answer 338

work.formats→library.Prod→library.Newfmt

Answer 339

work.formats→library.formats→rpt.Formats→prod.Newfmt

Answer 340

rpt.Formats→prod.Newfmt→work.formats→library.formats

Answer 341

options fmtsearch=(sasuser);

Answer 342

options nofmterr;

Answer 343

options nofmterr fmtsearch=(work);

Answer 344

select geoarea. geopop.;

Answer 345

exclude geoarea. geopop.;

Answer 346

select $geoarea geopop;

Answer 347

exclude $geoarea geopop;

Answer 348

exclude $geoarea. geopop.;

Answer 349

FMTSEARCH=

Answer 350

orion.MyFmts only

Answer 351

work.formats→orion.MyFmts→library.formats

Answer 352

work.formats→library.formats→orion.MyFmts

Answer 353

orion.MyFmts→work.formats→library.formats

Answer 354

The output control data set enables you to output one value for one observation that contains the information about the format.

Answer 355

The output control data set enables you to output formats without writing VALUE statement in the PROC FORMAT step.

Answer 356

The output control data set contains information that describes formats. It is the data set that is created with the CNTLIN= option in the PROC FORMAT statement.

Answer 357

The output control data set contains information that describes formats. It is the data set that is created with the CNTLOUT= option in the PROC FORMAT statement.

Answer 358

SAS creates the format in the default work.formats directory and continues processing.

Answer 359

SAS substitutes the $w. or w. format and continues processing.

Answer 360

SAS stops processing and writes an error message to the log.

Answer 361

SAS skips processing at that step and continues with the next step, and writes a note to the log.

Answer 362

The FMTLIB option in PROC FORMAT prints information about all permanent formats in your SAS session.

Answer 363

The FMTLIB option in PROC FORMAT prints information about all of the formats in the work.formats catalog.

Answer 364

The FMTLIB option in PROC FORMAT prints information about all of the formats in the LIBRARY.FORMATS option.

Answer 365

The FMTLIB option in PROC FORMAT prints information about all formats in the catalog that is specified in the LIBRARY= option.

Answer 366

PROC CATMOD

Answer 367

PROC CATALOG

Answer 368

PROC CONTENTS

Answer 369

PUT statement

Answer 370

TITLE statement

Answer 371

FORMAT= option

Answer 372

FORMAT statement

Answer 373

value $country ' '='Not Available' other=[$country30.];

Answer 374

value $extra ' '='Not Available' other=[$country30.];

Answer 375

PROC SQL stops running only when SAS encounters a QUIT statement.

Answer 376

A PROC SQL step can contain more than one SELECT statement.

Answer 377

A PROC SQL step creates a report by default.

Answer 378

When you use PROC SQL to join tables, you do not need to presort the input tables

Answer 379

proc sql; from orion.donate select Employee_ID, Amount; quit;

Answer 380

proc sql; select Employee_ID, Amount from orion.donate; quit;

Answer 381

proc sql; select Employee_ID Amount from orion.donate; quit;

Answer 382

proc sql; select Employee_ID, Amount; from orion.donate; quit;

Answer 383

proc sql; create table clinic.bills; select ID, Date, Fee from clinic.admit; quit;

Answer 384

proc sql; create table clinic.bills as select ID, Date, Fee from clinic.admit; quit;

Answer 385

proc sql; select ID, Date, Fee from clinic.admit create table as clinic.bills; quit;

Answer 386

select Customer_ID, Country, Country_Name from orion.customer, orion.country where Country = Country;

Answer 387

select Customer_ID, Country, Country_Name from orion.customer, orion.country where customer.Country = country.Country;

Answer 388

select Customer_ID, customer.Country, Country_Name from orion.customer, orion.country where country.Country = customer.Country;

Answer 389

from school.register as r, school.students as s

Answer 390

from school.register as r, school.students s

Answer 391

from school.students as s, school.register as r

Answer 392

from school.students as s.students, school.register as r.register

Answer 393

FROM clause

Answer 394

RUN statement

Answer 395

QUIT statement

Answer 396

A second SELECT statement

Answer 397

Policy=Policy

Answer 398

claims.Policy=accounts.Policy

Answer 399

claims.Policy=insurance.Policy

Answer 400

insurance.Policy=insurance.Policy

Answer 401

only when querying one table

Answer 402

only when joining tables

Answer 403

one report that contains a Cartesian product

Answer 404

two reports that contain query results

Answer 405

two reports and two output data sets

Answer 406

No, because the FROM clause lists the tables in the wrong order.

Answer 407

No, because the input tables were not sorted first.

Answer 408

No, because some of the columns in the SELECT clause are not qualified.

Answer 409

No, because this program creates an output table instead of a report.

Answer 410

The SAS macro facility enables you to package text into units that have names.

Answer 411

The SAS macro facility enables you to improve your efficiency as a SAS programmer.

Answer 412

The SAS macro facility includes its own language, which is called the SAS macro language.

Answer 413

All of the above

Answer 414

SAS assigns names and values to automatic macro variables; the programmer assigns names and values to user-defined macro variables.

Answer 415

Neither automatic nor user-defined macro variables are part of a SAS data set.

Answer 416

Both automatic and user-defined macro variables can only have values that are text strings.

Answer 417

All of the above

Answer 418

proc print data=mydata; where sales >= &total; run;

Answer 419

proc print data=&mydata; run;

Answer 420

title 'Totals for &Month'; proc print data=mydata; run;

Answer 421

Value Length (missing value) 0

Answer 422

Value Length 12 2

Answer 423

Value Length 10+2 4

Answer 424

options &month; proc print data=&month; run;

Answer 425

%put &month;

Answer 426

options symbolgen; proc print data=&month; run

Answer 427

%put the macro variable Month has the value &month;

Answer 428

a. the SAS macro compiler

Answer 429

b. the SAS macro processor

Answer 430

c. the SAS macro debugger

Answer 431

d. the SAS macro language

Answer 432

The SAS macro facility enables you to reduce the amount of text you must enter in your programs

Answer 433

The SAS macro facility enables you to write programs that are easily modified and customized.

Answer 434

The SAS macro facility enable you to automatically reference system information in your programs.

Answer 435

all of the above

Answer 436

A SAS macro variable is a data set variable whose value depends on the observation that is being processed.

Answer 437

A SAS macro variable is independent of a SAS data set and contains a text string. The value of the macro variable remains constant until you change it.

Answer 438

title "June Totals as of &sysdate"; data sales.juntot; set sales.total; if month=6 and year=2008; run;

Answer 439

title "June Totals as of sysdate"; data sales.juntot; set sales.juntot; if month=6 and year=2008; run;

Answer 440

let rate="23";

Answer 441

&let rate=23;

Answer 442

%let rate=23;

Answer 443

%let rate="23";

Answer 444

Messages about macro variable resolution are listed in the program output.

Answer 445

Messages about macro variable resolution are suppressed in the program output

Answer 446

Messages about macro variable resolution are written to the SAS log.

Answer 447

Messages about macro variable resolution are suppressed in the SAS log.

Answer 448

Day=sysday;

Answer 449

Day=&sysday;

Answer 450

Day='&sysday';

Answer 451

Day="&sysday";

Answer 452

before compilation of the program

Answer 453

during compilation of the program

Answer 454

after compilation but before execution of the program

Answer 455

during execution of the program

Answer 456

total_sales

Answer 457

a. 1. Write a SAS program. 2. Debug or modify. 3. Run the program. 4. Review the results. 5. Define the business need.

Answer 458

b. 1. Define the business need. 2. Write a SAS program. 3. Run the program. 4. Review the results. 5. Debug or modify.

Answer 459

SAS programming code

Answer 460

data specific to SAS

Answer 461

an embedded Excel worksheet

Answer 462

Begin each statement in column one.

Answer 463

Put only one statement on each line.

Answer 464

Separate each step with a line space.

Answer 465

End each statement with a semicolon.

Answer 466

Put a RUN statement after every DATA or PROC step.

	Erstellt von Ismael Civicos vor mehr als 6 Jahre

Nächster

Isma1

Beschreibung

Zusammenfassung der Ressource

Frage 1

Frage 2

Frage 3

Frage 4

Frage 5

Frage 6

Frage 7

Frage 8

Frage 9

Frage 10

Frage 11

Frage 12

Frage 13

Frage 14

Frage 15

Frage 16

Frage 17

Frage 18

Frage 19

Frage 20

Frage 21

Frage 22

Frage 23

Frage 24

Frage 25

Frage 26

Frage 27

Frage 28

Frage 29

Frage 30

Frage 31

Frage 32

Frage 33

Frage 34

Frage 35

Frage 36

Frage 37

Frage 38

Frage 39

Frage 40

Frage 41

Frage 42

Frage 43

Frage 44

Frage 45

Frage 46

Frage 47

Frage 48

Frage 49

Frage 50

Frage 51

Frage 52

Frage 53

Frage 54

Frage 55

Frage 56

Frage 57

Frage 58

Frage 59

Frage 60

Frage 61

Frage 62

Frage 63

Frage 64

Frage 65

Frage 66

Frage 67

Frage 68

Frage 69

Frage 70

Frage 71

Frage 72

Frage 73

Frage 74

Frage 75

Frage 76