If I only wanted the results that you are talking about in a printed form, then I would use Proc Tabulate to produce a Summary Table. However, the column headings will look different from your description.
To produce a Summary Table in SAS Enterprise Guide, make your data table active by clicking on it. Then from the Menu bar, select Describe > Summary Tables.
Under Task roles make ID, Date, and Time the classification variables and US the analysis variable.
At this point, I wish I could just cut and paste what the Summary table layout looks like but I cannot.
So here goes the steps for the desired layout.
Select Summary Tables in the selection pane. Now you want to drag the variables under "Available variables" to the Preview area. Drag the variable Time to under the Box area to make it the Row Variable. Drag the variable US to the right of the box area to make it a column variable. Drag Sum (Sum of values) from under "Analysis Variables" to replace the N (the number of values). Because you only have one value for each ID, date, and time, the sum of the value works. Drag Date over the US variable. Drag ID over the Date variable. If you don't get it quit right, don't forget about the undo arrow on the right of the preview area or right click a cell and select "Remove cells".
Click run and see if that is what you want.
However, if you want it as a table similar to what you said above, here are the steps.
First of all, if you have not already entered the data, I would just enter the ID values as 1, 2, etc. and not as No. 1, No. 2.
Make your data table active and select Data>Filter and Query. Add all the columns to the query under the tab "Select Data".
Next you want to add some computed columns. As was pointed out earlier, it is better to have the column names as regular SAS variable names so they will not have periods or spaces. Therefore, to get what you want, we will create two computed columns, one to use to create the column name and one to create the label for the column name.
(You may have to tell SAS Enterprise Guide that you want to use labels as the column names. I cannot remember if that is the default or not. To do that, go to Tools>Options >Data General and check use labels for column names.)
I created two computed columns. These are the names and the formulas used to build the expression.
IDdatelabel cat('No. ',id,' ', put(date,date7.))
IDdate cat('No',id,'_', put(date, date7.) )
The results looks like:
ID Date IDdatelabel Time US IDdate
1 01JAN2006 No. 1 01JAN06 9 200 No1_01JAN06
1 01JAN2006 No. 1 01JAN06 10 300 No1_01JAN06
1 01JAN2006 No. 1 01JAN06 11 450 No1_01JAN06
1 02JAN2006 No. 1 02JAN06 9 150 No1_02JAN06
1 02JAN2006 No. 1 02JAN06 10 160 No1_02JAN06
1 02JAN2006 No. 1 02JAN06 11 200 No1_02JAN06
1 03JAN2006 No. 1 03JAN06 9 144 No1_03JAN06
1 03JAN2006 No. 1 03JAN06 10 122 No1_03JAN06
1 03JAN2006 No. 1 03JAN06 11 500 No1_03JAN06
2 01JAN2006 No. 2 01JAN06 9 235 No2_01JAN06
2 01JAN2006 No. 2 01JAN06 10 214 No2_01JAN06
2 01JAN2006 No. 2 01JAN06 11 145 No2_01JAN06
2 02JAN2006 No. 2 02JAN06 9 254 No2_02JAN06
2 02JAN2006 No. 2 02JAN06 10 789 No2_02JAN06
2 02JAN2006 No. 2 02JAN06 11 100 No2_02JAN06
2 03JAN2006 No. 2 03JAN06 9 500 No2_03JAN06
2 03JAN2006 No. 2 03JAN06 10 650 No2_03JAN06
2 03JAN2006 No. 2 03JAN06 11 450 No2_03JAN06
Next select Data>Transpose to transpose the data.
Select Task Roles.
Move US to Transpose variables.
Move IDdate to New column names.
Move Time to Group analysis by
Move IDdatelabel to New column labels.
Chose Options and uncheck Use Prefix.
Run the task.
Hopefully, I have included all of the steps and words and that this will help you. It is clear from this long description that often a picture is worth a thousand words.