Exporting the data : As per the req i will create some dataset 10 to 1 crore and i wnat to export it to excel as xlsx is having a limit of 10,50,000(Approx 10 lac 50 thousand) and now i am doing manually and doing first obs and last obs and splitting the dataset to 10 lac and exporting it how can i do it automatically and it should make the count and export to xls if the count is 65 lacs it should go to 7 excels of 10 lacs each ... View more

i want to get one number for identical records and i want to get for the incremenatal runs alos i am having firstdataset firstdataset: name age a     10 b     10 c     11 d     11 e     12 output: name age  cluster_no a     10  1 b     10  1 c     11  2 d     11  2 e     12  3 For incremental data ---------------------- In this it should take the max of cluster_no+1 and should do the same if any of the records match with the existing records it should give the same cluster_no and the incremental data should append to the exsting data eample data for incrdataset name age e     13 f     12 g     14 h     14 Final output of both name age  cluster_no a     10  1 b     10  1 c     11  2 d     11  2 e     12  3 e     13  4(This should start with the max(cluster_no+1) f     12  3(As is was alredy assined in the first dataset) g     14  5 h     14  5 please help me in this ... View more

2012-07-11 09:43:20.55 i have used time part it was rouging the sec based on milli seconds i wnat the output to be Time ------ 09:43:20 ... View more

23june2012 11:12:34:45 I am ahving a char variable i want the date time with nano secs in one variable and date in another variable output date                                  time 23june2012                11:12:34:45 ... View more

tt I want to Rename the variable names by using macro from dataset l2 and dataset x variable names should change in the order they are but when u do the folloiwng macro the renaming is happening but in different order,in the macro it was sorting and changing the order how can i do it. Log: NOTE: Renaming variable v to b2. NOTE: Renaming variable x2 to s3. NOTE: Renaming variable z3 to z. But it should be : varible v to z varible x2 to b2 varible z3 to s3 data l2; input z b2 s3; cards; 1 2 3 run; data x; input v x2 z3; cards; 1 2 3 run; proc sql noprint; select nvar into :num_vars from dictionary.tables where libname="WORK" and memname="L2"; quit; proc sql; select distinct(name) into :var1- :var%TRIM(%LEFT(&num_vars)) from dictionary.columns where libname="WORK" and memname="L2"; quit; %put &num_vars; proc sql noprint; select nvar into :s2num_vars from dictionary.tables where libname="WORK" and memname="X"; quit; proc sql; select distinct(name) into :Svar1- :Svar%TRIM(%LEFT(&s2num_vars)) from dictionary.columns where libname="WORK" and memname="X"; quit; %put &s2num_vars; %MACRO RENAME(DSN=); proc datasets library=WORK; modify &DSN; rename %do i=1 %to &num_vars; &&Svar&i=&&var&i. %end; ; quit; %MEND; %RENAME(DSN=X); ... View more

I wnat to move all the data in to FInal_DATA variable if the data is . or blank in id variable with separated by | data l2; infile cards missover truncover; input id id2$ id3$ id4$ id5; cards; . a b c . .       . 1 q w e 2 run; output id id2 id3 id4 id5 FInal_DATA . a b c . .       .       .||||. 1 q w e 2 ... View more

data l; input id $ 1-20; cards; aaaa1234a bbbb1234b ccccx1234c asdf1234b run; I dont want to do by substr(1,1)=substr(2,1) i want the output if the first character and last are same output : ccccx1234c asdf1234b ... View more