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 |
Enlist the functions performed by sas.
firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?
For what purpose would you use the RETAIN statement?
i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set.
What is run-group processing?
Enlist the syntax rules followed in sas statements.
Why is SAS considered self-documenting?
In ARRAY processing, what does the DIM function do?
How to read the file names of a text files from a shared drive using SAS?
What are TEAEs
2 Answers Accenture, Quintiles,
Explain what is the use of proc gplot?