BookmarkSubscribeRSS Feed
sascodequestion
Fluorite | Level 6

data input;
input ID $ period amt;
cards;
X 201001 10000
X 201004 800
X 201006 200
Y 201101 100
Y 201102 100
Z 201201 .
Z 201202 .
Z 201203 .

;
run;

 

 

3 REPLIES 3
Astounding
PROC Star

Assuming that I understand what you want, here's one way:

 

data defaults;

set test1 (keep=id amt);

by id;

where amt > .;

if first.id;

rename amt=default_amt;

run;

 

data want;

merge test1 defaults;

by id;

if amt > . then default_amt = amt;

else amt = default_amt;

drop default_amt;

run;

 

It's untested, but looks like it should work just fine.

ballardw
Super User

Please repost your orginial question or a close version.

Without the question the response makes no sense.

Ksharp
Super User


data input;
input ID $ period amt;
cards;
X 201001 10000
X 201004 800
X 201006 200
Y 201101 100
Y 201102 100
Z 201201 .
Z 201202 .
Z 201203 .
;
run;
data want;
 merge input input(keep=id period 
 rename=(id=_id period=_period) firstobs=2);
 output;
 if id=_id then do;
  do i=period+1 to _period-1;
   period=i;output;
  end;
 end;
 drop _: i;
run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 815 views
  • 0 likes
  • 4 in conversation