set the values to missing

Reply
Not applicable
Posts: 0

set the values to missing

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?
SAS Super FREQ
Posts: 9,365

Re: set the values to missing

Posted in reply to deleted_user
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
Not applicable
Posts: 0

Re: set the values to missing

Posted in reply to Cynthia_sas
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.
Trusted Advisor
Posts: 2,124

Re: set the values to missing

Posted in reply to deleted_user
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
Not applicable
Posts: 0

Re: set the values to missing

Thanks for all your help.
Ask a Question
Discussion stats
  • 4 replies
  • 454 views
  • 0 likes
  • 3 in conversation