About sas_

sas_ · ‎12-22-2011

data l(drop=sdt edt); input sdt$ 1-9 edt$ 10-20; stdate =input(sdt,date9.); enddate=input(edt,date9.); format stdate enddate ddmmyy10.; cards; 12jan2011 13jan2011 13jan2011 14jan2011 14jan2011 15jan2011 15jan2011 16jan2011 16jan2011 17jan2011 17jan2011 18jan2011 run; proc print; run; see actually i the above table i have the dates on which the loading to be happened In the second table in one cell i will have the Sdate and Edate so i want one table with one obs of date so that Ex: Table 2 Sdate Edate Path Data Fpath 12012011 13012011 c/raw/ order.txt c/raw/12012011/order.txt I want the dates to go to another table in the Infile path of the job i will give Fpath in the macro so that it will take data from there daily if the job again runs the date should increment so i will run for 13 date this is my aim for the loading data based on date Sdate Edate Path Data Fpath 13012011 14012011 c/raw/ order.txt c/raw/13012011/order.txt If it is messy refer the text file

sas_ · ‎12-21-2011

HI sharp how can we write this prxcahnge any information to write that

sas_ · ‎12-21-2011

Actually in the above table i will be having all the dates now i want another table having one obs i that i will give the raw file path and concatenate it with the dates and if again i rerun the job it should move to the next date and it will concatenate with the path.. Output in another table with single obs Raw path dt c:\raw 12012011 If i again rerun it the output with single obs table should be Raw path dt c:\raw 13012011

sas_ · ‎12-21-2011

Moving Data HI actually i am having dates in one table cal actually i am having stdate and enddate data l(drop=sdt edt); input sdt$ 1-9 edt$ 10-20; stdate =input(sdt,date9.); enddate=input(edt,date9.); format s1 E1 ddmmyy10.; cards; 12jan2011 13jan2011 13jan2011 14jan2011 14jan2011 15jan2011 15jan2011 16jan2011 16jan2011 17jan2011 17jan2011 18jan2011 run; Actually i want the dates to got to one table with single observation as i run that it should move to another date like that For Example the out put should be in another table with one obs so that i will resolve that date in a macro and will make the infile the date will be c:\raw\12012011\ so if i run that it will resolve to date 12012011 i will concatenae c:\raw\ to that if i again run the job it shoul go to 13012011 it will be c:\raw\13012011\ so if one single obs going to another table i will resove the date from that table

sas_ · ‎12-20-2011

i have checked by tranwrd it was not working

sas_ · ‎12-20-2011

data l2; infile cards expandtabs ; input id$ 1-57 ; id1=compbl(id); cards; user done ok ; run; Actually i want to replace tabs with space in the above from user to done there is tab and from done to k there is space i want to replace the tab with the space actually i have tryed it compbl,trim functions output user done ok

sas_ · ‎12-19-2011

Actually i am having data coming in text file the delimiter in ^ actually in some obs there is tab but it was removing the tab also now i want to replace tab with space below example data has tab between ra and if i run it was remoivng the tab and i wnat to replace it with spaces data l2; input id$ 1-7 age ; cards; ra ok 56 run; proc print; run;

sas_ · ‎10-22-2011

How can i compress special charaters in compress function not only the special charaters in the key board there are many special charcters that are coming in data any one can help

sas_ · ‎07-27-2011

options yearcutoff=1850; ihave declared this option now i want the set year to current i have kept options yearcutoff=; but not working...

sas_ · ‎07-25-2011

Hi i have created options obs=1 for some use now i want to make the obs= default options obs=1; data w1; input id; cards; 1 2 3 4 5 6 7 8 9 10 1 run; i have tryed to remove the options by giving obs=; by it was showing error i know the i can give max obs as 1099511627776 is the default but i want to make it to default..

sas_ · ‎07-06-2011

i wnat the month when the first payment and last payment is made i want them in to another varaibele in the output i have given the example as output

sas_ · ‎07-05-2011

Hi i am having data from jan08-----jul11 now i want the customers at which point he has started his payment and which is the last and if missed more that 3 months flag=0 i am giving for one year but i am having from jan08-jul11 ex data cou; input cus_id jan_08 feb_08 mar_08 apr_08 may_08 jun_08 jul_08 aug_08 sep_08 oct_08 nov_08 dec_08; cards; 1324 56 . . . 45 67 78 . . . . . 1256 . . . . 45 . 78 . . . . 78 run; output cus_id jan_08 feb_08 mar_08 apr_08 may_08 jun_08 jul_08 aug_08 sep_08 oct_08 nov_08 dec_08 fir_mon las_mon flag 1324 56 . . . 45 67 78 . . . . . jan_08 jul_08 0 1256 . . . . 45 . 78 . . . . 78 may_08 dec_08 0

sas_ · ‎06-22-2011

Try this data a2(keep=dt1 dt2); input dt$ 1-30; s1=scan(dt,1); s2=scan(dt,2); s3=scan(dt,3); s4=scan(dt,4); s5=scan(dt,5); dt1=trim(compress(s3||s2||s5)); dt2=input(dt1,date9.); format dt2 ddmmyy10.; cards; Wed May 18 16:58:32 2011 ; run; proc print; run;

sas_ · ‎06-21-2011

Hi I will be getting data daily in excel ,the data is placed in the server and the excel is placed on the each day folder like,10/02/2011,11/02/2011 the excel structure is the same for each day now i want to automate it and create sasdataset with the dates ex :Daily_10/02/2011 like that. how can i move from one folder to another folder

sas_ · ‎06-20-2011

Thqs

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

Reg:Droping variables

FOR EXPOTING IN TEXT with 3 Delimiters

FOR EXPOTING IN TEXT with 3 Delimiters

FOR EXPOTING IN TEXT with 3 Delimiters

Reg:import HTML Files

Reg:moving Obs

Hash Memory used the varible length kept are the data having in that v...

Keep the obs based on Date

Finding obs in one table and output in another table

Finding obs in one table and output in another table

Re: Replacing missing values by previous observation

Finding obs in one table and output in another table

Re: Reg:Moving of Date

Re: Reg Uncompressing Tab in the Data

Re: Reg:Moving of Date

Reg:Moving of Date

Reg Uncompressing Tab in the Data

Re: Reg Uncompressing Tab in the Data

Reg Uncompressing Tab in the Data

Reg: compressing specal characters

Reg Year Cutoff

Reg :Removing obs

Re: Reg:Count of obs and month

Reg:Count of obs and month

Re: 01JUN2011:00:00:00 Convert To SAS Date...

Reg:Upload data

Re: Reg:Date