About Linlin

Linlin · ‎09-08-2018

Hi VDD, Thank you for your quick reply! when I run the code below I would like the outcome of proc freq going to the word file directly, so I don't have to type in the numbers. proc freq data=have; tables hypertension/missing; where group=1; run; group=1 group=2 Hypertension Yes 3/9 (33%) 3/9 (33%) xx/xx (xx) xx/xx (xx) xx/xx (xx) No 3/9 (33%) 3/9 (33%) xx/xx (xx) xx/xx (xx) xx/xx (xx) Missing 3/9 (33%) 3/9 (33%) xx/xx (xx) xx/xx (xx) xx/xx (xx)

Linlin · ‎09-08-2018

Hi All, How to write sas output into word file? Thank you very much for your help! data have; input group hypertension; cards; 1 1 1 0 1 . 1 1 1 0 1 . 1 1 1 0 1 . 2 1 2 0 2 . 2 1 2 0 2 . 2 1 2 0 2 . ; proc print;run; group1 group2 group3 group4 Total Smoking Status Never 270/603(45%) 231/457(51%) 235/603(39%) 202/457(44%) 724/2120(34%) Past 275/603(45%) 201/457(44%) 309/603(51%) 225/457(49%) 1018/2120(48%) Current 47/603(8%) 19/457(4%) 35/603(6%) 17/457(4%) 118/2120(6%) Missing 11/603(2%) 6/457(1%) 24/603(4%) 13/457(3%) 268/2120(12%) Physical Activity Yes xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) No xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) Missing xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) Hypertension Yes xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) No xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) Missing xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx) xx/xx (xx)

Linlin · ‎11-04-2015

Hi Haikuo, Art, and PG, Thank you very much for your great help!! I miss you guys too. Best wishes! Linlin

Linlin · ‎11-03-2015

Hi All How could I get dataset WANT from HAVE? Thank you! data have; input id$ count var1; cards; aa 1 20 aa 2 . aa 3 30 bb 1 10 bb 2 . bb 3 . bb 4 20 cc 1 10 cc 2 . cc 3 30 cc 4 . cc 5 50 ; data want; id count var1 aa 1 20 aa 2 25 aa 3 30 bb 1 10 bb 2 15 bb 3 15 bb 4 20 cc 1 10 cc 2 20 cc 3 30 cc 4 40 cc 5 50

Linlin · ‎01-05-2015

Too bad Art is the top poster again! Happy New Year everyone!

Linlin · ‎06-23-2014

data have; input lpct; cards; 1 2 2.5 30 8 ; data want; set have; if first(reverse(lpct)) in ('0','5') then rounded=1; else rounded=0; proc print;run;

Linlin · ‎06-19-2014

data a; length a $5; a='a,b'; output; a='c,d,e'; output; data want; set a; length b $1; i=1; do while (scan(a,i) ne ' '); b=scan(a,i); output; i+1; end; keep b; proc print;run;

Linlin · ‎06-04-2014

Reeza is She.

Linlin · ‎05-20-2014

example: data have; input id vismon alt; cards; 1 1 0 1 4 0 2 60 0 2 72 1 2 84 1 2 96 1 ; data want; set have; length new $1; by id alt; if alt=1 and first.alt and not last.alt then new='Y'; proc print;run;

Linlin · ‎05-19-2014

tested: Proc Sql; Create table work.want as Select * from Work.have Where report_date between intnx('month',%sysfunc(inputn(&month_key,yymmn6.)),0,'b') and intnx('month',%sysfunc(inputn(&month_key,yymmn6.)),0,'e'); Quit; or Proc Sql; Create table work.want2 as Select * from Work.have Where report_date between intnx('month',input("&month_key",yymmn6.),0,'b') and intnx('month',input("&month_key",yymmn6.),0,'e'); Quit;

Linlin · ‎05-19-2014

data have; input Account_id Report_date : date9.; format report_date date9.; cards; 1 12JUN2013 2 17JAN2014 3 19MAY2014 ; %let month_key=201405; Proc Sql; Create table work.want as Select * from Work.have Where year(report_date)=%substr(&month_key,1,4) and month(report_date)=%substr(&month_key,5); Quit;

Linlin · ‎05-16-2014

you could create a macro: data have; input date mmddyy10.; format date mmddyy10.; cards; 1/1/2001 2/1/2001 1/1/2002 1/1/2006 ; proc sql noprint; select distinct year(date) into :year separated by ' ' from have; quit; %macro test; %do i=1 %to %sysfunc(countw(&year)); %let n=%scan(&year,&i); data have&n; set have(where=(year(date)=&n)); run; %end; %mend; %test

Linlin · ‎05-16-2014

example: proc sql noprint; select max(weight) , min(weight) into :max_wt,:min_wt from sashelp.class; quit; %put &max_wt; %put &min_wt;

Linlin · ‎05-16-2014

Art, To rename "test00502.xlsx" to "test140502.xlsx", I changed your code to: %let dir=c:\temp\; filename x pipe "dir &dir.*.xlsx /b"; data test; infile x length=len; input name : $varying40. len; if length(scan(name,1,'.'))=9 then do; oldname=catt("&dir.",name); newname=catt("&dir.test",'14',substr(name,6)); rc=rename(oldname, newname, 'file'); end; run; obs name oldname newname rc 1 144est0050200000000.xlsx . 2 Copy . 3 test00502.xlsx c:\temp\test00502.xlsx c:\temp\test140502.xlsx 0

Linlin · ‎05-16-2014

Hi Art, log file from your code: NOTE: SAS initialization used: real time 11.77 seconds cpu time 1.40 seconds 1 %let dir=c:\temp\; 2 3 filename x pipe "dir &dir.*.xlsx /b"; 4 5 data _null_; 6 7 infile x length=len; 8 9 input name : $varying40. len; 10 11 if len=10 then do; 12 13 oldname=catt("&dir.",name); 14 15 newname=catt("&dir.",'14',substr(name,2)); 16 17 rc=rename(oldname, newname, 'file'); 18 19 end; 20 21 run; NOTE: The infile X is: Unnamed Pipe Access Device, PROCESS=dir c:\temp\*.xlsx /b,RECFM=V, LRECL=256 NOTE: 3 records were read from the infile X. The minimum record length was 8. The maximum record length was 17. NOTE: DATA statement used (Total process time): real time 0.40 seconds cpu time 0.03 seconds

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: 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: First and last day of month using Macros in proc sql

Re: Is it possible to make a list in macro statements?

Re: Look up values

Re: Renaming the files in folder

Re: Renaming the files in folder