set the values to missing

[deleted_user]

Hi,
I am new to SAS & want some help regarding this. I want to create a refdata from the original datasets. The refdata should have only one observation with all the values of the variables is set to missing, and so it shows only the data type. So how is this acheived?

[Cynthia_sas]

Hi:
Perhaps you just want a PROC CONTENTS variables list:

[pre]
proc contents data=sashelp.class;
title 'What are the Variables in SASHELP.CLASS?';
run;
[/pre]

cynthia

[deleted_user]

Thanks Cynthia.

But Proc content displays only the list of the variables.

What I wanted is how do I change the vaules of each variables in each dataset to missing so that I have only empty datasets just with Attirbutes? This is needed for comparing the datasets. I have around 25 datasets, so I need to cut down the time of doing it one by one.

Anyways, thanks for your help.

[Doc_Duke]

To compare data set attributes, youo coul dyse PROC COMPARE and tell it to suppress the record-level comparisons.

You could also use PROC CONTENTS and output the data structure and then use PROC COMPARE on the results.

Doc

[deleted_user]

Thanks for all your help.