BookmarkSubscribeRSS Feed
Imroze
Fluorite | Level 6

3

1HI

I am creating a bill where I have to use row_start, row_end, row_span, Column_span and other options.  (one observation with multiple columns--billnumber,billdate,billperiod,storeid,.......)

My Question) Is there any possibility to achieve this by proc report (as procs are much faster than data step).

Ex bill

store Name and Addressbillnumberbilldate
xyz
xyz corporatio, road no 10,....
10112132131
customer idbill period
123123s1f32- 1213213

        

Question 2 ) Is there any possibility to create parse (prxparse) for local numbers , std numbers , isd numbers as the data given was huge millions of numbers... and is taking time to search for the numbers.

Thank You


3 REPLIES 3
Cynthia_sas
SAS Super FREQ

Hi:

  Depending on the layout you want, you can create a table using PROC REPORT fairly easily. However, if you want the layout that you show above with no column under the billdate for the customer id information, then your only alternative is the Report Writing Interface.

  I don't understand your Question 2. Why do you have to search for numbers? In question #1, it seems like your data is already together. Do you need to only print certain bills based on date or some other criteria. Can you post some sample data?

cynthia

Imroze
Fluorite | Level 6

HI Cynthia ,

for question1 yes it is monthly bills generated based on customer request dates.  I got the answer . Thank you.

For question 2 .  I have two databases where in 1 st one will have called or dialled numbers,  the 2nd database has defined telephone numbers such as numbers starting series with 9900 to 9999 are local 8800 to 8899 are local or std .

Thank you

Ksharp
Super User

Post an example to illustrate it more .  It looks like you need  proc format  or Hash Table.

Xia Keshan

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1093 views
  • 3 likes
  • 3 in conversation