In PROC PRINT, can you print only variables that begin with
the letter “A”?

Answers were Sorted based on User's Feedback



In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / hsong001

Use the idea of variable list (varlist) wildcard :

e.g.,
proc print data=xxx ;
var A: ;
run ;
This will list all variables start with letter A.

Is This Answer Correct ?    16 Yes 6 No

In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / a

proc print data=;
where name like 'A%';
run;

Is This Answer Correct ?    3 Yes 3 No

In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / ashish

proc print data=datset(obs=5) ;
var s:;
quit;

Is This Answer Correct ?    0 Yes 0 No

In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / henry

proc print data=sashelp.class;
var height weight;
where upcase(substr(name,1,1))='A';
run;

Is This Answer Correct ?    1 Yes 3 No

In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / parbhat517

PROC PRINT DATA = X;
WHERE SUBSTR(NAME,1,1) = 'A';
RUN;

Is This Answer Correct ?    0 Yes 2 No

In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / naveen

proc sql;
select *
from qqq
where name contains "A";
quit;

Is This Answer Correct ?    0 Yes 4 No

In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / sunil chilaka

Dear fndz to print only variables that begin with
the letter "A" we can use

keep=option

Is This Answer Correct ?    2 Yes 7 No

In PROC PRINT, can you print only variables that begin with the letter “A”?..

Answer / naveen

proc print data=abc;
var name;
where name contains="A";
run;

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More SAS Interview Questions

what is snowflake schema? : Sas-di

0 Answers  


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

0 Answers  


What is the use of %include statement?

0 Answers  


Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

1 Answers   Icon,


What do you code to create a macro? : sas-macro

0 Answers  






How would you compile all macros from a folder in a study, within the autoexec program?

1 Answers  


wat has been most common programming mistake?

3 Answers  


explain the difference between proc means and proc summary?

0 Answers  


how to generate report for 0 observation dataset?

3 Answers   Mind Tree, Student,


How to write duplicate records into a separate dataset using sort?

4 Answers   HSBC,


What do the SAS log messages "numeric values have been converted to character" mean?

0 Answers   Quintiles,


What is shift table? have you ever created shift that?

2 Answers   Accenture, Clinical Research, Quintiles,


Categories