Hi i am having 200 datasets with name like daily1--daily200 ,in each dataset there will be one date by name ins_date ,now i want to create a new dataset with all the dataset name and the ins_date and counts of obs in that datasets ,i want one row for each dataset like having datasetname,ins_date and count,the ins_date is the same for each entire dataset for ex:for dataset daily1 has ins_date is 01/01/2011 there will be no other date for it. ex Dset_name Ins_Date count daily1 01/01/2011 135 daily2 02/01/2011 231 .... like that ... View more

data a; input id s $ 3-118; datalines; 1 prg-code,main,IT-Hardware,Ins,Main,Non_IT- ,WOrk-Hardwrk,giveup,main,doit, -Nowork,ceo-cash,main,user,repair,nonit, run; LOGIC :I WANT TO MOVE IT IN TO ANOHTER ROW BASED ON "- "(HI FUN) BEFORE HIFUN FIRST COMMA . i wnat it in data set a2 as output: 1 prg-code,main 1 IT-Hardware,Ins,Main 1 Non_IT- 1 WOrk-Hardwrk,giveup,main,doit 1 -Nowork 1 ceo-cash,main,user,repair,nonit ... View more

data a; input id s $ 3-118; datalines; 1 prg-code,main,IT-Hardware,Ins,Main,Non_IT- ,WOrk-Hardwrk,giveup,main,doit, -Nowork,ceo-cash,main,user,repair,nonit, run; LOGIC :I WANT TO MOVE IT IN TO ANOHTER ROW BASED ON "- "(HI FUN) BEFORE HIFUN FIRST COMMA . i wnat it in data set a2 as output: 1 prg-code,main 1 IT-Hardware,Ins,Main 1 Non_IT- 1 WOrk-Hardwrk,giveup,main,doit 1 -Nowork 1 ceo-cash,main,user,repair,nonit ... View more

i am having data having A_NEW DATA SET WITH comma IN NAME AND AGE VARIABLES. DATA A_NEW; INPUT id$ no$ name$ age$; CARDS; 3 10 a,b,c 10,11,12 2 11 e,f,g 11,15,16 12 12 w,r,t 1,2,3 14 13 p,m 4,5 15 14 a,b,c,d,e 1,2,3,4,5 RUN; vARIABLES NAME IS HAVING VALUES WITH COMMAS IN IT AND AGE IS ALSO HAVING COMMAS IN IT i want the output in like this,but i dont know the number of commas ARE THERE AS THE NAMES VARIABLE IS HAVING 3 COMMA OR 5 OR 6 COMMAS IT SHOULD BE MOVED TO ANOTHER LINES BASED ON THAT COMMAS AS I AM HAVING HUGE DATA i WANT TO CREATE DATA SET B_NEW LIKE THIS DATASET B_NEW Output: id no name age 3 10 a 10 3 10 b 11 3 10 c 12 2 11 e 11 2 11 f 15 2 11 g 16 12 12 w 1 12 12 r 2 12 12 t 3 14 13 p 4 14 13 m 5 15 14 a 1 15 14 b 2 15 14 c 3 15 14 d 4 15 14 e 5 ... View more

i am having data having A_NEW DATA SET WITH comma IN NAME AND AGE VARIABLES. DATA A_NEW; INPUT id$ no$ name$ age$; CARDS; 3 10 a,b,c 10,11,12 2 11 e,f,g 11,15,16 12 12 w,r,t 1,2,3 14 13 p,m 4,5 15 14 a,b,c,d,e 1,2,3,4,5 RUN; vARIABLES NAME IS HAVING VALUES WITH COMMAS IN IT AND AGE IS ALSO HAVING COMMAS IN IT i want the output in like this,but i dont know the number of commas ARE THERE AS THE NAMES VARIABLE IS HAVING 3 COMMA OR 5 OR 6 COMMAS IT SHOULD BE MOVED TO ANOTHER LINES BASED ON THAT COMMAS AS I AM HAVING HUGE DATA i WANT TO CREATE DATA SET B_NEW LIKE THIS DATASET B_NEW Output: id no name age 3 10 a 10 3 10 b 11 3 10 c 12 2 11 e 11 2 11 f 15 2 11 g 16 12 12 w 1 12 12 r 2 12 12 t 3 14 13 p 4 14 13 m 5 15 14 a 1 15 14 b 2 15 14 c 3 15 14 d 4 15 14 e 5 ... View more

Hi i am having dataset wrk in that i am having two variables id and main_obs for ex 1 typist,-type,printing,computer-coding,writing, -nowork,driver-driving,caring,ceo-mainhead,cordinator,work-,asstgm-lesswrk,maintanace like this line is 300 in length i wnat out put like this as the - can be used as a delimiter form the last comma(,) and hifen(-) output: id Main_obs: 1 typist-type,printing 1 computer-coding,writing 1 -nowork 1 driver-driving,caring 1 ceo-mainhead,cordinator 1 work- 1 asstgm-lesswrk,maintanace ... View more

Hi In a variable i am having 3 obs down,open,enter Data l; input name age; down 45 open 67 enter 89 open 67 down 45 enter 90 open 56 run; if down and continuing with open then down-open like that if enter continuing with open the enter-open like that i want ... View more

HI i am importing data from folder there are differnt folders 0610,0710,0810 like this folder names are there i am importing data from folders.Now i want a monyr variable from which folder that dataset was created. FOr ex from folder :0610 The monyy variables is 0610 for that dataset like thar..... ... View more

Hi I am having 40 text files in a folder with all same variables now i want to create all Text files to sas datasets with the name of the Text file names,how can i do for all them at once the text files are of differnt names a1,mmk,gds,9678c,kl89. As again the text files will be dumped day by day as the no will increse to 5000 how can i do for this. ... View more

Hi i am having a dataset having two vaiables no and name of city .i am having 30000 incremantal data of number if no is increasing then no city 234 mumbai 123 chennai 999 Hyderabad . . . 12456 Delhi 32455 Bhopal As the city is increasing it should create a format as 1=Mumbai 2=chennai like that.... the no of city names are there. ... View more

Hi i am having 2 dates i want it to be outputted in year and month for ex: a='01jan1990'd; b='31jul1992'd; c= 2 years 6 months i want the output like this 2 years 7 months in to new variable ... View more