About vxhong17

vxhong17 · ‎09-30-2016

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,

vxhong17 · ‎09-30-2016

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,

vxhong17 · ‎09-18-2016

Hi Cynthia. Thank you for your sugguestion, Best,

vxhong17 · ‎09-18-2016

Hi Tom, Thank you so much for your detailed response !!!

vxhong17 · ‎09-18-2016

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,

vxhong17 · ‎08-16-2016

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,

vxhong17 · ‎08-16-2016

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,

vxhong17 · ‎08-16-2016

Thank you so much for your help, Astounding. It works.

vxhong17 · ‎08-16-2016

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,

vxhong17 · ‎07-28-2014

Hi PGstats, Thank you so much for your help,

vxhong17 · ‎07-28-2014

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,

vxhong17 · ‎07-28-2014

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,

vxhong17 · ‎04-02-2014

Hi Richard, Thank you so much for your help,

vxhong17 · ‎03-30-2014

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,

vxhong17 · ‎01-19-2014

Hi pradeepalankar, LinusH, and Varunlyer, Thank you for your help!

Online Status	Offline
Date Last Visited	‎05-01-2018 11:27 AM

Re: Input an excel file!

Input an excel file!

Re: Collapse one column into one row

Re: Collapse one column into one row

Collapse one column into one row

Re: create a series of file names!

Re: create a series of file names!

Re: create a series of file names!

create a series of file names!

Re: regression with separate coefficients for postitive and negative v...

Re: Collapse one column into one row

Re: Input an excel file!

Input an excel file!

Re: Collapse one column into one row

Re: Collapse one column into one row

Collapse one column into one row

Re: create a series of file names!

Re: create a series of file names!

Re: create a series of file names!

create a series of file names!

Re: regression with separate coefficients for postitive and negative v...

Re: regression with separate coefficients for postitive and negative v...

regression with separate coefficients for postitive and negative value...

Re: read a text file from the census!

read a text file from the census!

Re: remove characters!