About Rahul_SAS

Rahul_SAS · ‎09-05-2017

I have got this solution...if anyone need please let me know.

Rahul_SAS · ‎08-30-2017

Hi Experts, I have a LASR Table with Zero records(observations), means it has all the variable names but no rows so is it possible to get "No Data Available" notified on the report (Report Viewe). thanks

Rahul_SAS · ‎08-24-2017

what do you mean by IWA??

Rahul_SAS · ‎08-23-2017

Thank you sooo much kiwi_colin for your prompt reply. I have already used the solution you have mentioned above. The problem persist even after converting that variable into category as I mentioned in my post that its showing in Category segment only. I am not able to use that converted categorical variable as categorical variable its still coming as Measure when I try to use that in a Calculated column or Filter Expression. -thanks

Rahul_SAS · ‎08-23-2017

Hi Experts, I am using text search box with parameter so that its giving me the results based on my input charactes in the text box. But I also want the suggesstions based my text input so that the suggestions will be reduces as long as i increase the number of character intries same as if we use a categorical variable in text input and provided some input search characters, it starts giving the list of suggestion like Drop Down List Control. Please Help. -Rahul

Rahul_SAS · ‎08-23-2017

Hi Experts, I using variables Sr No, Emp Code as category that contains all numeric values(like 0001-9999 and 40000-70000) so converted before bringing into LASR and its showing under Category also. But when I am using these variable in calculated column or filter expression its coming as Measure. Actually I want parameterise my report search using these variables so using these variable in filter expression with parameter like: (Emp ID) Contains (Parameter Emp ID) but its coming as measure so not able to use Contain function. Couldn't figure out the problem. Please help. -Rahul

Rahul_SAS · ‎08-23-2017

Hi Experts, I using variables Sr No, Emp Code as category that contains all numeric values(like 0001-9999 and 40000-70000) so converted before bringing into LASR and its showing under Category also. But when I am using these variable in calculated column or filter expression its coming as Measure. Actually I want parameterise my report search using these variables so using these variable in filter expression with parameter like: (Emp ID) Contains (Parameter Emp ID) but its coming as measure so not able to use Contain function. Couldn't figure out the problem. Please help. -Rahul

Rahul_SAS · ‎08-22-2017

I already converted that measure as category and its available in Category segmant only but still when using in a filter its coming as measure.

Rahul_SAS · ‎08-22-2017

hi bruno_sas, could you please help me to convert a measure into category. I have a variable which falls in Category and contains 1001, 1002, 1003 etc. but when using this variable in calculated item it shows as measure.

Rahul_SAS · ‎08-21-2017

Hi Madely_SAS, I am able to build this logic thanks for sharing this information. Adding to this, I am required one more facility on this i.e. when I type anything this should give me list of suggestion like drop down list so that the search would be more efficient as the user will start getting the relevent search in one go. Otherwise, user has might get larger details and has to make another search with some more relavent keywords. Thanks

Rahul_SAS · ‎07-11-2017

ignore the previous output...i want output like.. ExposureId LimitId CollateralId ClusterId 1 L1 C1 1 2 L1 C2 1 3 L2 C1 1 4 L2 C3 1 5 L3 C4 2 6 L3 C5 2 7 L4 C6 3 8 L5 C5 2 Thank You

Rahul_SAS · ‎07-11-2017

Hi All, I have the data like ExposureId LimitId CollateralId 1 L1 C1 2 L1 C2 3 L2 C1 4 L2 C3 5 L3 C4 6 L3 C5 7 L4 C6 8 L5 C5 and want the output like ExposureId LimitId CollateralId 1 L1 C1 2 L1 C2 3 L2 C1 4 L2 C3 5 L3 C4 6 L3 C5 7 L4 C6 8 L5 C5 Please help.

Rahul_SAS · ‎02-08-2017

but as i know, your cant use numeric variables in the drop down list.

Rahul_SAS · ‎01-03-2017

Hi Experts, I am trying to get all combinations of words in preceding order available in a given string e.g. Suppose I have a string like "The cow jumps over the moon" and want combinations like.. The cow The jumps The over The the The Moon cow jumps cow over cow the cow moon jumps over jumps the jumps moon over the over moon the moon please help me to achieve the same.. I m trying the following code: data test; sen = "The cow jumps over the moon"; run; data test1; set test; length sen1 $100.; sen1=""; retain sen1; do i=0 to count(compbl(TRIM(sen))," "); do j=1 to 2; sen1=compbl(sen1||" "||compbl(trim(scan(compbl(TRIM(sen)),i+j," ","MO")))); ngram= j; r=count(TRIM(sen)," "); x=count(compbl(TRIM(sen))," "); output; end; sen1=""; end; if ngram=2; run; Thnx Rahul

Rahul_SAS · ‎12-25-2016

Dear Experts, I have got a task which I am not able to solve please help me to get the result: There are 10 or so datasets availble in SASAPP named Jan, Feb,...Sept, Dec. I have to upload all the datasets into lasr and append them so please help me to write that program whick will load the data into LASR. for a single dataset is use SASIOLA, SAS LASR Engine and able to load a dataset quite easily but not multiple so please help. Thnx Rahul

Online Status	Offline
Date Last Visited	‎01-28-2025 04:46 PM

Array with Nested Loops

Re: date difference between 0001-01-01 and 2023-01-01

date difference between 0001-01-01 and 2023-01-01

Join table with case when

Re: Getting exponential value

Re: Getting exponential value

Getting exponential value

LASR Vs CAS Vs Micro Analytics Services

Reading Multiple CSVs

Re: Automated Incremental Load

Re: Getting exponential value

Re: Reading multiple csv files

Re: Spliting a string with all upper case

Re: A New Date Field Required

Re: why repeated observations??

Re: Converting a category to a measure in VA (character to numeric)

Re: Converting a category to a measure in VA (character to numeric)

delete rows from a LASR table

Re: Population "No Data Available"

Population "No Data Available"

Re: how do i resolve visual data builder fatalconnectionfactoryexcepti...

Re: Measure to Category conversion in SAS VA

getting suggetion list while using parametrise text search

Measure to Category conversion in SAS VA

Measure to Category conversion in SAS VA

Re: Converting a category to a measure in VA (character to numeric)

Re: Converting a category to a measure in VA (character to numeric)

Re: VA "contains" search in input text box

Re: Getting the Clustured ID

Getting the Clustured ID

Re: Measures in Drop down list.

making all possible combinations of all words from a given string(N-Gr...

Loading and appending multiple table in to lasr from SASAPP