Hi All,   I am trying to insert rows in SQL Server DB using SAS SQL Pass through facility. The below code works fine in SQL but I am not sure what I am missing while I am incorporating it in SAS. Could you please tell me the appropriate changes to be made in SAS. USE [SDMS] GO INSERT INTO [sur].[FactSurveyTotal] ([SurveySK] ,[TotalTypeNm] ,[TotalSubTypeNm] ,[DOSTotalCnt] ,[EDWTotalCnt] ,[WithNAPct] ,[WithoutNAPct] ) VALUES ( (SELECT SurveySK FROM sur.DimSurvey where SurveyYearNum='2020' AND SurveyTypeNm='Physician') ,'Test Type' , 'Test SubType' ,1 ,2 ,3 ,4 )   With  proc sql; connect to odbc(dsn="XXXXXX" user=XXXX password="XXXXX" ); ( ABOVE SQL CODE ); QUIT; Am I missing anything or should I modify the sql code in any way ?   Thank you, Prad ... View more

Hi Team, I need help in replacing the position of old variable with the new variable.      Example:  DATA NEW(DROP=make); SET SASHELP.cars; DROP TYPE Horsepower; Type_new='All'; Horsepower_new=1000; RENAME Type_new=Type Horsepower_new=Horsepower; RUN; In the above example:  The new variables are positioned at the end of the dataset. But, I want these variables to be in the same position i.e., at the original horsepower and type position(which are dropped in the data step). How do we do that in the same data step? Please note that the drop variables (data set option) and the new variable creation would be changing depending on the requirement. This should be dynamic in a way.    Thank you, Prad ... View more

Hi All,   I am trying to parallelize a program but there is a ODS Step in the loop which creates 1 shtml file, 1 .gif file for each unique row and also it creates **ONLY ONE** sasgraph.gif file.   If you look at the below code., the shtml file name is mentioned in the file statement and I can add an modify the name of it.   And the .gif file output is named as capabil1.gif capabil2.gif... etc.. But, there is no reference for naming .gif and sasgraph.gif files..    Please, let me know how to change the names of the .gif and also, I am trying to understand how does the sasgraph.gif file is created and also, how to control that sasgraph.gif file creation process.       goptions hsize=8in vsize=6in device=gif rotate=landscape chartype=5 gsfname=; symbol1 c=DEFAULT l=1 w=1 v=dot c=blue h=1.5 pct i=join; filename gout "/amd/ausaph17/24/wetspcm/progs/bynoloops/"; ods html body="&tech._&device._&hname._ppk_graph.shtml" contents="" frame="" base="" gpath=gout path=gout gfootnote newfile=none style=Rick3d; title "&tech &device &name"; title2 "DispoLow = &spel DispoHigh = &speh"; title3 "Updated &fdate &systime"; title4 "Date Range: &mindate to &maxdate"; proc capability noprint data=lot1(WHERE=(device="&device" AND name="&name" AND tech="&tech")); spec lsl = &spel usl= &speh clsl = red cusl = red; var buckvalue; output out=capdev cp=cp cpk=cpk cpl=cpl cpu=cpu mean=mean std=std pctgtr=pctgtr pctlss=pctlss n=n; histogram / normal (noprint) href=&spel &speh nolegend; inset n cpk mean cpl std pctgtr cp pctlss / position=bm height=2 format=9.4; run; ods html close; Thank you so much in advance, Prad ... View more

From the below example:  I need to create a new variable called city1 with all the observations after the value "##$$%%**--".   DATA NEW; INPUT city $; cards; u3jZdcVN 0nnmdOz 7MxtrQjCXR wCKbhZM ##$$%%**-- city_dec CHICAGO CHICAGO ELGIN CHICAGO CHICAGO ; RUN; Thank you, Prad ... View more