About Shortselling123

Shortselling123 · ‎02-10-2018

That is great. Thank you! Later one friend solved this problem for me by writing some python codes.

Shortselling123 · ‎02-09-2018

Thanks. Unfortunately I have thousands of such excels and it is very time consuming to change format manually.

Shortselling123 · ‎02-09-2018

Hi SAS experts: Is there anyway we can import excels into SAS when excels' format does not match the extension? See attached photo. I can open the excel by simply clicking "yes." Here is the SAS log: 2181 PROC IMPORT OUT=jpmorgan DATAFILE= "C:\Users\Research.xls" DBMS=xls REPLACE; 2181! GETNAMES=YES; RUN; Spreadsheet isn't from Excel V5 or later. Please open it in Excel and Save as V5 or later Requested Input File Is Invalid ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds Thank you!

Shortselling123 · ‎01-14-2018

Thanks! This is helpful!

Shortselling123 · ‎01-14-2018

Thanks! This is really helpful.

Shortselling123 · ‎01-14-2018

Right. Thanks! Not sure why Index did not work last time...

Shortselling123 · ‎01-13-2018

Hi SAS experts! I am wondering if there are some SAS functions that can tell me if one string variable contains another string variable? The "index" function can tell us whether one string variable contains a fixed string, but what if the string I am searching for is varying among different observations? For example: there are two variables: v1 and v2. V1 is a short string and v2 is a long string. V1 can be "sgd" and "kjh" And v2 can be "hdsgdk" and "ukjhso". Obviously v2 contains v1 for these two cases. Any SAS functions can help me with this? Thanks!

Online Status	Offline
Date Last Visited	‎02-21-2019 12:50 PM

Re: import excels whose format and extension don't match

Re: import excels whose format and extension don't match

import excels whose format and extension don't match

Re: One string variable contains another string variable?

Re: One string variable contains another string variable?

Re: One string variable contains another string variable?

One string variable contains another string variable?

Re: One string variable contains another string variable?

Re: One string variable contains another string variable?

Re: One string variable contains another string variable?

Re: import excels whose format and extension don't match

Re: import excels whose format and extension don't match

import excels whose format and extension don't match

Re: One string variable contains another string variable?

Re: One string variable contains another string variable?

Re: One string variable contains another string variable?

One string variable contains another string variable?