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?
Answers were Sorted based on User's Feedback
Answer / sasuser
Ans: I didn't understood the question clearly. What I
understood is , the person wants to copy selected variables
from a dataset(which has no observations) to a different
dataset.The following is the solution:
proc sql;
create table want
like emptydataset (keep=n: a:)
;
quit;
Note:emptydataset does not contain any obs.
Let me know, If my solution is wrong.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / alok karan
data _null_ new;
set qqq;
where name like "q%" or name like "w%";
put name total;
run;
proc print data=new;
run;
| Is This Answer Correct ? | 0 Yes | 2 No |
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
how can u join the two tables without using proc sql Joins and nested queries ?
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
Name statements that function at both compile and execution time?
what is the difference between infile and input? : Sas-administrator
what other sas products have you used and consider yourself proficient in using? : Sas programming
What is the Program Data Vector (PDV) and What are its functions?
What do you feel about hardcoding?
How would you code a merge that will keep only the observations that have matches from both sets?
explain the key concept of sas? : Sas-administrator
SAS using companies in chennai
How many data types are there in SAS?