read date from txt file

SASPhile — Wed, 09 Feb 2011 16:31:26 GMT

How to read date jan 2010 as 01-2010 from the following txt file?
S:\FSPR\TMOP\SAS\INFILES\txtfiles\Jan 2010 ZUD.txt

Re: read date from txt file

deleted_user — Wed, 09 Feb 2011 20:31:26 GMT

Hello,

If I understand it correctly, this may help you:

[pre]
%let test=%str(S:\FSPR\TMOP\SAS\INFILES\txtfiles\Jan 2010 ZUD.txt);

data _null_;
*begin reading from interior:
1. substract the last part of the string:
scan("&test",-1,'\'
2. find out the first blank in the extracted string (notice the use of 1- length("&test") which determines the function to look form right to left):
find(scan("&test",-1,'\'),' ',1-length("&test"))
3. Use the substr function to extract Jan 2010
4. You will get a character variable which has the value Jan 2010;
x=substr(scan("&test",-1,'\'),1,find(scan("&test",-1,'\'),' ',1-length("&test")));
*transform the character variable to numeric variable so you can output it with whatever format you want;
b=input(x,monyy8.);
put b mmyyd.;
run;

[/pre]

Marius

topic read date from txt file in SAS Programming

read date from txt file

Re: read date from txt file