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 |
How substr function works in sas?
what is SAS OPTIMIZATION?
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
what is sas database server? : Sas-di
Define run-group processing?
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.
hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..
What data sets do you need to produce the report?
Difference between SAS STATA & SPSS?
if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually
Enlist the functions performed by sas.