About fengyuwuzu

fengyuwuzu · ‎01-20-2016

yes, they have the same structure. It is for the same data set in different months. I inserted my code which was used to read a single file, and it worked. Now I need to think about how to include 10, 11 and 12 three files.

fengyuwuzu · ‎01-20-2016

The code below works. But only for files 01-09. Is there a way to include 10, 11 and 12 in the same macro? %macro run_me; %let n=1; %do %while (&n <= 9); %let filein = xxxx20150&n..csv; data output&n; infile &filein; <data step--> run; %let n=%eval(&n+1); %end; %mend;

fengyuwuzu · ‎01-20-2016

I want to have 12 output data sets I was thinking about a do loop, but I do not know how to replace the 01, 02, ... 12 with the count variable

fengyuwuzu · ‎01-20-2016

for example, I want to read in these 12 files and output 12 new files: data work.datast01; infile "xxxx201501.csv" ...;

fengyuwuzu · ‎01-20-2016

I have 12 files, file name like "xxxx201501.csv", "xxxx201502.csv", ... "xxxx201512.csv" if I want to do the same opration on them, can I use a loop and macro varaible to do it? Thanks

fengyuwuzu · ‎01-15-2016

data WORK.test ; infile 'data.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; informat ID $40. ; informat CreatedDT anydttme. ; informat EndDT anydttme. ; informat PeriodInDays best32. ; informat PeriodType $14. ; format ID $40. ; format CreatedDT time11. ; format EndDT time11. ; format PeriodInDays best12. ; format PeriodType $14. ; input ID $ CreatedDT EndDT PeriodInDays PeriodType $ ; run; I am using the the above code to read in a csv file, with two time variables in the format like 12:02:27 AM. However, after reading in, these two variables have blank columns, and there is no error message in the log. can anyone give some hints? Thank you

fengyuwuzu · ‎01-14-2016

yes. thanks. this solved the problem.

fengyuwuzu · ‎01-14-2016

data WORK.Time ; infile 'Data.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ; format StartTime datetime. ; format ClosingTime datetime. ; input ID $12. StartTime :YMDDTTM. ClosingTime :YMDDTTM. Fee time=INTCK('minute',ClosingTime,StartTime); run; I tried to use the above code to input two time variables and calculate the interval between them. The time format was like 2014-01-01 02:56:37 and after reading into SAS, it is like 01JAN14:02:56:37 when I use time=INTCK('minute',ClosingTime,StartTime); but the INTCK function gave error: ERROR 22-322: Syntax error, expecting one of the following: a name, arrayname, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 76-322: Syntax error, statement will be ignored. when I use time = ClosingTime-StartTime; RROR: Missing numeric suffix on a numbered variable list (ClosingTime-StartTime). any hints?

fengyuwuzu · ‎01-13-2016

%macro both(ds1,ds2,ds3); proc sql; create &ds3. as select one.ID, one.Gender, one.ZIP, one.State, one.age from &ds1. as one, &ds2. as two where one.ID=two.ID; %mend; %put %both(data1,data2,test) I want to select the observations with same ID from two files, and because I need to do this repeatedly (I have 7 data sets), so I wrote the above macro. Howeverm when I called it using the %put statement, I got an error: ERROR 180-322: Statement is not valid or it is used out of proper order (create was underlined to indicate the error position). Why do I get this error? Can anyone kindly give me some hint if you know about it? Thanks!

fengyuwuzu · ‎01-11-2016

Thank you! This reply is very informative! I will look into the Proc HPCLUS which sounds very interesting.

fengyuwuzu · ‎01-08-2016

for K-means cluster analysis, one can use proc fastclus like proc fastclus data=mydata out=out maxc=4 maxiter=20; and change the number defined by maxc=, and run a number of times, then compare the Pseduo F and CCC values, to see which number of clusters gives peaks or one can use proc cluster: PROC CLUSTER data=mydata METHOD=WARD out=out ccc pseudo print=15; to find the number of clusters with pesudo F, t2 and ccc. and also look at junp in Semipartial R-Square. sometimes these indications do not agree to each other. which indicator is more reliable? Thanks!

fengyuwuzu · ‎01-08-2016

proc sql; select count(*) as N_obs from mydata where age >100; quit; this works

fengyuwuzu · ‎01-08-2016

proc sort data=mydata; by age; run; data count; set mydata; by age; zero=0; hundred=0; if age <0 then zero+1; else if age >100 then hundred+1; run; with above code, I can get zero and hundred as two new variables added in the data set. I actually only want to have a simple number of how many cases with age <0 and how many with age>100. How to do that? Thanks!

fengyuwuzu · ‎01-08-2016

Thank you, you are right. That's why I had many cases excluded in mean calculation.

fengyuwuzu · ‎01-08-2016

Thank you very much. I used where age >0 and age <100; and it worked. but when I use where age in (0:100) I had many cases not included. not sure why.

Online Status	Offline
Date Last Visited	‎08-14-2024 10:40 PM

calculated estimated survival rate at a certain time point (say, 18 mo...

Stratified analysis in non ITT population

Re: Proc import: how to add back blank values due to the same values a...

Proc import: how to add back blank values due to the same values as pr...

Re: Puzzled: Hazard ratio is 0 when both arms have events

Puzzled: Hazard ratio is 0 when both arms have events

Re: median survival not reached in proc lifetest when there are only 2...

Re: median survival not reached in proc lifetest when there are only 2...

Re: median survival not reached in proc lifetest when there are only 2...

median survival not reached in proc lifetest when there are only 2 pat...

Re: count events in one dataset between two visits in another dataset

Re: count events in one dataset between two visits in another dataset

Re: count events in one dataset between two visits in another dataset

Re: separate a string into two variables

Re: separate a string into two variables

ERROR: Some character data was lost during transcoding

hide the time and date on the rtf generated by ODS

proc sort and dupout: how to get the pairs of duplicates

converting numeric to character by put statement: how to avoid "." for...

Re: LOCF with visit missing in the data set

Re: batch process data files with contionout file names

Re: batch process data files with contionout file names

Re: batch process data files with contionout file names

Re: batch process data files with contionout file names

batch process data files with contionout file names

read in time format (like 12:02:27 AM)

Re: calculate a time interval using macro variables

calculate a time interval using macro variables

an error message in proc sql within a mcaro: not sure why

Re: how to determine the number of clusters in K-means cluster analysi...

how to determine the number of clusters in K-means cluster analysis

Re: count number of observations with certain values

count number of observations with certain values

Re: proc means with some conditions

Re: proc means with some conditions