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



i have a null dataset with 20 variables. i want to upload the variables which contain name like a ..

Answer / xxx

proc print data=DSN;
var a: k:;
run;

Is This Answer Correct ?    6 Yes 1 No

i have a null dataset with 20 variables. i want to upload the variables which contain name like a ..

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

i have a null dataset with 20 variables. i want to upload the variables which contain name like a ..

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

Post New Answer

More SAS Interview Questions

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  


What is the difference between an informat and a format. Name three informats or formats.

6 Answers  


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

0 Answers  


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

0 Answers  


What do the SAS log messages "numeric values have been converted to character" mean?

0 Answers   Quintiles,


How many versions came upto now in SAS?

3 Answers   CTS, TCS,


sas implimented companies in hyderabad

11 Answers   CTS, HSBC,


% let A=3+4 what is result

4 Answers   Satyam,


What is the basic structure of the SAS base program?

0 Answers  


how to import HTML files into SAS datasets?

3 Answers   HP,


how to intersect the tables by using PROC MIXED?

1 Answers   CitiGroup,


What do the mod and int function do? : Sas programming

0 Answers  


Categories