About Linlin

Linlin · ‎01-25-2012

How about: data have; input ID$ NAME $ MARKS ; cards; 100 SANJEEV 23 101 SRINATH 25 102 SRIHARI 28 ; data want; length name $ 8; set have end=eof; output; if eof then do; id='103'; name='SRIKANTH'; marks=30; output; end; run; proc print;run; Obs name ID MARKS 1 SANJEEV 100 23 2 SRINATH 101 25 3 SRIHARI 102 28 4 SRIKANTH 103 30 Linlin

Linlin · ‎01-25-2012

Hi Tom, I think your code should be: data have; input v @@; cards; 1 2 3 4 5 6 ; data want; set have; if V > 3 then do; C='Door3'; D= 'Window3'; end; else if V > 2 then do; C='Door2'; D = 'Window2'; end; else if V > 1 then do; C ='Door' ; D='Window'; end; run; proc print;run; Obs v C D 1 1 2 2 Door Window 3 3 Door2 Window2 4 4 Door3 Window3 5 5 Door3 Window3 6 6 Door3 Window3 Thank you! Linlin

Linlin · ‎01-24-2012

Is this helpful? data aa bb cc dd ee ff; do i=1 to 5; output; end; run; proc sql noprint; select memname into : dsns separated by ', ' from dictionary.tables where libname='WORK'; quit; %put &dsns; %MACRO Unite_Tables(&dsns) %MEND; Linlin

Linlin · ‎01-24-2012

if v>1 then do; c='Door'; d='window'; end; else do; c='Door2'; d='window2'; end;

Linlin · ‎01-24-2012

Do you want something like this? data have; input group $ :year; cards; A 2011 A 2011 A 2011 A 2011 A 2010 A 2010 A 2010 B 2011 B 2011 B 2011 B 2010 B 2010 B 2009 B 2009 ; proc sort data=have out=temp (where=(year in (2009,2010,2011))) nodupkey; by group year; data temp; set temp; by group; count + (-first.group*count) + 1; if count=3; proc sql; create table want as select * from have where group in (select group from temp) order by group, year; quit; proc print data=want; run; Obs group year 1 B 2009 2 B 2009 3 B 2010 4 B 2010 5 B 2011 6 B 2011 7 B 2011 Linlin

Linlin · ‎01-24-2012

please sort your data by Vendor_1 , then run proc tabulate. something like this: proc sort data=your_dataset out=temp; by vender_1; run; proc tabulate data=temp order=data;

Linlin · ‎01-24-2012

changing code to: proc tabulate data=test order=data;

Linlin · ‎01-24-2012

Hi Rick, there should be a ':' after 'output' in your code. %let analysis_date = "19dec2011"d; Data first_cpn_dt; input first_cpn_dt:mmddyy10.; format first_cpn_dt mmddyy10.; cards; 05/01/2010 06/15/2010 01/01/2007 07/16/2010 07/26/2010 09/01/2006 11/26/2010 12/01/2010 12/11/2009 12/14/2009 12/15/2010 ; data temp(drop=i); set first_cpn_dt; format t_incrt pre mmddyy10.; do i=1 to 999 ; t_incrt=intnx('month',first_cpn_dt,3*i); if t_incrt>&analysis_date then do; pre=intnx('month',t_incrt,-3); leave; end; end; proc print;run; first_ Obs cpn_dt t_incrt pre 1 05/01/2010 02/01/2012 11/01/2011 2 06/15/2010 03/01/2012 12/01/2011 3 01/01/2007 01/01/2012 10/01/2011 4 07/16/2010 01/01/2012 10/01/2011 5 07/26/2010 01/01/2012 10/01/2011 6 09/01/2006 03/01/2012 12/01/2011 7 11/26/2010 02/01/2012 11/01/2011 8 12/01/2010 03/01/2012 12/01/2011 9 12/11/2009 03/01/2012 12/01/2011 10 12/14/2009 03/01/2012 12/01/2011 11 12/15/2010 03/01/2012 12/01/2011 Linlin

Linlin · ‎01-23-2012

Hi Jamie, I have modified the code. We have a better solution by PAzevedo. /* add variable new_quote as a 5% price reduction for all products */ data have; input CUSTOMERID :QUOTENO :PRODUCTID :QUOTE :rank; cards; 5000 1 17 53.24 1 5000 1 18 55.27 2 5000 1 19 60.67 3 5000 2 17 44.96 1 5000 2 19 45.17 2 5000 2 20 49.27 3 6050 1 17 72.65 1 6050 1 19 77.45 2 ; run; data have1; set have; new_quote=quote*.95; run; proc transpose data=have1 out=look (drop=_name_ ) prefix=original_rank; by CUSTOMERID QUOTENO; var new_QUOTE; run; data want; merge have1 look; by CUSTOMERID QUOTENO; run; data want (keep=CUSTOMERID QUOTENO PRODUCTID QUOTE:rank); set want; quote1=quote; quote2=quote; quote3=quote; if rank=1 then quote1=original_rank1; if rank=2 then quote2=original_rank2; if original_rank2=. then quote2=.; if rank=3 then quote3=original_rank3; if original_rank3=. then quote3=.; run; data quote1; set want(drop=quote2 quote3); proc sort; by CUSTOMERID QUOTENO QUOTE1; data quote1; set quote1; by CUSTOMERID QUOTENO; if first.QUOTENO then rank1=1; output; rank1+1; proc sort; by CUSTOMERID QUOTENO rank; run; /***********************************/ data quote2; set want(drop=quote1 quote3); proc sort; by CUSTOMERID QUOTENO QUOTE2; data quote2; set quote2; by CUSTOMERID QUOTENO; if first.QUOTENO then rank2=1; output; rank2+1; proc sort ; by CUSTOMERID QUOTENO rank; run; /***********************************/ data quote3; set want(drop=quote2 quote1); proc sort; by CUSTOMERID QUOTENO QUOTE3; data quote3; set quote3; by CUSTOMERID QUOTENO; if first.QUOTENO then rank3=1; output; if quote3=. then rank3=.; else rank3+1; proc sort; by CUSTOMERID QUOTENO rank; run; data final(drop=new_quote); set quote1(rename=(quote1=new_quote rank1=new_rank)) quote2(rename=(quote2=new_quote rank2=new_rank)) quote3 (rename=(quote3=new_quote rank3=new_rank)) ; if new_quote=. then delete; if quote=new_quote then delete; run; proc sort ; by CUSTOMERID QUOTENO rank ; proc print;run; 5% reduction Obs CUSTOMERID QUOTENO PRODUCTID QUOTE rank new_rank 1 5000 1 17 53.24 1 1 2 5000 1 18 55.27 2 1 3 5000 1 19 60.67 3 3 4 5000 2 17 44.96 1 1 5 5000 2 19 45.17 2 1 6 5000 2 20 49.27 3 3 7 6050 1 17 72.65 1 1 8 6050 1 19 77.45 2 2

Linlin · ‎01-23-2012

data have; input region $ 1-4 amount 5-7; cards; east 100 150 165 west 230 430 230 ; data want (drop=hold); retain hold ; set have; if region ne ' ' then hold=region; if region eq ' ' then region=hold; run; proc print;run;

Linlin · ‎01-23-2012

data test; input zone $ state $ amount; cards; ZONE1 AP 121 ZONE1 KA 125 ZONE1 TM 129 ZONE1 UP 150 ZONE2 QW 130 ZONE2 VF 126 ZONE2 CV 129 ZONE2 LK 135 ZONE3 PL 123 ZONE3 NJ 165 ZONE3 OI 123 ZONE4 QA 176 ZONE4 UY 143 ; RUN; data want; set test; by zone; if first.zone then count=1;else count+1; if count=3; proc print;run; Obs zone state amount count 1 ZONE1 TM 129 3 2 ZONE2 CV 129 3 3 ZONE3 OI 123 3

Linlin · ‎01-23-2012

data test; input zone $ state $ amount; cards; ZONE1 AP 121 ZONE1 KA 125 ZONE1 TM 129 ZONE1 UP 150 ZONE2 QW 130 ZONE2 VF 126 ZONE2 CV 129 ZONE2 LK 135 ZONE3 PL 123 ZONE3 NJ 165 ZONE3 OI 123 ZONE4 QA 176 ZONE4 UY 143 ; RUN; data want; set test; by zone; if first.zone then delete; data want; set want; by zone; if first.zone; run; PROC PRINT; RUN; Obs zone state amount 1 ZONE1 KA 125 2 ZONE2 VF 126 3 ZONE3 NJ 165 4 ZONE4 UY 143 Linlin

Linlin · ‎01-22-2012

Hi Jamie, rank1 is the the new rank after changing the price of rank 1 product, and rank3 is the new rank after changing the rank 3 product. hope it helps. /* add variable new_quote as a 50% price reduction for all products */ data have1; set have; new_quote=quote*.5; run; proc transpose data=have1 out=look (drop=_name_ ) prefix=original_rank; by CUSTOMERID QUOTENO; var new_QUOTE; run; data want; merge have1 look; by CUSTOMERID QUOTENO; run; data want (keep=CUSTOMERID QUOTENO PRODUCTID QUOTE:rank); set want; quote1=quote; quote2=quote; quote3=quote; if rank=1 then quote1=original_rank1; if rank=2 then quote2=original_rank2; if original_rank2=. then quote2=.; if rank=3 then quote3=original_rank3; if original_rank3=. then quote3=.; run; data quote1; set want(drop=quote2 quote3); proc sort; by CUSTOMERID QUOTENO QUOTE1; data quote1; set quote1; by CUSTOMERID QUOTENO; if first.QUOTENO then rank1=1; output; rank1+1; proc sort; by CUSTOMERID QUOTENO rank; run; /***********************************/ data quote2; set want(drop=quote1 quote3); proc sort; by CUSTOMERID QUOTENO QUOTE2; data quote2; set quote2; by CUSTOMERID QUOTENO; if first.QUOTENO then rank2=1; output; rank2+1; proc sort; by CUSTOMERID QUOTENO rank; run; /***********************************/ data quote3; set want(drop=quote2 quote1); proc sort; by CUSTOMERID QUOTENO QUOTE3; data quote3; set quote3; by CUSTOMERID QUOTENO; if first.QUOTENO then rank3=1; output; if quote3=. then rank3=.; else rank3+1; proc sort; by CUSTOMERID QUOTENO rank; run; data final; merge quote1 quote2 quote3; by CUSTOMERID QUOTENO rank; run; proc print;run; Obs CUSTOMERID QUOTENO PRODUCTID QUOTE rank quote1 rank1 quote2 rank2 quote3 rank3 1 5000 1 17 53.24 1 26.620 1 53.240 2 53.240 2 2 5000 1 18 55.27 2 55.270 2 27.635 1 55.270 3 3 5000 1 19 60.67 3 60.670 3 60.670 3 30.335 1 4 5000 2 17 44.96 1 22.480 1 44.960 2 44.960 2 5 5000 2 19 45.17 2 45.170 2 22.585 1 45.170 3 6 5000 2 20 49.27 3 49.270 3 49.270 3 24.635 1 7 6050 1 17 72.65 1 36.325 1 72.650 2 . 1 8 6050 1 19 77.45 2 77.450 2 38.725 1 . . Linlin

Linlin · ‎01-22-2012

data have; infile datalines missover; input index zcta z1-z3; datalines; 1 35010 2 36830 36831 36832 36849 3 36507 36509 4 36502 run; data want(keep=index zcta); set have; array _n(*) zcta z1-z3; do i=1 to dim(_n) while (_n(i) ne .); zcta=_n(i); output; end; run; option nocenter; proc print;run; Obs index zcta 1 1 35010 2 2 36830 3 2 36831 4 2 36832 5 2 36849 6 3 36507 7 3 36509 8 4 36502 Linlin

Linlin · ‎01-21-2012

Hi Art, I made change to your code. " into :reorder separated by ' ' is not necessary. Thank you! proc sql; create table temp as select name from dictionary.columns where libname="SASHELP" and memname="CLASS"; proc transpose data=temp out=tocopy (keep=col:); var name; run; Linlin

Online Status	Offline
Date Last Visited	‎12-04-2020 11:18 PM

Re: How to put sas outputs into word file?

How to put sas outputs into word file?

Re: missing data

missing data

Re: Congratulations Fareeza!

Re: Capturing the last character in a variable value

Re: How to split one string into multiple rows?

Re: can't insert date macro into SQL

Re: Two consecutive visit records, Flag first record

Re: First and last day of month using Macros in proc sql

Re: How to count number of of call in the a week

Re: How to count number of of call in the a week

Re: Can someone help me with the following please?

Re: Can someone help me with the following please?

Re: Concatenate with CATX

Re: How to force two outputs from proc report on one page and keep dif...

Re: solution for loop

Re: I am trying to merge two files and don’t want to get rid of the du...

IN Dataset option

Re: convert month in num

Re: adding a row by using DATA step

Re: have AND in an IF/Else statement

Re: Passing an arbitrary number of parameters to a macro

Re: have AND in an IF/Else statement

Re: Subset data using 'by'

order in Proc Tabulate

order in Proc Tabulate

return a 3 month increment date column based on the date column that i...

Re: array of numbers longer than 8

FIRST. LAST. VARIABLES

FIRST. LAST. VARIABLES

Re: FIRST. LAST. VARIABLES

array of numbers longer than 8

data transformation: multiple columns to single column

Copying From SAS Column Titles to Excel