About Linlin

Linlin · ‎03-16-2012

from my log: 764 proc sql; 765 766 create table want as select * from have 767 768 where 769 770 intnx('month',today(),-3,'b') <= salesdate < intnx('month',today(),0,'b') 770! ; NOTE: Table WORK.WANT created, with 3 rows and 1 columns. 771 772 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

Linlin · ‎03-16-2012

Hi, I use libname to pull data from oracle database. If there is no difference between SQL pass through and Libname, then you can use proc sql: proc sql; create table want as select * from have where intnx('month',today(),-3,'b') <= salesdate < intnx('month',today(),0,'b'); quit; This is how I assign libname: libname yyyy oracle user="****" password="&pd" path="****" schema=****;

Linlin · ‎03-16-2012

data have; informat salesdate mmddyy10.; format salesdate mmddyy10.; input salesdate; cards; 12/1/2011 11/12/2011 1/1/2012 9/12/2011 2/29/2012 3/1/2012 ; proc print;run; data want; set have; if intnx('month',today(),-3,'b') <= salesdate < intnx('month',today(),0,'b'); proc print;run; Obs salesdate 1 12/01/2011 2 01/01/2012 3 02/29/2012

Linlin · ‎03-16-2012

Hi Haikuo, catx(' ','nmiss(',name,')as ' ) will create a string "nmiss(variable-name)". nmiss(variable-name) will create a number. maybe you treat "'nmiss(',name,') as' " "'nmiss(',name,') as'" It should be "'nmiss(',name,') as'"

Linlin · ‎03-16-2012

Is this helpful? data have; infile cards missover; input Name $ DOB :$10. (Add1 Add2 Addr3) (:$); cards; John 10/10/80 data data Alan 11/11/81 data Paul 10/10/79 data ; run; proc sql noprint; select catx(' ','nmiss(',name,') as',cat('n_missing_',name)) into : list separated by ',' from dictionary.columns where libname='WORK' and memname='HAVE'; quit; %put &list; 105 %put &list; nmiss( Name ) as n_missing_Name,nmiss( DOB ) as n_missing_DOB,nmiss( Add1 ) as n_missing_Add1,nmiss( Add2 ) as n_missing_Add2,nmiss( Addr3 ) as n_missing_Addr3

Linlin · ‎03-15-2012

Hi Art, I thought you wanted to show how to print all numeric or character variables between two variables. In the example below, the two outputs are different. Thanks -Linlin data class; set sashelp.class; age2=age; w2=weight; proc print data=class; title print out all numeric variables; var _numeric_; run; proc print data=class; title print out all numeric variables between name and weight; var name-numeric-weight; run;

Linlin · ‎03-15-2012

Great job PG! data All_Obervations; input order code $ x u; cards; 1 aaa 5 8 1 bbb 5 8 2 aaa 6 7 2 bbb 6 7 2 aaa 5 8 2 bbb 6 7 ; run; %macro test(y=,v=); PROC SQL; create table temp as SELECT DISTINCT cat(order, ' ', code) as ordername FROM All_Obervations WHERE X=&Y. AND U = &V.; QUIT; data _null_; set temp end=last; file "c:\temp\Test_&Y._&V..con" Lrecl=50000; if _n_ = 1 then do; put "TITLE=Test_&Y._&V."; put "DATA=&Y._&V..dat"; put '&END'; end; put ordername; if last then put "END NAMES"; run; %mend; %test(y=5,v=8)

Linlin · ‎03-15-2012

Maybe you need more than one macro variable? data test; input id name $; cards; 1 aaa 2 bbb 3 ccc ; proc sql noprint; select DISTINCT cat(id, ' ', name) INTO :list1 -:list3 from test; quit; %put &list1; %put &list2; %put &list3; Linlin

Linlin · ‎03-15-2012

another way: data have; input f2-f20; cards; 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ; proc transpose out=temp; var f:; run; data want (rename =v=_name_); set temp; v=(input(compress(_name_,'f','U'),2.)-1)*12; drop _:; proc print;run; Obs COL1 _name_ 1 2 12 2 3 24 3 4 36 4 5 48 5 6 60 6 7 72 7 8 84 8 9 96 9 10 108 10 11 120 11 12 132 12 13 144 13 14 156 14 15 168 15 16 180 16 17 192 17 18 204 18 19 216 19 20 228

Linlin · ‎03-15-2012

data _null_; x='p,q,r'; call symputx('m1',scan(x,1)); call symputx('m2',scan(x,2)); call symputx('m3',scan(x,3)); run; %put &m1 &m2 &m3;

Linlin · ‎03-14-2012

Yes. the output from my code is Obs name name1 1 A . 2 B . 3 C 1 4 D 2 The purpose of the code is to drop the variables that have no value. what SAS version do you use? I think 'cmiss' is only available for sas 9.2 and 9.3.

Linlin · ‎03-14-2012

how about: data have; input TimeInJobYears TimeInJobmonth; cards; 5 10 6 11 ; data want; set have; start_date=intnx('month',today(),-(12*TimeInJobYears+TimeInJobYears),'m'); format start_date mmddyy10.; run; proc print;run; TimeIn TimeIn Obs JobYears Jobmonth start_date 1 5 10 10/16/2006 2 6 11 09/15/2005

Linlin · ‎03-14-2012

you can run the code below to drop the variables with all missing values: data one; infile datalines missover; input name $ name1 name2 name3 name4 $; datalines; A . . . . B . . . . C 1 . . . D 2 . . . ; options missing= ' '; proc transpose data=one out=two; var _all_; run; options missing='.'; data _null_; length drop $500; if 0 then set one nobs=nvar; do until (done); set two end=done; if cmiss(of col:) eq nvar then drop=catx(' ',drop,_name_); end; call symputx('drop',drop); run; data want; set one (drop=&drop); run; proc print data=want;run; Linlin

Linlin · ‎03-14-2012

data have; input provtin noreadm yesreadm; cards; 1111 14 2 1112 17 4 1113 25 9 ; data want (drop=noreadm yesreadm); set have; array _col(2) noreadm yesreadm; do _n_=1 to 2; admission=vname(_col(_n_)); count=_col(_n_); output; end; run; proc print;run; Obs provtin admission count 1 1111 noreadm 14 2 1111 yesreadm 2 3 1112 noreadm 17 4 1112 yesreadm 4 5 1113 noreadm 25 6 1113 yesreadm 9

Linlin · ‎03-14-2012

data have; input column1 column2 column3; cards; 1111 14 2 1112 17 4 1113 25 9 ; data want (drop=column3); set have; array _col(2) column2 column3; do _n_=1 to 2; column2=_col(_n_); output; end; run; proc print;run; obs column1 column2 1 1111 14 2 1111 2 3 1112 17 4 1112 4 5 1113 25 6 1113 9

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

Conditionally deleting observation from dataset

Re: Conditionally deleting observation from dataset

Re: Conditionally deleting observation from dataset

Re: How to dynamically build output file?

Re: How to dynamically build output file?

Re: rename column in data step

PROC SQL Separated By

PROC SQL Separated By

Re: Rename an array of var names after a "Wide to Long" transpose

MACROS

How to dynamically build output file?

calculate start date based on two variables

How to dynamically build output file?

make columns different

make columns different