About sas_

sas_ · ‎03-14-2012

i am having a huge dataset with 200gb and having 100 variable ,now i want to drop 1 variable unused_trans, i can do by this way data tran_data(drop=unused_trans); set tran_data; run; is there any other way to drop the variable by using proc datasets or proc sql with out recreating the dataset

sas_ · ‎02-09-2012

but i am not getting the variable names if i wnat the variable names what should i do i have used put also.

sas_ · ‎02-09-2012

Thqs

sas_ · ‎02-09-2012

Hi i am having data but i wnat to export the data into text file but i want to give 3 delimeters ,how can i do it ,i have tested it but it was taking only one delimter. proc export data=test outfile="/tmp/mydata/test.txt" dbms=dlm replace; delimiter='^?/'; run;

sas_ · ‎02-07-2012

Q1. Is there any way to import HTMl file to sas Q2:What is the use of Trace ON and OFF in ODS outputs

sas_ · ‎01-29-2012

data test; input pk$ name$ no; cards; 1 a 10 2 a 12 3 a 13 4 b 15 5 b 16 6 c 17 I want to create 9 variables and move the obs like this if the name repeated 2 or 3 times this it should go to new variable like this In this bewlo example the name having a is repating 3 times and b is repating 2 times and name having c is only once like this i wnat the output pk name no pk2 name2 no2 pk3 name3 no3 1 a 10 2 a 12 3 a 13 4 b 15 5 b 16 6 c 17 If data is messy you can refer the text

sas_ · ‎01-27-2012

Hash Hi in my code i have created hash objects the data was huge as 15 crores and i need to create the 4 tables ,but i am getting memory issue.where the hash actually stores the files 2.I told that i have created 4 hash tables based on 4 varibale and the variable length is 100 i have give and the data in this variables will use 12 onlye ex: attrib x1 length 100$ the data that was used max was up to 12 only Ex:x1=hihru1234545 In this case the hash will creat the table for 100 lenght or for the length the variable that exactly used(12). If i reduce the length of variable used in the hash tables the memory will increase

sas_ · ‎01-10-2012

Hi i am having main table the incre table append to the main table but while appending to the Main table based on pid and dt it should remove the older one ex in main table pid a1 is there again in incr table again pid with a1 came but with diff no so it should append to main table and remove the older one based on date Main Table Pid no Dt a1 1 12jan2011 a2 2 12jan2011 a3 3 12jan2011 Incre Table Pid no Dt a1 5 18jan2011 a4 6 18jan2011 a5 7 18jan2011 Output Pid no Dt a1 5 18jan2011 a2 2 12jan2011 a3 3 12jan2011 a4 6 18jan2011 a5 7 18jan2011

sas_ · ‎12-27-2011

Thqs art it worked and i want to keep directly table 3 only and changed the logi in the join as done liket this i am getting the warning proc sql nowarn; create table table3 as select a.stdate, a.enddate, a.comm_cou from table1 as a right join table3 as b on a.stdate=b.enddate and a.comm_cou=b.comm_cou ; quit; WARNING: This CREATE TABLE statement recursively references the target table. A consequence of this is a possible data integrity problem. How can i supress the warning tryed to keep nowarn but not working

sas_ · ‎12-26-2011

I am having Table1 and Table2 i want Table3 as output.(I want the output in Table 3 as enddate of table2 =stdate of table1 to Table 3(AS Output)

sas_ · ‎12-26-2011

data Table1(drop=sdt edt); input sdt$ 1-9 edt$ 10-20 comm_cou; stdate =input(sdt,date9.); enddate=input(edt,date9.); format stdate enddate ddmmyy10.; cards; 12mar2011 13mar2011 usa 13mar2011 14mar2011 usa 14mar2011 15mar2011 usa 15mar2011 16mar2011 usa 16mar2011 17mar2011 usa 17mar2011 18mar2011 usa 18mar2011 19mar2011 usa 19mar2011 20mar2011 usa 20mar2011 21mar2011 usa 12mar2011 13mar2011 uk 13mar2011 14mar2011 uk 14mar2011 15mar2011 uk 15mar2011 16mar2011 uk 16mar2011 17mar2011 uk 17mar2011 18mar2011 uk 18mar2011 19mar2011 uk 19mar2011 20mar2011 uk 20mar2011 21mar2011 uk ; run; Table 2: 14mar2011 15mar2011 usa Table 3: 15mar2011 16mar2011 usa In the above table i am having the dates table_1 having the dates and comm_cou in table_2 i am having dates and commn country i wnat table_3 which is having enddate in table 2 and it should be stdate of table_1 only with one observation only.

sas_ · ‎12-26-2011

small query is there any thing that we can convert global to local macros

sas_ · ‎12-26-2011

Small need if indicator and is there it should move the dates having indicaotr=1 and No=2 only how can i do it data calendar_table(drop=sdt edt); input sdt$ 1-9 edt$ 10-20 Indicator NO; stdate =input(sdt,date9.); enddate=input(edt,date9.); format stdate enddate ddmmyy10.; cards; 12jan2011 13jan2011 1 2 13jan2011 14jan2011 1 4 14jan2011 15jan2011 2 3 15jan2011 16jan2011 1 4 16jan2011 17jan2011 1 4 17jan2011 18jan2011 2 5 ; run; data calendar_table need_table; set calendar_table; length path data $ 400; if indicator=1 and no=4 then do; path='c:\raw';data='order.txt'; output need_table;delete;end; output calendar_table; run; Req:2 )And i wnat to Edit the need_table and keep the dates if dates 12jan2011 13jan2011 are complted if needed i should call them again as per the logic the calendar_table does not hold these obs if once the date was crossed ,how can i do that. Reg:3) If need_table; are having dates sdate :15jan2011 and endate:16jan2011 dates in that table i will edit them and again move the date to 13jan2011 and 14jan2011 respectively again it should get the dates accordingly ... Thqs in advance

sas_ · ‎12-26-2011

I wnat to convert the local to gloabl and global to local macro variables can any one help me with some examples in the above i have tryed like this %macro a; %let loc=10; %put &loc; %mend; %a; %global &loc; Tryed %global loc; %put &loc; it should reove to 10 but it was not resloving

sas_ · ‎12-26-2011

data calendar_table(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 in 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

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

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

Finding obs in one table and output in another table

Convert local to global macro vice versa used %global

Re: Reg:The Dates to move day if job Runs

Convert local to global macro vice versa used %global

Reg:The Dates to move day if job Runs