In PROC PRINT, can you print only variables that begin with
the letter “A”?
Answers were Sorted based on User's Feedback
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 |
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 |
PROC PRINT DATA = X;
WHERE SUBSTR(NAME,1,1) = 'A';
RUN;
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / naveen
proc sql;
select *
from qqq
where name contains "A";
quit;
Is This Answer Correct ? | 0 Yes | 4 No |
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 |
what is snowflake schema? : Sas-di
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
What is the use of %include statement?
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?
What do you code to create a macro? : sas-macro
How would you compile all macros from a folder in a study, within the autoexec program?
wat has been most common programming mistake?
explain the difference between proc means and proc summary?
how to generate report for 0 observation dataset?
How to write duplicate records into a separate dataset using sort?
What do the SAS log messages "numeric values have been converted to character" mean?
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,