We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
5 6674What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;
3 5239You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..
3 5381You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?
2 4361The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
1 4748How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
2369
it will become easy if uuu provide website linkssss and list of consultanciessssss
what are _numeric_ and _character_ and what do they do? : Sas programming
How do dates work in SAS data?
What are all the problems you faced while validating tables and reports?
What is the work of tranwrd function?
How do you specify the number of iterations and specific condition within a single do loop?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
How does proc sql work?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What commands are used in the case of including or excluding any specific variables in the data set?
What is a macro routine?
What do the PUT and INPUT functions do?
explain the use of % includes a statement in sas? : Sas-administrator
where are dashboard components are created and maintained? : Sas-bi
what is the difference between infile and input? : Sas-administrator