Hi All, I have got one reference  graph to create similar output (attached is the graph) , but not sure what type of graphs is it.(assuming it as scatter plot, not sure) . As per the attached graph values on X- axis represents each state code(numeric value) and the y-axis values are percentage of cars present in each state (two different companies X and Y). May i know how the 0% values are represented on above x-axis and vertical lines from 0 to the respective percentages or sometimes the corresponding percentage is in between. Colour represents companies X and Y. Any sample code/suggestions how to generate this and what this graph is called. Thanks in advance for suggestions ... View more

Hi All ,    I have a variable and this variable is printed using proc report. Using call define to highlight the particular value of the entire string. But call define is highlighting the entire observation instead of particular string. From the below example I have a string "I know SAS programming". In this string i need to highlight only the SAS keyword  and this word is present in another variable to differentiate this in the original string. Call define is not allowing to highlight particular keyword in the string. Any suggestion/alternative to highlight only a specific word in the string as    data compare; length str1 $64; str='I know SAS programming'; str1='SAS*'; output; str='Python programming ac'; str1='Python*'; output; str ='SAS and R programming' ; str1='SAS and R*'; output; run;   Required output: Highlighting only the specified keywords from another variable Str1 Str2 SAS* I know SAS programming Python* Python programming  SAS and R* SAS and R programming   ... View more

Hi All,   We generally create new variables using assignment statement. When the specified variable is not present in the data step we get an uniniitalized note in the SAS log. But the requirement is to generate an ERROR in the log if the specified variable is not present while creating new variable using assignment statement. Any ideas on this. data want; set sashelp.class; new=gender; run ; NOTE: Variable gender is uninitialized. NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set WORK.WANT has 19 observations and 7 variables. NOTE: Compressing data set WORK.WANT increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. ... View more

data have ; have="function=practical, param1=yes, param2=freason, param3=Event,join=usubjid"; output; have="function=practical, param=1"; output; have="function=practical, join=usubjid"; output ; run ;   In the above example the specification have different parameters, out of which i have to identify only the parameters starting with param like param,param1,param2,param3 etc and to create the macro variables assigned to the respective variables. For example in the first observation there are 3 paramenters which are having variables starting with param like param1,2,3 and macro variables will be created only for these 3 variables by considering the values assigned to them on right hand side after '=' symbol . Similarly in 2nd onservation only one variable is present , so only one macro variable associated wiht param will be created and in third observation since there is no variable starting with param, no macro variable will be created. Any suggestion how to separate them and create macro variables starting with param and the same macro variables will be used in subsequent steps. ... View more

Hi All , I am using VTYPE and PUTN function in IF-THEN-ELSE condition ,output is fine , but have a doubt in the execution as below, since it is throwing a NOTE in the log ,which should not happen. data want; set sashelp.rent; if vtype(date)='N' then mdate=putn(date,vformat(date)); else if vtype(date)='C' then mdate=scan(date,1,'T'); run ; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 26:42 NOTE: There were 10 observations read from the data set SASHELP.RENT. NOTE: The data set WORK.WANT has 10 observations and 3 variables. NOTE: Compressing data set WORK.WANT increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. Concern: As per the data, the DATE variable is numeric and it is getting satisfied in the first IF condition. But why it is checking for second ELSE IF condition and throwing a NOTE (Numeric conversion) in the log. Similarly in the below condition also , when the first IF condition is not satisfied but still executing with a NOTE (Character conversion ) in the log .Ideally it should not happen , what could be the issue for this if-then-else conditions and how to resolve it with out any CONVERSION notes in the log. data want1; set want; if vtype(mdate)='N' then mdatenew=putn(mdate,vformat(mdate)); else if vtype(mdate)='C' then mdatenew=mdate; run ; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 25:41 NOTE: There were 10 observations read from the data set WORK.WANT. NOTE: The data set WORK.WANT1 has 10 observations and 4 variables. NOTE: Compressing data set WORK.WANT1 increased size by 100.00 percent. Compressed is 2 pages; un-compressed would require 1 pages. ... View more

Have embedded my COMMENTS in the codes, to get an understanding of my requirement. /*8 observation from Shoes dataset*/ data shoes; set sashelp.shoes; if region='Canada' and Subsidiary='Montreal'; run ; /*8 observations from org dataset since same data replicated*/ data org; set sashelp.shoes; if region='Canada' and Subsidiary='Montreal'; run ; /*TASK: JOINING both the datasets to get the count of PRODUCT variable and storing the result in CNT variable using COUNT FUNCTION. Since there are only 8 observation the CNT should also be 8,but because of CARTESIAN product CNT variable is showing 64 . Different results with different usage of DISTINCT function*/ /*Scenario 1 Not using DISTINCT getting 64 observations in the dataset and CNT varaible has 64 observations*/ proc sql noprint; create table want1 as select org.region ,shoes.product ,shoes.Subsidiary,shoes.stores, count(shoes.product) as cnt from org as org left join shoes as shoes on org.region = shoes.region group by org.region order by org.region; quit; /*Scenario 2 using DISTINCT getting 8 observations and CNT variable has 64 observations */ proc sql noprint; create table want2 as select distinct org.region ,shoes.product ,shoes.Subsidiary,shoes.stores, count(shoes.product) as cnt from org as org left join shoes as shoes on org.region = shoes.region group by org.region order by org.region; quit; /*Scenario 3: using DISTINCT at COUNT level getting 64 observations and CNT variable has 8 observations */ proc sql noprint; create table want3 as select org.region ,shoes.product ,shoes.Subsidiary,shoes.stores, count(distinct(shoes.product)) as cnt from org as org left join shoes as shoes on org.region = shoes.region group by org.region order by org.region; quit; /*Scenario 4: using DISTINCT at COUNT level getting 8 observations and CNT variable has 64 observations */ proc sql noprint; create table want4 as select distinct org.region ,shoes.product ,shoes.Subsidiary,shoes.stores, count(distinct(shoes.product)) as cnt from org as org left join shoes as shoes on org.region = shoes.region group by org.region order by org.region; quit; My requirement is NOT TO use DISTINCT at COUNT function but to get the COUNT(CNT) value as 8 since the actual count is only 8 in the dataset. If we use distinct at COUNT FUNCTION we will get 8 . But i have customer requirements to use both DISTINCT and without DISTINCT but my current issues is not to USE DISTINCT at COUNT function to get 8 as CNT value though 64 observations are present. Any other alternative/solution for this. ... View more

I have a string as below  with variable names embedded in square brackets and plain text in quotes.Need to apply the coalescec function for identifying the first non missing values. I have used the do loop , SCAN and COUNTW function for identifying the variables , separating and using a strip for each variable and for differentiation of the variable names and text in quotes. Is there any simpler way to perform with one/two line of code to get the required output as shown. HAVE is the column with the string and WANT is the OUTPUT  in simple steps.Variables and Text can be in any order.   HAVE WANT (values=[DECOD] [TEXT]) VAR=coalescec(strip(DECOD),strip(TEXT)) (values=[DECOD] [TEXT] "NOT REPORTED") VAR=coalescec(strip(DECOD), strip(TEXT), "NOT REPORTED") (values= "NOT REPORTED" [DECOD]  "Zero data"[TEXT] ) VAR=coalescec("NOT REPORTED",strip(DECOD), "zero data",strip(TEXT) ) (values= [TEXT] "Not Reported,NOW" [DECOD]  ) VAR=coalescec (strip(TEXT) "Not REPORTED,Now" , strip(DECOD) ) ... View more

I got an XLSX file from third party and trying to import it in SAS EG using proc import/Libname methods but it does not work.If i open the XLSX file and SAVE AS with the same name also it works. Is there are any UNIX command applied in SAS to SAVE AS the XLSX file in the same location through SAS program without any manual intervention. Any other alternative to SAVE AS the XLSX file or recreate the XLSX file in the same location without manual intervention through UNIX commands in SAS or any other approach to make the file work. ... View more

I have duplicate words in a string which mimics other words with a minor differences in characters. But while identifying them using FIND/FINDW function it is considering both as same words and removing them.For example JAPAN and JAPANESE are both distinct words present in the same string , when trying to identify them using FIND/FINDW function both considered as same word and deleting one of them, but ideally both of them are different words. Same for FATEST and FATESTCD.How to identify the exact match to remove the duplicate words using FIND/FINDw or PRXMATCH functions data have; input string :$200.; infile datalines dlm=','; datalines; apple orange kiwi apple grapes strawberry peach kiwi peach China USA UK Australia Japanese USA UK Australian Japan Chinase FOOTBALL BasketBall basketball Hockey football FACAT FATESTCD FATEST FAOBJ STDT STDTC VISIT VISITNUM ; data want(keep=string newstring); set have; newstring=scan(string, 1, ' '); do i=2 to countw(string,' '); word=scan(string, i, ' '); found=find(newstring, word, 'it'); /* fnd=findw(newstring, word, 'it');*/ if found=0 then newstring=catx(' ', newstring, word); end; run;    ... View more

I have a string with a combination of both variable names and string separated by multiple delimiters as below. Sometimes the sub-string are separated by space and some times by comma (,). These have to be identified and separate the variables and sub string into each unique variable. Commas and spaces are also part of the sub-string when embedded in quotes as below .    data have ; Have='SIFI " " SIUNIT " (" ATOX ", " GRADE ")"' ;output Have='SIFI, " " SIUNIT " (", ATOX ", " GRADE ")"' ;output run ; Required Output: Each variable or substring should be separated into individual variable var1 var2 var3 var4 var5 var6 var7 var8 SIFI " " SIUNIT " (" ATOX ", " GRADE ")" Thanks in advance for your inputs  ... View more