About Mike_Davis

Mike_Davis · ‎08-21-2012

Thank you Art, base on your code,need is what I need: %let date=Jan1986; %let lowdate=Jan1900; %let update=Jan2112; data test8; date=symget('date'); xx=cats('01',date); need=input(xx,date9.); lowdate=symget('lowdate'); xx2=cats('01',lowdate); low=input(xx2,date9.); update=symget('update'); xx3=cats('01',update); up=input(xx3,date9.); if 0 lt need lt 55518 then put 'year of date between 1960 and 2112'; else put 'date illegal'; run; SAS code was updated by: Mike Davis

Mike_Davis · ‎08-21-2012

hi otarod03@nni.com, yu must had set receiving Email notification options and you specify you follow with Dr.Art. you should login to your account manager to do something. Thanj you Mike

Mike_Davis · ‎08-21-2012

Hello everyone, The following SAS code, why variable bbb can't be a date value like aaa? Thanks Mike %let date=Jan2011; data test; length xx $9; length xx3 $11; date=symget('date'); xx='01'||date; xx3=strip(quote(xx)); yy="'"||xx||"'"||"d"; *yy2="'"||"Jan2011"||"'"||"d"; *yy2_2="'"||"01Jan2011"||"'"||"d"; aaa="01Jan2011"d; bbb=xx3||'d'; yy3="01&date"d; run;

Mike_Davis · ‎08-20-2012

Hi Tom, The code has problem to run, 45 data _null; 46 length filename $200; 47 infile 'list.txt' filename=filename; 48 putlog filename=; 49 run; ERROR: Physical file does not exist, H:\list.txt. Thanks Mike

Mike_Davis · ‎08-20-2012

Hi Art, Yes I am using wondows Thanks Mike

Mike_Davis · ‎08-20-2012

Hello everyone, I am use SAS base,and I have a SAS program named "mysascode.sas", I wonder is that possible to create an executable file (its name is "mysascode.exe"(file's extension is .EXE)) from this SAS code? So when I run the .EXE file it will has the same functionality as I open SAS console and run "mysascode.sas", But the difference is the .EXE file will not show the content of the SAS code(hide the code). Thanks Mike

Mike_Davis · ‎08-20-2012

Hello everyone, How to use SAS searchingenginer to search a file's physical location? For example I have a file named "abc.txt", it locates at c:\myfile .I want to know what is the physical location of the file. Given I only know the file's name is "abc.txt" but I don't know where it is,...so how could I use searching enginer in SAS to get its location: "c:\temp"? Thanks Mike

Mike_Davis · ‎08-14-2012

Thank you , but errors happened when run the code data _null_ ; set xnames ; call execute( 'proc append base=work.' !! newName ); call execute( ' data= xl.' !! quote(trim(memname)) !! 'n ; run;' ); run ; ERROR: The value 'SHEET1$'n is not a valid SAS name Thanks

Mike_Davis · ‎08-14-2012

Thanks Ksharp, I had tried these options before I am sure this is not a new problem, if you could find an option like that would be fantastic! Thanks Mike

Mike_Davis · ‎08-13-2012

Thanks! Is there any help information I coud find for this solution? what does the "n" means? Thanks Mike

Mike_Davis · ‎08-13-2012

Thanks PG, but I don't have the permit to change the computer's setting,,,,,,so what I can do only is add an extra row on the top to define the columns' properties? Thanks Mike

Mike_Davis · ‎08-13-2012

Hello everyone, I have a Excel file named ALL, and sheet named SHEET1. Not like using proc import ,,,when I use libname to connect excel file to SAS such as: libname xl Excel "C:\Temp\ALL.xls"; I can get a SAS dataset xl.SHEET1. BUT if the first 8 obs of a column is empty, then this column will be set to length $1. and all the numeric value of this column will be set to empty. So if I still want to use libname I have to set a value in the first 8 obs. Please give me some suggestion on it! Thanks! Mike

Mike_Davis · ‎08-13-2012

Hello everyone, I have a excel file named all.xls, in the excel file there are three sheets named sheetone,sheettwo and sheetthree When after I use libname engine: libname xl "c:\temp\all.xls"; I can treat each individual sheet as SAS table. But the problem is the Sheet's name will be changed with an additional '$' symbol,,,,,sucha as sheetone will be changed to sheetone$. and I can open to preview the dataset but can't create other datast use this,such as if I use : data sheetone; set xl.sheetone$;/*I also try set xl.sheetone,still not work*/ run; this will cause error: ERROR: File XL.sheetone$.DATA does not exist. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. so how I cloud make use this dataset? Thanks Mike

Mike_Davis · ‎08-10-2012

I believe SAS web app should have more awesome functionality combine with java language in the near future. Thanks for the interesting topic.

Mike_Davis · ‎08-10-2012

Thanks a lot Mike

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: import an undifine-name file

How to import this file to SAS

Re: import an undifine-name file

import an undifine-name file

Question of SAS Map

Re: Do we need to create informat in data step?

Do we need to create informat in data step?

what is the location of styles?

what is the meaning of this SAS option?

Re: Problem use x command to open Excel

Re: Problem use libname with excel file

Truncated columns imported from excel

Re: Limitation of sql procedure macro

Re: call symput

Re: Could I purchase DI studio for my pc

Re: How to change a variable's length without change the position

Re: How to convert hexadecimal to character?

Re: call symput

Re: Problem of this export

how to write SAS code to search a file's location?

Re: SAS date value problem

Re: SAS date value problem

SAS date value problem

Re: how to write SAS code to search a file's location?

Re: how to write SAS code to search a file's location?

How to packup a SAS program

how to write SAS code to search a file's location?

Re: Problem use libname with excel file

Re: Problem of use libname to associate excel

Re: Problem use libname with excel file

Re: Problem of use libname to associate excel

Problem of use libname to associate excel

Problem use libname with excel file

Re: PUZZLE - finding anagram groups

Re: How to convert hexadecimal to character?