topic Re: I have data as below how can I retain it? in New SAS User

I have data as below how can I retain it?

rajeshalwayswel — Tue, 14 Jan 2020 03:41:54 GMT

DATA HAVE;
INPUT VISIT $10. VISITNUM;
CARDS;
VISIT 1      1
VISIT 1      1
VISIT 1      1
VISIT 1      1
UNSCH        999
UNSCH        999
RUN;

Required Output:

VISIT        VISITNUM   VISIT_                            VISITNUM_
VISIT 1      1                 VISIT 1                                 1
VISIT 1      1                 VISIT 1   		                  1
VISIT 1      1                 VISIT 1 			          1
VISIT 1      1                VISIT 1  		                  1
UNSCH        999       UNSCH VISIT 1 999.001      999.001
UNSCH        999       UNSCH VISIT 1 999.002      999.002

Re: I have data as below how can I retain it?

mkeintz — Tue, 14 Jan 2020 03:45:49 GMT

What are the rules you want to implement?

Re: I have data as below how can I retain it?

rajeshalwayswel — Tue, 14 Jan 2020 03:48:56 GMT

In new variables Visit_, Visitnum_.

Re: I have data as below how can I retain it?

rajeshalwayswel — Tue, 14 Jan 2020 03:54:27 GMT

When visit=UNSCH value I need to retain before value and concatenate it by "UNSCH", Visit variable value

Re: I have data as below how can I retain it?

mkeintz — Tue, 14 Jan 2020 04:06:09 GMT

@rajeshalwayswel wrote:
In new variables Visit_, Visitnum_.

That's not a rule. It's an example. You post

VISIT        VISITNUM   VISIT_                            VISITNUM_
VISIT 1      1                 VISIT 1                                 1
VISIT 1      1                 VISIT 1                     1
VISIT 1      1                 VISIT 1           1
VISIT 1      1                VISIT 1                   1
UNSCH        999       UNSCH VISIT 1 999.001      999.001
UNSCH        999       UNSCH VISIT 1 999.002      999.002

It doesn't answer these questions:

Do you only have two types of records?
1. type 1: VISIT="VISIT 1", and VISITNUM=1
  and
2. type 2: VISIT=UNSCH and VISITNUM=999
If you really only have these two types, it appears that for type 1, VISIT_=VISIT and VISITNUM_=VISITNUM, right?
But for VISITNUM=999, you have VISITNUM_ as a sequence (999.001,999.002). If you have subsequent "VISIT 1" records, followed by another 999 record, does that record become 999.003, or do you restart at 999.001?
How does UNSCH become UNSCH VISIT 1? Does the "VISIT 1" part come from retaining the preceding "VISIT 1" value (i.e. the most recent non-UNSCH value for VISIT?), or is it a constant value that you always insert in such a case?