Hi everyone,   i have below code. where i am performing append and insert on a dataset cls. the program ends with error table damage. Could any one advise how to achieve multiple operation on a common dataset at a sametime with multiple users/jobs. Thanks in advance!!   code: user1 submit : libname abc  "c:\temp" ;   data abc.cls; set sashelp.class; run; options mprint mlogic symbolgen; %macro loop; %do i=1 %to 1000; proc append base=abc.cls data=sashelp.class force; run; %end; %mend; %loop;   user2 submit: libname abc2 "c:\temp";    %macro loop; %do i=1 %to 1000;           proc sql noprint; insert into abc2.cls set name="subbu",sex='M',age=29 ,weight=. , height=.; quit; %end; %mend; %loop;   ... View more

Hi Folks,   As past of new requirements within the project i am trying to establish a connection from SAS EG(8.3) to Azure DataBricks. Could any one help me with step by step approach, prerequisites etc.   Thanks in advance!! ... View more

i have a dataset  as below; data city; input TIMEZONE:$20. STATE:$20. CITY:$20. POPULATION; infile datalines dlm=' ' dsd; datalines; Alaska Alaska Anchorage 291826 Atlantic Puerto Rico San Antonio 1327407 Atlantic Puerto Rico San Juan 395326 Central Minnesota Minneapolis 382578 Central Texas Dallas 1197816 Eastern Florida Miami 399457 Eastern Maryland Baltimore 620961 Eastern Michigan Detroit 713777 Eastern New York New York 8175133 Mountain Arizona Phoenix 1445631 Mountain Colorado Denver 600158 Mountain Texas El Paso 649121 Pacific California Los Angeles 3792621 Pacific California Sacramento 466488 Pacific California San Francisco 805235 Pacific Nevada Las Vegas 583756 ;   the final output should be like    TIMEZONE STATE CITY POPULATION CUMUL_POP Alaska Alaska Anchorage 291826 291826 Alaska Alaska Total 291826 291826 Alaska Total   291826 291826 Atlantic Puerto Rico San Antonio 1327407 1619233 Atlantic Puerto Rico San Juan 395326 2014559 Atlantic Puerto Rico Total 1722733 2014559 Atlantic Total   1722733 2014559 Central Minnesota Minneapolis 382578 2397137 Central Minnesota Total 382578 2397137 Central Texas Dallas 1197816 3594953 Central Texas Total 1197816 3594953 Central Total   1580394 3594953 Eastern Florida Miami 399457 3994410 Eastern Florida Total 399457 3994410 Eastern Maryland Baltimore 620961 4615371 Eastern Maryland Total 620961 4615371 Eastern Michigan Detroit 713777 5329148 Eastern Michigan Total 713777 5329148 Eastern New York New York 8175133 13504281 Eastern New York Total 8175133 13504281 Eastern Total   9909328 13504281 Mountain Arizona Phoenix 1445631 14949912 Mountain Arizona Total 1445631 14949912 Mountain Colorado Denver 600158 15550070 Mountain Colorado Total 600158 15550070 Mountain Texas El Paso 649121 16199191 Mountain Texas Total 649121 16199191 Mountain Total   2694910 16199191 Pacific California Los Angeles 3792621 19991812 Pacific California Sacramento 466488 20458300 Pacific California San Francisco 805235 21263535 Pacific California Total 5064344 21263535 Pacific Nevada Las Vegas 583756 21847291 Pacific Nevada Total 583756 21847291 Pacific Total   5648100 21847291   i have coded as below but not able to get the intermidiate summary:   proc sort data=city; by timezone state; run; data want; set city; by timezone state; if first.state then cum_pop=0; cum_pop+population; run;   could anyone please provide the solution both in proc sql as well as data step. Thanks in advance!! ... View more

i have data as below    data class; input Name$ Sex$ Age Height Weight; infile datalines dlm=' ' dsd; datalines; Alfred M 14 69.0 112.5 Alice F 13 56.5 84.0 Barbara F 13 65.3 98.0 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 ; data zipcodes; input name $ zipcode; infile datalines dlm=' ' dsd; datalines; Alfred 91940 Alice 75008 Barbara 92330 Carol 94150 Henry 93140 ; data cities; input zipcode City :$30. Department :$30.; infile datalines dlm=' ' dsd; datalines; 75008 Paris 8è Paris 91940 Les Ulis Essonne 92330 Sceaux Hauts-de-Seine 93140 Bondy Seine-Saint-Denis 94150 Rungis Val-de-Marne ; i  wand the output as   Name ZipCode City Department Alfred 91940 Les Ulis Essonne Alice 75008 Paris 8è Paris Barbara 92330 Sceaux Hauts-de-Seine Carol 94150 Rungis Val-de-Marne Henry 93140 Bondy Seine-Saint-Denis   i have coded as below but not able to make it happen:   data need(keep=name zipcode city department); if 0 then set zipcodes cities; if _n_=1 then do; dcl hash z(dataset:'zipcodes'); z.definekey('name','zipcode'); z.definedata(all:'Y'); z.definedone(); dcl hash c(dataset:'cities'); c.definekey('zipcode'); c.definedata(all:'Y'); c.definedone(); end; do until(eof); set class end=eof; if z.find(key:name,key:zipcode)=0 and c.find(key:zipcode)=0; end; stop; ... View more

i have the below code, which generate column O as 1 for 300 observations. But i want to get an output in such a form like o=1 for (1 to 6) obs and o=2 for (7 to 12) obs  and so on o=50 for obs (295 to 300).   Could any one help me regarding the same. Thanks in advance!!.   data temp; do i=1 to 300 by 6; do j=i to i+5; o=1; output; end; end; run; ... View more