set the values to missing

Reply
N/A
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: 8,815

Re: set the values to missing

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
N/A
Posts: 0

Re: set the values to missing

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,114

Re: set the values to missing

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
N/A
Posts: 0

Re: set the values to missing

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