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

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

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

Question Posted / xxx

8 Answers
14932 Views
I also Faced
E-Mail Answers

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