1.

Table Name – Clinical

Answer»

Format for creating a simple index -

Data <dataset_name> (INDEX = (<variable-name></UNIQUE></NOMISS>)) Creating a single index in one go Example : data a(index=(seq /unique /nomiss));                                Set a;   RUN; Creating multiple indexes in one go Example: data a(index =(seq /unique /nomiss                                                       State /unique                                                        YEAR /unique /nomiss)                               Set a;  Run; Format for creating a COMPOSITE index- Data <dataset_name> (INDEX = (index-name = <var1 var2 etc></UNIQUE></NOMISS>))               Creating a composite index – Example – data a(index=(quarter_month = (quarter month) /nomiss)                                Set a;                                Run;

Note: We can also use the proc’s to create the indexes in the newly generated output DATASETS.

Additionally, we COULD also use the proc datasets procedure and proc SQL to generate indexes.


Discussion

No Comment Found

Related InterviewSolutions