topic Re: Splitting variables based on variable values in SAS Data Management

Splitting variables based on variable values

pmpradhan — Sat, 10 Nov 2018 18:31:27 GMT

I have a character variable 'Information' with the following values:

Information

120225

180619

Based on Information variable, I want to create two variables as follows:

Information Date

X1 .

. 120225

G8 .

. 180619

Please help!

Re: Splitting variables based on variable values

VDD — Sat, 10 Nov 2018 18:35:38 GMT

are you sure that you want the null values as the sample want has?

or do you want this

data have;
infile cards;
input Information $  Date;
cards;
X1
120225
G8
180619
;

Re: Splitting variables based on variable values

pmpradhan — Sat, 10 Nov 2018 18:38:23 GMT

Yes I want them as the null values as the sample want has.

Re: Splitting variables based on variable values

VDD — Sat, 10 Nov 2018 18:44:36 GMT

Here is one way to do that

data have;
infile cards;
input Information $;
output;
input Date;
information = .;
output;
cards;
X1
120225
G8
180619
;

Re: Splitting variables based on variable values

novinosrin — Sat, 10 Nov 2018 18:45:24 GMT

data have;
infile cards;
if mod(_n_,2) ne 0 then input Information $;
else input date;
cards;
X1
120225
G8
180619
;

Re: Splitting variables based on variable values

pmpradhan — Sat, 10 Nov 2018 18:52:12 GMT

Information is one of the many variables in my SAS dataset. The observations are more than couple hundreds. Is there something better than infile statement? where I don't have to enter the variable values?

Re: Splitting variables based on variable values

VDD — Sat, 10 Nov 2018 19:07:26 GMT

a larger sample representing what you have with more of the variables you are speaking about now. also at what point do the null values get reset based on your want sample that is unclear now since you say there are many variables.

Please don't play the part of a manager if your trying to learn to code.

this link may assist you

https://communities.sas.com/t5/New-SAS-User/Good-SAS-Course-in-Coursera/m-p/507864#M1531

the course if free in audit.

Re: Splitting variables based on variable values

novinosrin — Sat, 10 Nov 2018 19:03:48 GMT

I need a better and comprehensive sample to code and test rather than imagining what could be the likely

Re: Splitting variables based on variable values

novinosrin — Sat, 10 Nov 2018 19:49:19 GMT

Hi @pmpradhan try this

data have;
input Information $;
cards;
X1
120225
G8
180619
;

data want;
set have;
if anyalpha(information)=0 then date=input(information,yymmdd8.);
if date then call missing(information);
format date yymmdd8.;
run;

My assumptions:

Your source is a sas dataset

Date values are all numbers

Information value may be a mix of numbers/other chars