hi, how can i store the obs count of a dataset to a macro variable when i use proc datasets? i know i saw a sample of this code back then but now i couldnt find it anymore 😞 thanks a lot! ... View more

Hi all, i executed a rsubmit to create a table from dictionary.columns then tried to download the result to my local machine. however the result table returns 0 observations. am i doing something possible? the code goes like this: options comamid=tcp remote=mysvr; filename rlink '!SASROOT/connect/saslink/tcpunix.scr'; signon; libname mylib '/datasets' server=mysvr; rsubmit; libname mylib '/datasets'; endrusmbit; rsubmit; proc sql; create table mydict as select * from dictionary.columns where libname="mylib"; quit; proc download data=mydict out=mydict;run; endrsubmit; ... View more

data fa_sample; id = 1; valid_from = '01JAN2009:00:00:00'dt; valid_to = '02FEB2009:00:00:00'dt; format valid_from nldatm. valid_to nldatm.; run; data sp_sample; id = 1; valid_from = '01JAN2009:00:00:00'dt; valid_to = '31DEC9999:00:00:00'dt; format data sp_sample; modify sp_sample; put valid_to=; if _N_ = 1 then do; declare hash h(dataset:"fa_sample"); h.definekey("id","valid_from"); h.definedata("valid_to"); h.definedone(); end; rc = h.find(); put valid_to=; /* value is 02FEB2009:00:00:00 but when i'm viewing the dataset value is 31DEC9999:00:00:00 pa rin*/ replace; format valid_from nldatm. valid_to nldatm.; run; what am i doing wrong in my data steps? the dataset is not updated thanks a lot! 🙂 ... View more

hello, i have a macro variable n which has a value of 123414 / 6546434. then i execute a data step: data test; id = &n; run; it results to the quotient of 123414 and 6546434 i want to keep the value 123414 / 6546434 as is. I don't want it to be divided. what can i do? thanks! ... View more

hello i have a data set containing columns x y z. data set contains 10 records. i want to check if x has a value for each observation. however if all 10 records have a value of missing or 0 in x, i want to delete the column x. how can i do that? thanks! ... View more

hi is there a way to determine the current column being read by sas and the stop reading the current record and go to the next one? let's say main table contains 10 columns. i want to read only columns 1-5. and what if i want to read columns 1-5,then 6-10? data x; set main; . . run; thanks a bunch! ... View more

i want to get the status of my servers (object spawner, share server, etc) which resides in unix and transferring them to a windows client. code looks like this: rsubmit; filename mylog "../my.log"; proc printto log=myfile; x "../ObjectSpawner"; x "./ObjectSpawner.sh status"; proc download infile=mylog outfile="..\my.log";run; endrsubmit; this just returns to the log info about the execution of proc printto statement. what i want is to get also the message from the x command which prints the status of the server. can this be attained? or i'm just dreaming haha! thanks a lot! ... View more