topic show for the same variable some observations as numeric and some as date in SAS Programming

show for the same variable as numeric or date

Sir_Highbury — Thu, 15 Dec 2016 16:16:52 GMT

Dear expert,

after some checks I get a data set with the following structure:

data b;
input type: $12. variable: $12. variable_min;
datalines;
date begin 2000
num price 3000
date end 2500
;run;

How can I show for the same variable (variable_min) in some cases (when type='date') as date and in some cases (when type='num') as numeric?

Thanks in advance, SH.

show for the same variable some observations as numeric and some as date

Sir_Highbury — Thu, 15 Dec 2016 16:15:56 GMT

Dear expert,

after some checks I get a data set with the following structure:

data b;
input type: $12. variable: $12. variable_min;
datalines;
date begin 2000
num price 3000
date end 2500
;run;

How can I show for the same variable (variable_min) in some cases (when type='date') as date and in some cases (when type='num') as numeric?

Thanks in advance, SH.

Re: show for the same variable some observations as numeric and some as date

gamotte — Thu, 15 Dec 2016 16:22:38 GMT

It depends on what you mean by "show". If you mean display in the log then you can

precise the display format in the put statement :

data b;
	input type: $12. variable: $12. variable_min;

	if type="date" then do;
		put variable_min= date6.;
	end;
	else do;
		put variable_min;
	end;

	datalines;
date begin 2000
num price 3000
date end 2500
	;
run;

Re: show for the same variable as numeric or date

ballardw — Thu, 15 Dec 2016 16:22:54 GMT

You would have to show the output you want for your example data? Do you want to create a new variable or are attempting to do the desired display in another procedure (unlikely to work).

Re: show for the same variable as numeric or date

RW9 — Thu, 15 Dec 2016 16:28:19 GMT

Have a character variable (only character can hol any value):

data b;
  length result $200;
  input type: $12. variable: $12. variable_min;
  select(type);
    when("date") result=put(variable_min,date9.);
    when("num") result=put(variable_min,best.);
    otherwise;
  end;
datalines;
date begin 2000
num price 3000
date end 2500
;
run;

Then put your number data in the correct text format.

Re: show for the same variable as numeric or date

LinusH — Thu, 15 Dec 2016 16:30:34 GMT

I assume that want to use different SAS format depending on the type variable. This has a question here from time to time, and cannot be done by standard means.
As a storage pattern it's not a favourite of mine, even if some industry data models have this construct.
Either way, the easiest way is to use a CHAR data type.

Re: show for the same variable some observations as numeric and some as date

ballardw — Thu, 15 Dec 2016 17:08:12 GMT

Repeating the question without additional information is not very helpful.

Re: show for the same variable some observations as numeric and some as date

Sir_Highbury — Fri, 16 Dec 2016 08:24:26 GMT

of course, sorry I did it by mistake.