topic Re: set the values to missing in SAS Health and Life Sciences

set the values to missing

deleted_user — Fri, 14 Mar 2008 16:52:49 GMT

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?

Re: set the values to missing

Cynthia_sas — Fri, 14 Mar 2008 18:08:23 GMT

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

Re: set the values to missing

deleted_user — Fri, 14 Mar 2008 19:06:27 GMT

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.

Re: set the values to missing

Doc_Duke — Fri, 14 Mar 2008 21:27:52 GMT

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

Re: set the values to missing

deleted_user — Mon, 17 Mar 2008 14:41:35 GMT

Thanks for all your help.