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 can you improve the performance of a query, If it is excuting very slowly?
how many types of MERGE?
In sas, what are the areas that you are most interested in? : sas-grid-administration
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
what is factor analysis? : Sas-administrator
Explain what is the use of proc gplot?
What are the prime responsibilities of data integration administrator? : Sas-di
how do u validate sas program
what are the differences between proc report and proc tabulate?
what is the diff b/w verification validation in sas
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
Which is the best training Institute for SAS Business Intelligence course?