About ncsthbell

ncsthbell · ‎03-14-2012

My first report has multiple prompts (5). Once the results are displayed in WRS, the users want be able to link to a second report using 2 of the prompts (vendor & type). I can get the linking to work with only 1 prompt (vendor), but not more than that. Was thinking if there was some way to create a concataned column of these 2 prompts (vendor, type) and somehow use this 'behind the scenes'? Any ideas on how to accomplish this? THanks

ncsthbell · ‎03-14-2012

I had to define the prompt in the Information Map for both reports that I was using in WRS. Apparently, it does not when you use a shared prompt created in SMC.

ncsthbell · ‎03-07-2012

Thanks, I'll try that.

ncsthbell · ‎03-07-2012

This works if I only include the Vendor & Invoice number. I have many more columns of data that I need, the Vendor & Invoice number are just keys that I would be looking to group by. I put the other columns on my select tab and since it is looking at each column on the select, I did not get what I need. I should have mentioned that I have other data I need on the select tab and the 'grouping' used for finding the lastest dated row would be by vendor# and invoice#.

ncsthbell · ‎03-07-2012

The data I am retrieving in the EG project has multiple rows for a 'Vendor# & 'Invoice#'. Each of these rows has a column with a date field 'Last_updated'. I need to be able to retrieve the row for this Vendor#/Invoice# with the latest date in the 'Last_updated'. I am trying to build this using EG query builder but I do not see a function that I can use to accomplish this. Any suggestions on how to accomplish this in EG? THanks

ncsthbell · ‎02-24-2012

I have a data item (is SSN) that is defined with character format. The ssn does NOT have any dashes, just numbers. I need to convert this to numeric without losing the leading zeros. I do not see any functions that would do this. Any suggestions on how I can accomplish this? Thanks!

ncsthbell · ‎02-22-2012

Thanks.... I will give this a try and let you know the results.

ncsthbell · ‎02-22-2012

I am sorry I left off that part!! The problem is that when I run 'rptB' as a linked rerport from 'rptA', I do not get any rows of data selected in the results. However, by running 'rptB' in WRS (not as a linked report) using the SAME value in the prompt as I used when I tried to run it as a linked report from 'rptA', I get 6 rows of data returned on the report, which is what I should be getting. Running it as a linked report gives me no results. Also, on the top of each report where it states "Applied Filters:', the filters match exactly when I run 'rptB' by itself or linked.

ncsthbell · ‎02-22-2012

I have created 2 reports: 'rptA' & 'rptB'. Each of these reports use the same shared prompt 'TID'. Both reports run and return the correct results for the value entered into the prompt 'TID' when they are run separately in WRS. I have created report linking in 'rptA' being the source report and 'rptB' as the destination report. In the report linking dialog box: 1. Checked the box 'Include report links in the table'. 2. Link destination: chose 'An existing report' 3. Drilled down and selected 'rptB'. 4. Under 'Set Up Destination Report' - Destination Report: has correct report name for 'rptB' - Open to section: shows 'section 1' (both reports only have one section) - Under Prompts: Data Items: The text for the prompt 'TID' is displayed with a drop down list of the report data items. I am selecting the data item that is associated with the 'TID' prompt. - clicked ok Seems pretty straight forward, just not working for me! I appreciate any suggestions or help!

ncsthbell · ‎02-22-2012

I read a note in the sas support knowledge base (62095) titled "Special Considerations for customers upgrading to SAS(R) 9.2" that states: "SAS Information Map Studio 4.2 cannot automatically convert prompt values to uppercase before a query is run." I have the need to do this conversion in my map. Can anyone tell me a work around or how can I accomplish this in my map?

ncsthbell · ‎02-08-2012

Not sure if this is the right 'community' to post this. I did not find one for "SAS Information Map Studio". If this is incorrect, please let me know where I should post this question. I have built a prompt in SAS Information Map Studio 4.2 that accepts user enter values. The data item the prompt is associated with is stored in uppercase text. I am having an issue of the report not returning rows because of the case. For example, they enter "Incoming" and the data item is stored as "INCOMING". I can not figure out how to capture the value the user enters and put the function 'UPCASE' on it. On the edit filter screen it looks like this: Filter name : note_topic_prompt Data item : note Condition : Like Values: Prompt user for values(s) &note_topic_prompt [note_topic_prompt] Can I convert whatever they enter into upper case or do they specifically have to enter upper case? Thanks

ncsthbell · ‎01-18-2012

Not sure if this is the right 'community' to post this. I did not find one for "SAS Information Map Studio". If this is incorrect, please let me know where I should post this question. I have created a map and I need to create a filter on one of the date data items. In the map, I want the filter to be 'Begin_dt <= current_date' and End_dt >= current_date'. I tried to build a filter by selecting 'New filter', I selected the data item "Begin_Dt", for the condition I selected "Is before or equal to", for Values I selected 'use and expression', then in the expression I used the date funtion so my expression looks like this <<Demographics.Begin_Dt>> <= DATE() and << Demographics.End_date >= DATE()>>. I get an error that says "is invalid and cannot be used in a query". Can you tell me what I am doing wrong? Or, is this something I can not do in Information Map? Thanks!

ncsthbell · ‎12-14-2011

Changed to format $8 Error generated in SAS EG: 19 (SUBSTR(PUT(t1.ACCOUNT_ID, $8.),1,3) 20 ) LENGTH=3 AS TP_ADDR_ACCTID_3 21 FROM ORACLDS.ADDRESS AS t1 22 WHERE t1.SOURCE_ID = 5 AND t1.HISTORY_FLAG = 'N' 23 ORDER BY t1.ENTITY_ID, t1.ADDRESS_ID; ERROR: Character format $ in PUT function requires a character argument. ERROR: Character format $ in PUT function requires a character argument.

ncsthbell · ‎12-14-2011

I am using SAS EG 4.2, our screens are a bit different so we must not be on the same release. I am still getting the decimal. No matter what I change the column format to, it makes it numeric. On the 2nd screen "Modify additional properties", I give the column & alias name and under 'column type' there are radio buttons for either Character or Numeric. I am chosing 'character'. On the 3rd screen, it still interprets it as numeric. When I hit the 'back' key and return to the 2nd screen, the radio button that I had set to 'character' has gone back to 'numeric. Here is the code generated (on 3rd screen) Alias: TP_NAME_ACCTID_3 Column: TP_NAME_ACCTID_3 Type: Numeric <=== shows as numeric even when I set the column type to character Format: None Length: Default Summary: None Expression: (SUBSTR(PUT(t1.ACCOUNT_ID, 8.),1,3)) My result is still coming as 3.5 I was going to send screen shots and couldn't figure out how to copy & paste them in the body of this as you did above. I can accomplish this in Oracle Sql but I am new to SAS and I just can't get it to work!

ncsthbell · ‎12-14-2011

I have a numeric column "ACCTID" defined as length 16, example value 3508777719876543. I want to extract the 1st 3 digits from the value and create a new column with it's contents. I have created a computed column named "ACCTID_3" using the following advanced expression: (SUBSTR(PUT(t1.ACCTID, BEST.),1,3)) and my result is 3.5 (the result I want is 350) ((I don't care if the result is numeric or character) In the advanced edit window, on page 2 of 3 titled "Modify Additional Options", the column type is defined as numeric, with 'none' for the format. I have changed this to column type 'character' and it does not like it. Can you please tell me what I am doing wrong? Any help would be greatly appreciated!!

Online Status	Offline
Date Last Visited	‎04-11-2016 09:58 AM

Re: Why am I getting error when using function 'length' to test a vari...

Why am I getting error when using function 'length' to test a variable...

Re: Need guidance for best way to capture user entered prompts and cre...

Re: Need guidance for best way to capture user entered prompts and cre...

Re: Need guidance for best way to capture user entered prompts and cre...

Need guidance for best way to capture user entered prompts and create ...

Re: When stored process using prompts runs on SAS portal can a message...

When stored process using prompts runs on SAS portal can a message be ...

Re: Can not get macro variable to resolve to correct value.

Can not get macro variable to resolve to correct value.

Re: General questions about using forum.

Using EG 4.2 - how to extract 1st 3 digits from numeric column?

Prompt not coming up when running query builder

Re: Trying to format column Proc Report using ODS TAGSETS.EXCELXP to c...

How to pass multiple prompts when using report linking (WRS 4.2)?

Problem with target report results using report linking and passed pro...

EG - Using query builder, how to get row with latest date value?

EG - Using query builder, how to get row with latest date value?

EG - Using query builder, how to get row with latest date value?

How can I convert a character value with leading zeros to numeric and ...

Problem with target report results using report linking and passed pro...

Problem with target report results using report linking and passed pro...

Problem with target report results using report linking and passed pro...

How to convert prompt value to uppercase in Information Map Studio 4.2...

How to convert user entered prompt value to upper case?

Can I create a date filter on an Information Map?

Using EG 4.2 - how to extract 1st 3 digits from numeric column?

Using EG 4.2 - how to extract 1st 3 digits from numeric column?

Using EG 4.2 - how to extract 1st 3 digits from numeric column?