About wutao9999

wutao9999 · ‎11-02-2016

I have a data set for cluster analysis. The code I used for the analysis is listed as below. My question is that: Assuming there are 100 data points in the data set, how can I define the minimum number of data points is clustered in each group? Right now, I see some cluster, outputted by the current method, only contains 1 data point in a cluster. This is why I am wondering if I can set a minimum number, such as the number of data points in a cluster must be more than 10% or 20%, etc. for example. Thank you for the help. PROC FASTCLUS DATA=model_data3 MAXC=3 MAXITER=100 REPLACE=FULL OUT=WORK.CLKMKMeansData ; VAR volume; RUN;

wutao9999 · ‎01-09-2016

For the data in the attached file, I used the below code to repull the data. However, the data has been cut off in the middle because the data in a row is too long. Is there a way to set some number such that the data is not cut off? Thank you for the help. data want ; length filename fn $200 ; infile 'C:\Users\*.txt' filename=fn eov=eov length=ll column=cc truncover ; fileno+1; do row=1 by 1 until (eov) ; do col=1 by 1 until (cc>ll); input num @ ; filename=fn ; output; end; input; end; run;

wutao9999 · ‎01-08-2016

data want_final; set want4; FILE='C:\Users\output\'|| file_name || '.xls' ; file OUT filevar=FILE mod dlm=' '; put file_name index num; run; I used the above code. However, ".xls" is not added into the file name. If I pre-add .xls to all file name, I was albe to create all individual .xls files with different names. However, the data of file_name, index, num are all sqeezed into one excel cell, instead of spreading into three cells in each row.

wutao9999 · ‎01-08-2016

sorry for misleading you. I mean output the data into txt file. When outputting, I prefer has no attribute name outputted to the txt file, just purely the data. Thank you.

wutao9999 · ‎01-08-2016

I have a SAS data as attached. I will need to input the data into three different txt files, each file contains the the data as below: for file: a.dat, it has 50 12 6 3053 2.5 66.3 for file b.dat, it has 78.1 2.4 4 49.2 455 Basically, I need to create different files based on the distinct attributes in file_name. Thank you for the help.

wutao9999 · ‎01-08-2016

I really love Tom's answer. So simple, but perfectly match my needs.

wutao9999 · ‎01-08-2016

I have a data file as attached. The below is the code to revise the data. data want; infile 'C:\Users\AAB006.txt' lrecl=30000; input; x=countw(_infile_); do i=1 to x; Num=scan(_infile_, i, " "); output; end; drop i x; run; My next challenge is that: There are thousands of such files in a folder. Is there way that the SAS code can automatically get the files' names, and process each of them automatically, rather than manually do it one by one. Appreciate your help.

wutao9999 · ‎01-08-2016

The post does not accept .dat format. Sorry for the trouble. Your help is greatly appricated. Tao

wutao9999 · ‎01-08-2016

I have many folders. In each of them, there are a number of files. Is there a quick way to get all file names automatically? For example, for the attached figure, I hope to get names, such as ABB006.dat, ABB0012.data, etc. Thank you.

wutao9999 · ‎01-08-2016

I have attached file with input data and expected output data. I have thousands of such files that have different length of such data, so it would be helpful if the code is not strict to a specific number of data. Appreciate your help.

wutao9999 · ‎01-08-2016

I have some irregular data in .dat file such as like below. I hope to search for a SAS code that can read the data sequentially, starting from 25, 6, then 6, then 1277, then 1.7, 31.4, 78.1, ....., etc. Is there any easy way to do that? 25 6 6 1277 1.7 31.4 78.1 2.4 0.2 0.2 0.4 0.4 0.4 0.2 0.3 0.4 0.3 0.3 0.3 0.3 0.3 0.3 0.2 0.3 0.3 0.2 0.3 0.3 0.2 0.4 0.3 0.2 0.2 47 159 48 1 45 177 83 121 50 31 164 121 135 157 54 167 64 21 43 149 30 165 173 96 167

wutao9999 · ‎07-09-2015

Up

wutao9999 · ‎07-08-2015

I have a boxplot procedure as below: graphics on; boxplot data = data_a; plot attri_1*attri_2/ boxstyle = SCHEMATIC horizontal nohlabel; ; graphics off; Two questions I have regarding the procedure: 1) The boxplot shows outliers using "circle" sign. What should I do to remove (not show) the outliers in the boxplot? 2) attri_2 is very long (more than 32 characters). What should I do to increase the character limit such that the entire name of attri_2 can show up in the boxplot? Thanks a lot for the response.

wutao9999 · ‎04-10-2015

In PROC GLM, can we set the intercept to be different for different groups? Another way I have been thinking is to add a dummy variable for different groups. Can the dummy variable account for the base differences for different groups?

wutao9999 · ‎04-10-2015

Sorry for mis-presenting the table. Coefficient A is different from Customer A listed in the table. We should change the A and B in the table to Customer_A and Customer_B.

Online Status	Offline
Date Last Visited	‎11-10-2016 09:50 AM

Cluster Analysis

data is cut off because it is too long in a row

Re: Output SAS data into various txt files

Re: Output SAS data into various txt files

Output SAS data into various txt files

Re: read multiple txt files automatically

read multiple txt files automatically

Re: read data from txt file

How to get complete file names in many folders

Re: read data from txt file

Re: How to get complete file names in many folders

Re: read multiple txt files automatically

Re: Error: A lock is not available for a table.

Re: Error: A lock is not available for a table.

Re: How to get top values that account for 90% of total

Cluster Analysis

data is cut off because it is too long in a row

Re: Output SAS data into various txt files

Re: Output SAS data into various txt files

Output SAS data into various txt files

Re: read multiple txt files automatically

read multiple txt files automatically

Re: read data from txt file

How to get complete file names in many folders

Re: read data from txt file

read data from txt file

Re: Character Truncation and Outlier Removal for PROC BOXPLOT.

Character Truncation and Outlier Removal for PROC BOXPLOT.

Re: Data Normalization

Re: Data Normalization