Answer Posted / chandrakanth

proc sql;
create table dataset-name as select distinct(variable-name),list-all-the-variables-you-want from dataset-name;
quit;

please let me know if you have any questions

What do you know about sas data set?

1182

---

how to generate the test data in sas without input data? : Sas-administrator

1172

---

Explain input and put function?

1184

---

Which statement does not perform automatic conversions in comparisons?

1853

---

describe about metadata object? : Sas-di

1120

---

why a stop statement is needed for the point= option on a set statement?

1130

---

Do you need to rearrange the order of the data for the report?

2359

---

what is snowflake schema? : Sas-di

1258

---

Of all your work, where have you been the most successful?

4714

---

Approximately what date is represented by the SAS date value of 730?

1269

---

how to change the execute of macro

2378

---

what is change analysis in sas di ? : Sas-di

1107

---

What is the good sas programming practices for processing large data sets?

1173

---

which features do you use to check the data validations and errors? : Sas-administrator

1091

---

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1148

---