About Linlin

Linlin · ‎01-30-2012

Hi, Do you know Macro? is this helpful? data have; input flag; cards; 12 12 13 16 14 15 ; run; proc sql noprint; select distinct flag into :flags separated by ' ' from have; quit; %let flags=&flags; %macro test; %do i=1 %to %sysfunc(countw(&flags)); %let flag=%scan(&flags,&i); proc sql; create table want&flag as select * from sashelp.class where age=&flag; %end; quit; %mend; %test Linlin Message was edited by:Linlin

Linlin · ‎01-30-2012

Hi, You can use the code below to get rid of all the variables with missing value. data one; input var1-var5; cards; 1 . 3 . 4 2 . . 3 5 ; options missing= ' '; proc transpose data=one out=two; var _all_; run; options missing='.'; data _null_; length keep $500; if 0 then set one nobs=nvar; do until (done); set two end=done; if n(of col:) eq nvar then keep=catx(' ',keep,_name_); end; call symputx('keep',keep); run; data want; set one (keep=&keep); run; proc print data=want;run; Obs var1 var5 1 1 4 2 2 5 Linlin

Linlin · ‎01-30-2012

Hi Tom, I think that v1-v1000 are values of one variable of the OP's dateset, not v1-v1000 variables.

Linlin · ‎01-29-2012

another way: data test; input pk$ name$ no; cards; 1 a 10 2 a 12 3 a 13 4 b 15 5 b 16 6 c 17 ; data temp; set test; by name; count+first.name; run; proc sort; by count pk; proc sql noprint; select max(cct) into : max from (select count(*) as cct from temp group by name); quit; %put &max; %let max=%trim(%left(&max)); data want; set temp; by count; array p{*}$ pk1-pk&max; array n{*}$ name1-name&max; array o{*} no1-no&max; retain pk: name: no:; if first.count then ct=0; ct+1; p{ct}=pk; n{ct}=name; o{ct}=no; if last.count then do;output; call missing(of p{*} n{*} o{*});end; drop pk name no ct count; run; proc print;run; Obs pk1 pk2 pk3 name1 name2 name3 no1 no2 no3 1 1 2 3 a a a 10 12 13 2 4 5 b b 15 16 . 3 6 c 17 . . Linlin

Linlin · ‎01-29-2012

Thank you Mike. I will add a length statement next time. Linlin

Linlin · ‎01-29-2012

My friend took the base certification 4 years ago and passed the exam, the only material he used was the SAS certification prep guide. Good luck!

Linlin · ‎01-29-2012

Hi podarum, Please remembe to give people credit if they provide you with correct answer. Thank you! data have; input fsa$; cards; A0A A0B A0C M1P M2H N9Y ; data want; set have; postal=cats('fsa',_n_); proc print;run; Obs fsa postal 1 A0A fsa1 2 A0B fsa2 3 A0C fsa3 4 M1P fsa4 5 M2H fsa5 6 N9Y fsa6 Linlin

Linlin · ‎01-29-2012

data t; input m; cards; 5 4 11 ; data want; set t; retain k; k+m; run; proc print;run; Linlin

Linlin · ‎01-29-2012

data test; input pk$ name$ no; cards; 1 a 10 2 a 12 3 a 13 4 b 15 5 b 16 6 c 17 ; data want; set test; by name; count+first.name; run; proc transpose data=want out=temp1(drop=_name_) prefix=pk; var pk ; by count; run; proc transpose data=want out=temp2(drop=_name_) prefix=name; var name ; by count; run; proc transpose data=want out=temp3(drop=_name_) prefix=no; var no; by count; run; data final(drop=count); retain pk1 name1 no1 pk2 name2 no2 pk3 name3 no3; merge temp1-temp3; by count; proc print;run;

Linlin · ‎01-27-2012

try: ods listing; or ods html;

Linlin · ‎01-27-2012

How about: options nocenter; data have; input Student_Num $ Crstitle $ CourseNum Mark; cards; 1 aa 100 90 1 bb 200 100 1 aa 100 98 2 aa 100 90 2 bb 200 100 2 aa 100 98 3 aa 100 90 3 bb 200 100 4 aa 100 98 ; proc sort; by Student_Num Crstitle CourseNum; data want; set have; by Student_Num Crstitle CourseNum; if first.CourseNum and last.CourseNum then delete; proc print; title duplicate records by Student_Num Crstitle CourseNum; run; title Unique records by Student_Num Crstitle CourseNum; proc sql; select *,count(*) as total from have group by Student_Num, Crstitle, CourseNum having total=1; quit; title; duplicate records by Student_Num Crstitle CourseNum Student_ Course Obs Num Crstitle Num Mark 1 1 aa 100 90 2 1 aa 100 98 3 2 aa 100 90 4 2 aa 100 98 Unique records by Student_Num Crstitle CourseNum Student_Num Crstitle CourseNum Mark total ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ 1 bb 200 100 1 2 bb 200 100 1 3 aa 100 90 1 3 bb 200 100 1 4 aa 100 98 1 Linlin

Linlin · ‎01-27-2012

Nice. Thank you Tom.

Linlin · ‎01-27-2012

Thank you Haikuo! Another way: data have1; infile cards; input name $; cards; john tom Emily ; data have2; infile cards; input id; cards; 34 54 67 ; data want; set have1; do i=1 to 3; set have2 point=i; _n_=i; output; end; run; proc print;run;

Linlin · ‎01-26-2012

The code below generates 337 observations. the two observations with missing prev_cpn_date were exluded. proc sql; create table temp_lin as select prev_cpn_date format=mmddyy10.,pri_id,as_of_date format=mmddyy10.,SERIES_VALUE,(prev_cpn_date-as_of_date) as diff from FLoat_Leg_fr_GDR,lib3rate where prev_cpn_date GT as_of_date order by prev_cpn_date, diff,pri_id ; create table look as select prev_cpn_date as dd format=mmddyy10.,min(diff) as mdiff from temp_lin group by prev_cpn_date; create table final_lin (drop=diff dd mdiff) as select * from temp_lin as a,look where a.prev_cpn_date=look.dd and a.diff=look.mdiff; quit; proc print;run;

Linlin · ‎01-26-2012

How about: data have; input (AA BB cc) ($); cards; qw er ty cd rt ty ; proc print;run; proc sql noprint; select catx('=',name,lowcase(name)) into : names separated by ' ' from dictionary.columns where libname='WORK' and memname='HAVE'; quit; proc datasets lib=work nolist; modify have; rename &names; run; quit; proc print;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: Have PROC SQL within a Data Step??

Re: Dealing with missing obs - proc reg and proc calis

Re: sorting by columns

Re: Reg:moving Obs

how to assign sequential number vars to alpha vars

Base sas Cert

how to assign sequential number vars to alpha vars

how to get the variable that is based on cumulative sum of pervious ro...

Reg:moving Obs

HELP REGARDING PROC COMPARE

Re: finding duplicate records

Re: Merging data sets

Re: Merging data sets

Re: how to find closest match that is less than its date?

Change case of variable name