vxhong17 Tracker

Re: Input an excel file!

vxhong17 — Fri, 30 Sep 2016 06:42:01 GMT

Hi Reeza,

Thank you so much for your comments,

I employed "proc import" to input excel files. A sample is here.

#VALUE!	9/9/1987	9/10/1987	9/11/1987
SAMSUNG ELECTRONICS - TOT RETURN IND	341.28	343.76	338.04
KOREA ELECTRIC POWER - TOT RETURN IND	NA	NA	NA
HYUNDAI MOTOR - TOT RETURN IND	428.57	430.72	418.21
HYUNDAI MOBIS - TOT RETURN IND	NA	NA	NA

My code is:

PROC IMPORT datafile= "&path.\test1.xlsx" DBMS=xlsx OUT=Outfile REPLACE;
           sheet = "sheet1";
           GETNAMES=No;
           datarow=2;
RUN;

I need to get variables var1-var4 in outfile to do other steps. However, in outfile, variables are A, B, C, D.

I can not use "infile" because I do not know how many variables in excel files.

Thank you so much,

Input an excel file!

vxhong17 — Fri, 30 Sep 2016 06:17:19 GMT

Dear SAS Experts,

Could you help me input an excel file with infile and outfile as in the attachment?

I need to input many excel files with different dates (over 10 years) and many variables. I only show a sample with three dates and one variable (Tot Return Ind).

Thank you so much for your help,

Re: Collapse one column into one row

vxhong17 — Sun, 18 Sep 2016 16:47:56 GMT

Hi Cynthia.

Thank you for your sugguestion,

Best,

Re: Collapse one column into one row

vxhong17 — Sun, 18 Sep 2016 16:42:12 GMT

Hi Tom,

Thank you so much for your detailed response !!!

Collapse one column into one row

vxhong17 — Sun, 18 Sep 2016 13:25:41 GMT

I have an input in excel like this

Symbol

KO:SGL

KO:KAW

KO:HDR

KO:NHN

KO:CLZ

KO:HYI

KO:HAC

KO:AMN

KO:SFC

KO:PIS

KO:KAM

KO:SHB

I want to have an output like this.

Symbol
KO:SGL, KO:KAW, KO:HDR, KO:NHN, KO:CLZ, KO:HYI, KO:HAC, KO:AMN, KO:SFC, KO:PIS, KO:KAM, KO:SHB

Do you know any way to do so?

Thank you,

Re: create a series of file names!

vxhong17 — Tue, 16 Aug 2016 23:39:42 GMT

Hi RW9,

I agree with you that it is easier to deal with one file rather than mutiple files.

I only showed an example from SAS. I did not provide all steps.

Thank you so much for your help,

Re: create a series of file names!

vxhong17 — Tue, 16 Aug 2016 15:44:49 GMT

Thank you so much for your advice. RW9

Actually, I need to export a very large dataset to txt files for my friend. He uses Matlab.

Thank you,

Re: create a series of file names!

vxhong17 — Tue, 16 Aug 2016 15:33:05 GMT

Thank you so much for your help, Astounding.

It works.

create a series of file names!

vxhong17 — Tue, 16 Aug 2016 14:21:06 GMT

The following is an example from SAS:

%macro create(howmany);

%do i=1 %to &howmany;

data month&i;

infile in&i;

input product cost date;

run;

%end;

%mend create;

%create(3)

I have about 1500 files. I want to create files with names such as

month0001; month0002; month0003; ..... month1949; month1950; rather than month1, month2, .... month1949, month1950.

Do you have any suggestions?

Thank you for your help,

Re: regression with separate coefficients for postitive and negative values

vxhong17 — Mon, 28 Jul 2014 18:49:05 GMT

Hi PGstats,

Thank you so much for your help,

Re: regression with separate coefficients for postitive and negative values

vxhong17 — Mon, 28 Jul 2014 18:32:18 GMT

Hi PGStats,

In the case that I want to run this regression for each company (company_ID), how cai I modify the code?

Thank you so much,

regression with separate coefficients for postitive and negative values

vxhong17 — Mon, 28 Jul 2014 09:18:28 GMT

Hi everyone,

I want to run regression a on b. However, I want to have separate coefficients for b+ (positive b) and b- (negative b).

Model is a = alpha + beta1*abs(b+) + beta2*abs(b-)

Thank you so much,

Re: read a text file from the census!

vxhong17 — Wed, 02 Apr 2014 19:50:28 GMT

Hi Richard,

Thank you so much for your help,

read a text file from the census!

vxhong17 — Mon, 31 Mar 2014 03:33:01 GMT

Hi everyone,

Could you let me know how to input the text file in the following link?

http://www.census.gov/population/metro/files/lists/historical/90mfips.txt

Thank you so much for your help,

Re: remove characters!

vxhong17 — Sun, 19 Jan 2014 22:13:07 GMT

Hi pradeepalankar, LinusH, and Varunlyer,

Thank you for your help!

remove characters!

vxhong17 — Fri, 17 Jan 2014 10:14:54 GMT

Hi Everyone,

I have one variable with the year. I want to remove the year. Could you let me know how to do so? Thank you!

For example,

Name

ABB3 (1942)

A12

A1E (2001)

AM2E (2012)

I want to have:

Name

ABB3

A12

A1E

AM2E

Re: Input data (.idx)

vxhong17 — Mon, 06 Jan 2014 20:51:42 GMT

Hi Tom,

Thank you so much,

Input data (.idx)

vxhong17 — Thu, 02 Jan 2014 22:36:11 GMT

Hello Everyone,

I want to input the table from the following link. Could you let me know how to input the table? Thank you so much,

ftp://ftp.sec.gov/edgar/full-index/1993/QTR1/master.idx

Re: Calculating Avearge values

vxhong17 — Mon, 17 Jun 2013 08:35:23 GMT

Hi debdippal,

Average = mean(Score_assignment, Score_quiz, Score_forum);

Re: delete a folder in a folder!

vxhong17 — Wed, 12 Jun 2013 20:24:15 GMT

Hi Reeza and Bruno,

Thank you so much for your suggestion!